Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
The following query:
SELECT t2 .col_int_key FROM t2 JOIN t1 ON t2 .col_varchar_10_latin1_key = t1 .col_varchar_10_utf8_key ;
returns no rows when executed with join_cache_level = 4, join_buffer_size = 164 , even though there are rows for which the condition t2 .col_varchar_10_latin1_key = t1 .col_varchar_10_utf8_key is TRUE.
The execution strategy is reported as "Using join buffer (flat, BNLH join)". maria-5.3 is not affected.