Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-14354

Regression when using SELECT (EXISTS (...))

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: In Progress
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.10
    • Fix Version/s: None
    • Component/s: sql
    • Labels:
      None
    • Ignite Flags:
      Docs Required, Release Notes Required

      Description

      This worked as expected in 2.9.1:

       

      CREATE TABLE t (i int PRIMARY KEY, j int);
      SELECT (EXISTS (SELECT 1 FROM t WHERE t.i = 1)); 
      

      In version 2.10, I'm getting:

      SQL Error [1001] [42000]: Failed to parse query. Column "EXISTS1" not found; SQL statement:
      SELECT
      (EXISTS1)
      FROM SYSTEM_RANGE(1, 1) __Z0 
       LEFT OUTER JOIN PUBLIC.T __Z1 
       ON __Z1.I = 1 [42122-197]

      The workaround is to project an asterisk:

      SELECT (EXISTS (SELECT * FROM t WHERE t.i = 1));

        Attachments

          Activity

            People

            • Assignee:
              stalkxt Sergey Dorozhkin
              Reporter:
              lukas.eder Lukas Eder
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: