-
Type:
Bug
-
Status: Done
-
Priority:
High
-
Resolution: Fixed
-
Affects Version/s: 5.6.47-87.0, 5.7.29-32
-
Fix Version/s: 5.6.49-89.0, 5.7.31-34
-
Component/s: None
-
Labels:None
-
Upstream Bug URL:
-
Needs Review:Yes
Adding a constant equality expression which evaluates to TRUE in a LEFT JOIN's ON condition can lead to bogus results; Will attach outputs and script to reproduce.
Happens every time with MyISAM; Only sometimes with InnoDB.
Flipping all optimizer switches didn't changed anything.
Does not happen in 8.0.19