Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-7016

Wrong query result with RuntimeFilter enabled when order of join and filter condition is swapped

    XMLWordPrintableJSON

    Details

      Description

      Below 2 queries generate different results:

      Query1: Result: 19826

      select count(*)
      from 
        customer c, 
        orders o
      where 
        c.c_mktsegment = 'HOUSEHOLD' 
        and c.c_custkey = o.o_custkey 
      

      Query2: Result: 2990828

      select count(*)
      from 
        customer c, 
        orders o
      where 
        c.c_custkey = o.o_custkey and
        c.c_mktsegment = 'HOUSEHOLD' 
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                shamirwasia Sorabh Hamirwasia
                Reporter:
                shamirwasia Sorabh Hamirwasia
                Reviewer:
                Weijie Tong
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: