You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Volodymyr Vysotskyi (JIRA)" <ji...@apache.org> on 2018/03/20 15:36:00 UTC

[jira] [Created] (DRILL-6277) Query fails with DATA_READ ERROR when correlated subquery has "always false" filter

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)