Conditions

This chapter describes common compatible conditions. The conditions include comparison, floating-point, logical, model, multi-set, pattern matching, NULL value, XML, SQL/JSON, composite, BETWEEN, EXISTS, IN, and IS OF TYPE, as shown in Table 1.

**Table 1** Conditions
No.	Oracle Database	GaussDB	Difference
1	Comparison conditions	Supported, with differences.	Differences exist when statements contain the ANY, SOME, and ALL operators. Oracle Database supports operations on list objects, but GaussDB needs to convert list objects into array expressions before performing operations.
2	Floating-point conditions	Not supported.	-
3	Logical conditions	Supported.	-
4	Model conditions	Not supported.	-
5	Multiset conditions	Not supported.	-
6	Pattern-matching conditions	Supported.	-
7	NULL conditions	Supported.	-
8	XML conditions	Not supported.	-
9	SQL/JSON conditions	Partially supported, with differences.	GaussDB does not support the IS JSON and JSON_TEXTCONTAINS conditions. The JSONB_EQ condition in GaussDB is the same as the JSON_EQUAL condition in Oracle Database. However, GaussDB does not support the ERROR clause. The JSONB_EXISTS condition in GaussDB is the same as the JSON_EXISTS condition in Oracle Database. However, GaussDB does not support the ERROR, EMPTY, or PASSING clauses.
10	Compound conditions	Supported.	-
11	BETWEEN condition	Supported.	-
12	EXISTS condition	Supported.	-
13	IN condition	Supported.	-
14	IS OF TYPE condition	Not supported.	-