Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
The following query:
SELECT table2 .`pk`
FROM CC
LEFT JOIN CC table2
JOIN CC table3 ON table3 .`col_varchar_key` = table2 .`col_varchar_key`
ON table3 .`col_int_nokey` ;
Returns 469 rows when executed with join_cache_level=6 on maria-5.3-dsmrr-cpk . maria-5.3 , join_cache_level=0 and using IGNORE INDEX to modify the query plan all agree that the query should return 480 rows.