Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
1.0.0
-
None
Description
This is a regression.
Both queries worked and returned correct result with May 7 build
(mapr-drill-1.0.0.31658-1.noarch.rpm)
Running with the latest build, I got these two failures:
select * from j2 where c_integer > (select min(c_bigint) from j7 where c_boolean is null) Failed with exception java.sql.SQLException: SYSTEM ERROR: org.apache.drill.exec.work.foreman.UnsupportedRelOperatorException: This query cannot be planned possibly due to either a cartesian join or an inequality select * from j2 where c_float < (select min(c_float) from j6 where c_boolean is null ) Failed with exception java.sql.SQLException: SYSTEM ERROR: org.apache.drill.exec.work.foreman.UnsupportedRelOperatorException: This query cannot be planned possibly due to either a cartesian join or an inequality join
The common pattern between these queries is that function MIN is running over no rows, in both queries there is no correlation to the outer table.
-- Non correlated -- Greater than -- MIN returns NULL select * from j2 where c_integer > (select min(c_bigint) from j7 where c_boolean is null); -- Non correlated -- Less than -- MIN returns NULL select * from j2 where c_float < (select min(c_float) from j6 where c_boolean is null );