Valgrind complains on a join query with two IN subqueries
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Critical
|
Sergey Petrunia |
Bug Description
The following test case makes Valgrind complain on the 5.3 tree:
create table t1 (a int);
insert into t1 values (1), (2), (3);
create table t2 as select * from t1;
select * from t1 A, t1 B
where A.a = B.a and A.a in (select a from t2 C) and B.a in (select a from t2 D);
explain
select * from t1 A, t1 B
where A.a = B.a and A.a in (select a from t2 C) and B.a in (select a from t2 D);
drop table t1, t2;
igor@sophia:
Logging: ./mysql-test-run --valgrind view_1
MariaDB Version 5.3.0
Turning on valgrind for all executables
Running valgrind with options " --show-
vardir: /home/igor/
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/
Installing system database...
Checking supported features...
- skipping ndbcluster
- SSL connections supported
- binaries are debug compiled
Using "../libtool" when running valgrind, strace or debugger
Collecting tests...
Using server port 42383
=======
TEST RESULT TIME (ms)
-------
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
main.view_1 [ fail ] Found warnings/errors in server log file!
Test ended at 2011-05-23 19:06:07
line
==15939== Thread 4:
==15939== Conditional jump or move depends on uninitialised value(s)
==15939== at 0x769684: best_extension_
==15939== by 0x769976: best_extension_
==15939== by 0x769976: best_extension_
==15939== by 0x768E10: greedy_
==15939== by 0x76864F: choose_plan(JOIN*, unsigned long long) (sql_select.
==15939== by 0x762ECC: make_join_
==15939== by 0x75AA0B: JOIN::optimize() (sql_select.
==15939== by 0x76106F: 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_
==15939== by 0x758644: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:281)
==15939== by 0x6E88E6: execute_
==15939== by 0x6DF9F5: mysql_execute_
==15939== by 0x6EB227: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6097)
==15939== by 0x6DD301: dispatch_
==15939== by 0x6DC65D: do_command(THD*) (sql_parse.cc:904)
==15939== by 0x6D91A5: handle_
==15939== by 0x58B6A4E: start_thread (in /lib64/
...
Changed in maria: | |
status: | New → Confirmed |
importance: | Undecided → Critical |
assignee: | nobody → Sergey Petrunia (sergefp) |
milestone: | none → 5.3 |
Changed in maria: | |
status: | Confirmed → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |