Volodymyr Vysotskyi created DRILL-6277:
------------------------------------------

             Summary: Query fails with DATA_READ ERROR when correlated subquery 
has "always false" filter
                 Key: DRILL-6277
                 URL: https://issues.apache.org/jira/browse/DRILL-6277
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.13.0
            Reporter: Volodymyr Vysotskyi
            Assignee: Volodymyr Vysotskyi
             Fix For: 1.14.0


Query with correlated subquery which contains "always false" filter fails:
{noformat}
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)
{noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to