LevelDB: Server crashes in get_constant_key_infix on EXPLAIN with a select subquery

CREATE TABLE t1 (pk1 INT, pk2 CHAR(4) COLLATE latin1_bin, i INT, PRIMARY KEY(pk1,pk2), KEY(i)) ENGINE=LevelDB;

INSERT INTO t1 VALUES (1,'foo',2),(2,'bar',3);

CREATE TABLE t2 (pk INT PRIMARY KEY) ENGINE=LevelDB;

INSERT INTO t2 VALUES (1),(2);

EXPLAIN SELECT ( SELECT DISTINCT i FROM t1 WHERE pk1 = pk AND i <> 2 ) AS alias FROM t2;

#3  <signal handler called>

#4  0x00000000009268e4 in get_constant_key_infix (index_info=0x7f4510016398, index_range_tree=0x7f45100442a0, first_non_group_part=0x7f4510016468, min_max_arg_part=0x0, last_part=0x7f45100164a8, thd=0x1d17740, key_infix=0x7f45334045c0 "\340E@3E\177", key_infix_len=0x7f453340397c, first_non_infix_part=0x7f4533403850) at mysql-5.6-leveldb/sql/opt_range.cc:11897

#5  0x00000000009258d1 in get_best_group_min_max (param=0x7f4533405430, tree=0x7f4510043d48, read_time=262.10000000000002) at mysql-5.6-leveldb/sql/opt_range.cc:11513

#6  0x0000000000911d9a in SQL_SELECT::test_quick_select (this=0x7f4510043a08, thd=0x1d17740, keys_to_use=..., prev_tables=13835058055282163712, limit=18446744073709551615, force_quick_range=false, interesting_order=st_order::ORDER_NOT_RELEVANT) at mysql-5.6-leveldb/sql/opt_range.cc:2763

#7  0x0000000000975ffa in make_join_select (join=0x7f4510040ca0, cond=0x7f4510006978) at mysql-5.6-leveldb/sql/sql_optimizer.cc:7710

#8  0x000000000096371f in JOIN::optimize (this=0x7f4510040ca0) at mysql-5.6-leveldb/sql/sql_optimizer.cc:498

#9  0x00000000007cbb34 in mysql_execute_select (thd=0x1d17740, select_lex=0x7f4510005270, free_join=false) at mysql-5.6-leveldb/sql/sql_select.cc:1086

#10 0x00000000007cbe6a in mysql_select (thd=0x1d17740, tables=0x7f4510005d00, wild_num=0, fields=..., conds=0x7f4510006978, order=0x7f4510005438, group=0x7f4510005370, having=0x0, select_options=2147748613, result=0x7f4510006d18, unit=0x7f4510005568, select_lex=0x7f4510005270) at mysql-5.6-leveldb/sql/sql_select.cc:1221

#11 0x0000000000902105 in mysql_explain_unit (thd=0x1d17740, unit=0x7f4510005568, result=0x7f4510006d18) at mysql-5.6-leveldb/sql/opt_explain.cc:2112

#12 0x00000000008fcec5 in Explain::explain_subqueries (this=0x7f45334081e0, result=0x7f4510006d18) at mysql-5.6-leveldb/sql/opt_explain.cc:598

#13 0x00000000008fd59e in Explain::send (this=0x7f45334081e0) at mysql-5.6-leveldb/sql/opt_explain.cc:709

#14 0x0000000000901b0a in explain_query_specification (thd=0x1d17740, join=0x7f4510040770) at mysql-5.6-leveldb/sql/opt_explain.cc:1947

#15 0x00000000007cb3fe in JOIN::explain (this=0x7f4510040770) at mysql-5.6-leveldb/sql/sql_select.cc:879

#16 0x00000000007cbb73 in mysql_execute_select (thd=0x1d17740, select_lex=0x1d19f20, free_join=true) at mysql-5.6-leveldb/sql/sql_select.cc:1096

#17 0x00000000007cbe6a in mysql_select (thd=0x1d17740, tables=0x7f451003fcc0, wild_num=0, fields=..., conds=0x0, order=0x1d1a0e8, group=0x1d1a020, having=0x0, select_options=2147748612, result=0x7f4510006d18, unit=0x1d198e0, select_lex=0x1d19f20) at mysql-5.6-leveldb/sql/sql_select.cc:1221

#18 0x0000000000902105 in mysql_explain_unit (thd=0x1d17740, unit=0x1d198e0, result=0x7f4510006d18) at mysql-5.6-leveldb/sql/opt_explain.cc:2112

#19 0x0000000000901cc1 in explain_query_expression (thd=0x1d17740, result=0x7f4510006d18) at mysql-5.6-leveldb/sql/opt_explain.cc:2014

#20 0x00000000007a667f in execute_sqlcom_select (thd=0x1d17740, all_tables=0x7f451003fcc0) at mysql-5.6-leveldb/sql/sql_parse.cc:4972

#21 0x000000000079f5f4 in mysql_execute_command (thd=0x1d17740) at mysql-5.6-leveldb/sql/sql_parse.cc:2557

#22 0x00000000007a8be7 in mysql_parse (thd=0x1d17740, rawbuf=0x7f4510004fd0 "EXPLAIN SELECT ( SELECT DISTINCT i FROM t1 WHERE pk1 = pk AND i <> 2 ) AS alias FROM t2", length=87, parser_state=0x7f453340a110) at mysql-5.6-leveldb/sql/sql_parse.cc:6117

#23 0x000000000079c9a3 in dispatch_command (command=COM_QUERY, thd=0x1d17740, packet=0x1deaca1 "", packet_length=87) at mysql-5.6-leveldb/sql/sql_parse.cc:1312

#24 0x000000000079bb66 in do_command (thd=0x1d17740) at mysql-5.6-leveldb/sql/sql_parse.cc:1036

#25 0x0000000000766e09 in do_handle_one_connection (thd_arg=0x1d17740) at mysql-5.6-leveldb/sql/sql_connect.cc:969

#26 0x000000000076682e in handle_one_connection (arg=0x1d17740) at mysql-5.6-leveldb/sql/sql_connect.cc:885

#27 0x0000000000af6924 in pfs_spawn_thread (arg=0x1c6c920) at mysql-5.6-leveldb/storage/perfschema/pfs.cc:1853

#28 0x00007f45326dde9a in start_thread (arg=0x7f453340b700) at pthread_create.c:308

revision-id: psergey@askmonty.org-20130321202952-we4dnb3u2snr1vxz

revno: 4612

branch-nick: mysql-5.6-leveldb