Details
-
Bug
-
Status: Closed (View Workflow)
-
Resolution: Fixed
-
None
-
None
-
None
Description
In maria 5.3, the following query:
SELECT table2 .col_int_key field3 FROM t1 table1 JOIN t1 table2 ON table2 .col_int_key >= table1 .col_int_key AND table2 .pk < table1 .col_int_nokey ;
returns no rows when the query plan contains "Range checked for each record". In maria-5.2 and for plans containing "join buffer", the query returns rows.
So, this seems to be a regression outside of the join cache code.