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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.13.0
• Fix Version/s: 1.14.0
• Assignee: Vova Vysotskyi
• Reporter: Vova Vysotskyi
• Created: 20/Mar/18 15:35
• Updated: 16/Apr/18 08:05
• Resolved: 16/Apr/18 08:05

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)

Issue Links

• relates to: DRILL-6294 Update Calcite version to 1.16.0
• relates to: CALCITE-2201 Allow passing custom RelBuilder into RelDecorrelator and RelStructuredTypeFlattener