bzr version-info

revision-id: igor@askmonty.org-20130829175612-acvqr7uadpa7kylp

revno: 3686

branch-nick: 5.3

#3  <signal handler called>

#4  0x00000000005de5c2 in Item_equal_iterator<List_iterator_fast, Item>::get_curr_field (this=0x7f3bc8546120) at item_cmpfunc.h:1857

#5  0x00000000005d9e20 in Item_equal::contains (this=0x7f3bbc03a298, field=0x7f3bbc02e1f0) at item_cmpfunc.cc:5566

#6  0x00000000005884df in Item_field::find_item_equal (this=0x7f3bbc019da0, cond_equal=0x7f3bbc01a950) at item.cc:4882

#7  0x00000000007246c5 in eliminate_item_equal (cond=0x0, upper_levels=0x7f3bbc01a950, item_equal=0x7f3bbc03a4a0) at sql_select.cc:11865

#8  0x0000000000725039 in substitute_for_best_equal_field (context_tab=0x1, cond=0x7f3bbc03a4a0, cond_equal=0x7f3bbc01a950, table_join_idx=0x7f3bbc03acd8) at sql_select.cc:12156

#9  0x0000000000724d20 in substitute_for_best_equal_field (context_tab=0x1, cond=0x7f3bbc01a3c8, cond_equal=0x7f3bbc01ad68, table_join_idx=0x7f3bbc03acd8) at sql_select.cc:12083

#10 0x0000000000724d20 in substitute_for_best_equal_field (context_tab=0x1, cond=0x7f3bbc01ac78, cond_equal=0x7f3bbc01ad68, table_join_idx=0x7f3bbc03acd8) at sql_select.cc:12083

#11 0x0000000000708a4e in JOIN::optimize (this=0x7f3bbc038f90) at sql_select.cc:1246

#12 0x000000000070ef27 in mysql_select (thd=0x39378c8, rref_pointer_array=0x393a5b8, tables=0x7f3bbc0191b8, wild_num=1, fields=..., conds=0x7f3bbc01ac78, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0x7f3bbc01ae50, unit=0x3939e58, select_lex=0x393a360) at sql_select.cc:2985

#13 0x00000000007059d9 in handle_select (thd=0x39378c8, lex=0x3939db8, result=0x7f3bbc01ae50, setup_tables_done_option=0) at sql_select.cc:288

#14 0x0000000000691cb2 in execute_sqlcom_select (thd=0x39378c8, all_tables=0x7f3bbc0191b8) at sql_parse.cc:5172

#15 0x0000000000688a7a in mysql_execute_command (thd=0x39378c8) at sql_parse.cc:2305

#16 0x000000000069473c in mysql_parse (thd=0x39378c8, rawbuf=0x7f3bbc018f40 "SELECT * FROM t1, t2 WHERE a1 = pk2 AND ( ( b1 = 6 OR a2 > 4 ) AND pk2 = a2 OR pk1 IS NULL )", length=92, found_semicolon=0x7f3bc85477e0) at sql_parse.cc:6173

#17 0x0000000000686197 in dispatch_command (command=COM_QUERY, thd=0x39378c8, packet=0x39b1b29 "SELECT * FROM t1, t2 WHERE a1 = pk2 AND ( ( b1 = 6 OR a2 > 4 ) AND pk2 = a2 OR pk1 IS NULL )", packet_length=92) at sql_parse.cc:1243

#18 0x0000000000685408 in do_command (thd=0x39378c8) at sql_parse.cc:923

#19 0x00000000006822a2 in handle_one_connection (arg=0x39378c8) at sql_connect.cc:1231

#20 0x00007f3bd5d6fe9a in start_thread (arg=0x7f3bc8548700) at pthread_create.c:308

#21 0x00007f3bd5298cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

CREATE TABLE t1 (pk1 INT, a1 INT, b1 INT, PRIMARY KEY(pk1)) ENGINE=MyISAM;

INSERT INTO t1 VALUES (1,10,100), (2,20,200) ;

CREATE TABLE t2 (pk2 INT, a2 INT, PRIMARY KEY(pk2)) ENGINE=MyISAM;

INSERT INTO t2 VALUES (1,1);

SELECT * FROM t1, t2 WHERE a1 = pk2 AND ( ( b1 = 6 OR a2 > 4 ) AND pk2 = a2 OR pk1 IS NULL );