|
Note: I could only reproduce it on 5.3. If it's a 5.3-only issue, it's probably not so important, but my concern is that it might still exist in 5.5 but be currently masked.
#3 <signal handler called>
|
#4 0x000000000073636a in test_if_skip_sort_order (tab=0x7f6ac4071888, order=0x7f6ac4006a60, select_limit_arg=18446744073709551615, no_changes=false, map=0x7f6ac402dfa8) at sql_select.cc:18873
|
#5 0x000000000070a1c3 in JOIN::optimize (this=0x7f6ac4043300) at sql_select.cc:1626
|
#6 0x000000000070ef27 in mysql_select (thd=0x300b1e8, rref_pointer_array=0x300ded8, tables=0x7f6ac4004d80, wild_num=0, fields=..., conds=0x7f6ac4043058, og_num=1, order=0x0, group=0x7f6ac4006a60, having=0x0, proc_param=0x0, select_options=2147764736, result=0x7f6ac4006ab8, unit=0x300d778, select_lex=0x300dc80) at sql_select.cc:2985
|
#7 0x00000000007059d9 in handle_select (thd=0x300b1e8, lex=0x300d6d8, result=0x7f6ac4006ab8, setup_tables_done_option=0) at sql_select.cc:288
|
#8 0x0000000000691cb2 in execute_sqlcom_select (thd=0x300b1e8, all_tables=0x7f6ac4004d80) at sql_parse.cc:5172
|
#9 0x0000000000688a7a in mysql_execute_command (thd=0x300b1e8) at sql_parse.cc:2305
|
#10 0x000000000069473c in mysql_parse (thd=0x300b1e8, rawbuf=0x7f6ac4004b00 "SELECT c1 FROM t1, t2 WHERE i2 = i1 AND c1 IN ( SELECT c3 FROM t3 WHERE c3 != 'g' ) GROUP BY c1", length=95, found_semicolon=0x7f6b1c5497e0) at sql_parse.cc:6173
|
#11 0x0000000000686197 in dispatch_command (command=COM_QUERY, thd=0x300b1e8, packet=0x3086ef9 "SELECT c1 FROM t1, t2 WHERE i2 = i1 AND c1 IN ( SELECT c3 FROM t3 WHERE c3 != 'g' ) GROUP BY c1", packet_length=95) at sql_parse.cc:1243
|
#12 0x0000000000685408 in do_command (thd=0x300b1e8) at sql_parse.cc:923
|
#13 0x00000000006822a2 in handle_one_connection (arg=0x300b1e8) at sql_connect.cc:1231
|
#14 0x00007f6b20688e9a in start_thread (arg=0x7f6b1c54a700) at pthread_create.c:308
|
#15 0x00007f6b1fbb1cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
bzr version-info
|
revision-id: igor@askmonty.org-20130829175612-acvqr7uadpa7kylp
|
revno: 3686
|
branch-nick: 5.3
|
Test case:
SET optimizer_switch = 'materialization=on,semijoin=on';
|
|
CREATE TABLE t1 (i1 INT NOT NULL, c1 VARCHAR(1), KEY (c1,i1)) ENGINE=InnoDB;
|
INSERT INTO t1 VALUES (7,'m'),(8,'n');
|
|
CREATE TABLE t2 (i2 INT, KEY(i2)) ENGINE=InnoDB;
|
INSERT INTO t2 VALUES (7),(0);
|
|
CREATE TABLE t3 (c3 VARCHAR(1)) ENGINE=InnoDB;
|
INSERT INTO t3 VALUES ('j'),('v');
|
|
SELECT c1 FROM t1, t2 WHERE i2 = i1 AND c1 IN ( SELECT c3 FROM t3 WHERE c3 != 'g' ) GROUP BY c1;
|
|