Allow whitespace between components of fully-qualified identifiers
Details
| Detail name | Value |
|---|---|
| Changelog Number | 11226 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 7.1.0 |
| Resolution Date | 2021-08-03 |
Improvement
Exasol now allows whitespace between the identifier parts and dots making up a fully-qualified identifier.
The following syntax example is now valid:
select dual . dummy from dual;
Changed behavior
1. You can now put whitespace between the identifier parts and dots for fully-qualified identifiers. (This is the change requested by this SPOT!)
2. If a fully-qualified identifier has a quoted component then some checks on the other components were not performed. This has been fixed, so the components of identifiers such as '"S".X$T1' and 'S.."C"' must now be quoted correctly as '"S"."X$T1"' and 'S.""."C"'.
3. A dot without any digits on either side used to be parsed as zero but now is not. So 'select . as ZERO' is no longer allowed.
