Uploaded image for project: 'EXASOL Roadmap'
  1. EXASOL Roadmap
  2. EXASOL-2871

Allow whitespace between components of fully-qualified identifiers

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Fix Version/s: Exasol 7.1.0
    • Component/s: None
    • Labels:
      None
    • Changed Behavior:
      Hide
      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.
      Show
      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.

      Description

      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;
      

        Attachments

          Activity

            People

            • Assignee:
              CaptainEXA Captain EXASOL
              Reporter:
              CaptainEXA Captain EXASOL
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: