Valgrind warnings in create_ref_for_key with extended_keys+join_cache_hashed+join_cache_bka
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
High
|
Igor Babaev |
Bug Description
==2090== Conditional jump or move depends on uninitialised value(s)
==2090== at 0x8542F76: create_
==2090== by 0x8541034: get_best_
==2090== by 0x8532147: make_join_
==2090== by 0x8521D08: JOIN::optimize() (sql_select.
==2090== by 0x852DCCA: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_
==2090== by 0x858804C: mysql_explain_
==2090== by 0x843BA9B: execute_
==2090== by 0x84294D6: mysql_execute_
==2090== by 0x8440EB7: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6149)
==2090== by 0x84248D0: dispatch_
==2090== by 0x8422F76: do_command(THD*) (sql_parse.cc:922)
==2090== by 0x841C469: handle_
==2090== by 0x40C9B24: start_thread (in /lib/libpthread
==2090== by 0x42F534D: clone (in /lib/libc-
bzr version-info
revision-id: <email address hidden>
date: 2012-01-24 23:34:02 -0800
build-date: 2012-01-29 10:08:31 +0400
revno: 3395
branch-nick: lp-5.3-
Reproducible with join_cache_
The problem seems to be somehow related to the number of columns and the length of their names.
EXPLAIN:
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 2 100.00 Using where
1 SIMPLE t2 hash_ALL NULL #hash#$hj 5 test.t1.a 2 100.00 Using where; Using join buffer (flat, BNLH join)
Warnings:
Note 1003 select `test`.`t1`.`a` AS `a`,`test`
Minimal optimizer_switch: join_cache_
Full optimizer_switch: index_merge=
Test case:
SET join_cache_level=3;
SET optimizer_
CREATE TABLE t1 (
a INT, f1 INT, f2 INT,
f3 INT, f4 INT, f5 INT,
long_
long_
);
CREATE TABLE t2 (
b INT, f6 INT, f7 INT,
long_
long_
long_
long_
long_
long_
long_
);
INSERT INTO t1 (a) VALUES (4),(6);
INSERT INTO t2 (b) VALUES (0),(8);
SELECT * FROM t1, t2 WHERE b=a;
Changed in maria: | |
status: | New → Confirmed |
importance: | Undecided → High |
Changed in maria: | |
status: | Confirmed → In Progress |
Changed in maria: | |
status: | In Progress → Fix Committed |
Also filed in JIRA as MDEV-126