Package org.h2.expression.condition
package org.h2.expression.condition
Condition expressions.
-
ClassDescriptionBETWEEN predicate.Boolean test (IS [NOT] { TRUE | FALSE | UNKNOWN }).Pattern matching comparison expression: WHERE NAME LIKE ?The type of comparison.Example comparison expressions are ID=1, NAME=NAME, NAME IS NULL.Represents a condition returning a boolean value, or NULL.An 'and' or 'or' condition as in WHERE ID=1 AND NAME=?An 'and' or 'or' condition as in WHERE ID=1 AND NAME=? with N operands.An 'in' condition with a list of values, as in WHERE NAME IN(...)Used for optimised IN(...) queries where the contents of the IN list are all constant and of the same type.A condition with parameter as
= ANY(?)
.An IN() condition with a subquery, as in WHERE ID IN(SELECT ...)A global condition or combination of local and global conditions.A NOT condition.Exists predicate as in EXISTS(SELECT ...)IS JSON predicate.Null predicate (IS [NOT] NULL).Base class for predicates with a subquery.Base class for simple predicates.Type predicate (IS [NOT] OF).Unique predicate as in UNIQUE(SELECT ...)