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

Regression when using derived table in LEFT JOIN

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • 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 used to work in 2.9.1 and no longer does in 2.10.0:

       

      CREATE TABLE t (i int PRIMARY KEY, j int);
      INSERT INTO t VALUES (1, 1);
      SELECT * 
      FROM t AS t1
      LEFT JOIN (SELECT * FROM t WHERE false) AS t2
      ON t1.i = t2.i
      

       

      It should result in 1 row as the LEFT JOIN should have no effect, but the result set is empty as if t2 were inner joined.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated: