EXAplus parameter -x doesn't work for all syntax errors, causing wrong exit status
Details
| Detail name | Value |
|---|---|
| Changelog Number | 8283 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.0, Exasol 6.1.0, Exasol 6.2.0 |
| Fix Versions | Exasol 7.0.0, Exasol 6.2.3, Exasol 7.0.0-alpha1 |
| Resolution Date | 2019-10-10 |
Background
The exaplus commandline supports the parameter -x to immediately exit on any error and notify the calling process through a matching exit code.
Bug
This parameter doesn't work for some types of syntax errors, in particular incomplete queries (missing semicolon) and queries with additional text behind the semicolon. This also causes the exit status to be 0 (zero), indicating no error, instead of the expected value 2, indicating the error.