IS JSON WITH[OUT] UNIQUE KEYS raises syntax error in WHERE clause
Details
| Detail name | Value |
|---|---|
| Changelog Number | 12163 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.0.0 |
| Fix Versions | Exasol 7.1.2 |
| Resolution Date | 2021-10-20 |
Description
If IS JSON WITH[OUT] UNIQUE KEYS is at the end of a statement and used in a WHERE clause, a syntax error is raised. This syntax is however correct.
Example:
SELECT 1 FROM dual WHERE 'a' IS JSON WITH UNIQUE KEYS;
Workaround
Remove the optional KEYS keyword from the query.
SELECT 1 FROM dual WHERE 'a' IS JSON WITH UNIQUE;
Fix
The query will not raise a syntax error.
