This subsection describes the notes on using JPQL.
Table 6-23 Three-valued-logic expression for AND (result of A AND B)
A | B | ||
---|---|---|---|
True | False | Unknown | |
True | True | False | Unknown |
False | False | False | False |
Unknown | Unknown | False | Unknown |
Table 6-24 Three-valued-logic expression for OR (result of A OR B)
A | B | ||
---|---|---|---|
True | False | Unknown | |
True | True | True | True |
False | True | False | Unknown |
Unknown | True | Unknown | Unknown |
Table 6-25 Three-valued-logic expression for NOT (result of NOT A)
A | Result of NOT A |
---|---|
True | False |
False | True |
Unknown | Unknown |
The examples of coding queries that cannot be used when JPQL is used in HiRDB are as follows:
Query query1 = em.createQuery( |
int no_A=2; |
int cmp_no=3; |