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

Regression when using derived table in LEFT JOIN

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

              Dates

              • Created:
                Updated:

                Issue deployment