MWL#253: Server crashes in Item_equal_iterator with optimizer_use_condition_selectivity=3 and table statistics

#2  0x00000000007f9d82 in handle_fatal_signal (sig=11) at /home/elenst/bzr/10.0/sql/signal_handler.cc:262

#3  <signal handler called>

#4  0x0000000000696a80 in Item_equal_iterator<List_iterator_fast, Item>::get_curr_field (this=0x7f073f14ea70) at /home/elenst/bzr/10.0/sql/item_cmpfunc.h:1859

#5  0x0000000000912d3d in get_full_func_mm_tree (param=0x7f073f14ef90, cond_func=0x7f0730041e50, field_item=0x7f07300fcda0, value=0x7f0730103d70, inv=false) at /home/elenst/bzr/10.0/sql/opt_range.cc:7708

#6  0x0000000000913ab0 in get_mm_tree (param=0x7f073f14ef90, cond=0x7f0730041e50) at /home/elenst/bzr/10.0/sql/opt_range.cc:7895

#7  0x000000000091300d in get_mm_tree (param=0x7f073f14ef90, cond=0x7f0730118810) at /home/elenst/bzr/10.0/sql/opt_range.cc:7753

#8  0x0000000000912f2c in get_mm_tree (param=0x7f073f14ef90, cond=0x7f07300499a0) at /home/elenst/bzr/10.0/sql/opt_range.cc:7742

#9  0x00000000009099b1 in calculate_cond_selectivity_for_table (thd=0x3659058, table=0x7f07300ef7f8, cond=0x7f07300499a0) at /home/elenst/bzr/10.0/sql/opt_range.cc:3440

#10 0x000000000065f07d in make_join_statistics (join=0x7f0730124500, tables_list=..., conds=0x7f07300499a0, keyuse_array=0x7f0730124838) at /home/elenst/bzr/10.0/sql/sql_select.cc:3834

#11 0x0000000000656234 in JOIN::optimize_inner (this=0x7f0730124500) at /home/elenst/bzr/10.0/sql/sql_select.cc:1301

#12 0x00000000006551da in JOIN::optimize (this=0x7f0730124500) at /home/elenst/bzr/10.0/sql/sql_select.cc:1003

#13 0x000000000065ce96 in mysql_select (thd=0x3659058, rref_pointer_array=0x365c528, tables=0x7f0730043430, wild_num=1, fields=..., conds=0x7f07300499a0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f07301253e0, unit=0x365bb80, select_lex=0x365c278) at /home/elenst/bzr/10.0/sql/sql_select.cc:3215

#14 0x000000000065364b in handle_select (thd=0x3659058, lex=0x365bac8, result=0x7f07301253e0, setup_tables_done_option=0) at /home/elenst/bzr/10.0/sql/sql_select.cc:371

#15 0x0000000000628767 in execute_sqlcom_select (thd=0x3659058, all_tables=0x7f0730043430) at /home/elenst/bzr/10.0/sql/sql_parse.cc:5021

#16 0x0000000000620d89 in mysql_execute_command (thd=0x3659058) at /home/elenst/bzr/10.0/sql/sql_parse.cc:2482

#17 0x000000000062b026 in mysql_parse (thd=0x3659058, rawbuf=0x7f07300ff860 "SELECT * FROM america, europe, city\nWHERE city.country = europe.country AND ( 0 OR america.country = city.country AND ( city.country != 'POL' OR city.country = 'NOR' ) )", length=169, parser_state=0x7f073f152500) at /home/elenst/bzr/10.0/sql/sql_parse.cc:6154

#18 0x000000000061df6e in dispatch_command (command=COM_QUERY, thd=0x3659058, packet=0x365d369 "SELECT * FROM america, europe, city\nWHERE city.country = europe.country AND ( 0 OR america.country = city.country AND ( city.country != 'POL' OR city.country = 'NOR' ) )", packet_length=169) at /home/elenst/bzr/10.0/sql/sql_parse.cc:1274

#19 0x000000000061d3e4 in do_command (thd=0x3659058) at /home/elenst/bzr/10.0/sql/sql_parse.cc:983

#20 0x0000000000737da1 in do_handle_one_connection (thd_arg=0x3659058) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1267

#21 0x0000000000737af4 in handle_one_connection (arg=0x3659058) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1181

#22 0x00000000009c767b in pfs_spawn_thread (arg=0x34d4248) at /home/elenst/bzr/10.0/storage/perfschema/pfs.cc:1800

#23 0x00007f0750ae5e9a in start_thread (arg=0x7f073f153700) at pthread_create.c:308

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

revision-id: igor@askmonty.org-20130423035522-w8b8rz72zdav0p7r

revno: 3744

branch-nick: 10.0

SET optimizer_use_condition_selectivity=3;

SET use_stat_tables=PREFERABLY;

CREATE TABLE america (country VARCHAR(3)) ENGINE=MyISAM;

INSERT INTO america VALUES ('USA');

CREATE TABLE europe (country VARCHAR(3)) ENGINE=MyISAM;

INSERT INTO europe VALUES ('FRA'),('ITA');

CREATE TABLE city (country VARCHAR(3), name VARCHAR(32)) ENGINE=MyISAM;

INSERT INTO city VALUES ('GBR','London'),('FIN', 'Helsinki');

ANALYZE TABLE america, europe, city;

FLUSH TABLES;

SELECT * FROM america, europe, city

WHERE city.country = europe.country AND ( 0 OR america.country = city.country AND ( city.country != 'POL' OR city.country = 'NOR' ) );