Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
This operator causes incorrect query results:
0: jdbc:drill:schema=dfs.par100> alter session set `planner.add_producer_consumer` = true;
----------------------+
ok | summary |
----------------------+
true | planner.add_producer_consumer updated. |
----------------------+
1 row selected (0.053 seconds)
0: jdbc:drill:schema=dfs.par100> select count(l_orderkey) from lineitem;
------------
EXPR$0 |
------------
600037902 |
------------
1 row selected (0.212 seconds)
0: jdbc:drill:schema=dfs.par100> select count(l_orderkey) from lineitem where 1 = 1;
------------
EXPR$0 |
------------
569114624 |
------------
1 row selected (2.163 seconds)
0: jdbc:drill:schema=dfs.par100> alter session set `planner.add_producer_consumer` = false;
----------------------+
ok | summary |
----------------------+
true | planner.add_producer_consumer updated. |
----------------------+
1 row selected (0.046 seconds)
0: jdbc:drill:schema=dfs.par100> select count(l_orderkey) from lineitem where 1 = 1;
------------
EXPR$0 |
------------
600037902 |
------------
1 row selected (2.657 seconds)
As an immediate fix, we should disable this operator.