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

Query fails with DATA_READ ERROR when correlated subquery has "always false" filter

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.13.0
    • Fix Version/s: 1.14.0
    • Component/s: None
    • Labels:
      None

      Description

      Query with correlated subquery which contains "always false" filter fails:

      select * from cp.`employee.json` t where exists(select employee_id from cp.`employee.json` where t.employee_id = 3 and 1 = 5);
      Error: DATA_READ ERROR: The top level of your document must either be a single array of maps or a set of white space delimited maps.
      
      Line  -1
      Column  0
      Field  <none>
      Fragment 0:0
      
      [Error Id: 66b38c7e-7d12-4f38-93e4-f97f08f55e93 on user515050-pc:31013] (state=,code=0)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                vvysotskyi Volodymyr Vysotskyi
                Reporter:
                vvysotskyi Volodymyr Vysotskyi
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: