Unfinished String-literals ignored at end of statement
Details
| Detail name | Value |
|---|---|
| Changelog Number | 10397 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 6.1.0, Exasol 6.2.0 |
| Fix Versions | Exasol 7.0.rc1, Exasol 6.2.9 |
| Resolution Date | 2020-07-21 |
Description
When a statement ends with an unfinished string-literal, i.e. a string literal where the finishing quote is missing, the query behaves as if the string literal was not there at all.
DATE and TIMESTAMP literals are affected by this as well.
The below query displays this behavior:
select 1 from dual where true 'abcd
Workaround
Adding the second quote to finish the string-literal will behave as expected, and the literal will not be ignored.
Fix
The query will return an error, as expected.
