Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
The following query against the DBT-3 data set is much slower in maria-5.1-wl21 because it gets executed with sort_intersection
SELECT COUNT( l_suppkey ) FROM lineitem WHERE (l_suppkey = 3 AND l_partkey = 255 ) OR (l_partkey BETWEEN 111 AND 244);
The left side of the OR expression returns zero rows. Each side is easily computable with an index when executed separately.