Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
-
None
-
None
Description
The following query produces 1 less row than desired, when executed with join_cache_hashed=on, join_cache_level=3, join_buffer_size=10000:
SELECT table1 .`pk`
FROM X table1 JOIN V table2 ON table1 .`pk` = table2 .`pk`
WHERE table2 .`pk` <> 8;
The plan is:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE table1 index PRIMARY PRIMARY 4 NULL 11 Using where; Using index
1 SIMPLE table2 eq_ref PRIMARY PRIMARY 4 test.table1.pk 1 Using index; Using join buffer (flat, BNLH join)