Conditions

1

Comparison conditions

Supported, with differences.

Differences exist when statements contain the ANY, SOME, and ALL operators. Oracle 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. However, GaussDB does not support the ERROR clause.
• The JSONB_EXISTS condition in GaussDB is the same as the JSON_EXISTS condition in Oracle. 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.

-