Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL)
Description
--source include/have_innodb.inc
|
|
CREATE TABLE t1 (a INT) ENGINE=InnoDB; |
INSERT INTO t1 VALUES (1),(2); |
|
CREATE TABLE t2 (column_name_1 INT, column_name_2 VARCHAR(52)) ENGINE=InnoDB; |
INSERT INTO t2 VALUES (3,'United States'); |
|
CREATE TABLE t3 (b INT, c VARCHAR(3), PRIMARY KEY (c,b)) ENGINE=InnoDB; |
INSERT INTO t3 VALUES (4,'USA'),(5,'CAN'); |
|
EXPLAIN FORMAT=JSON SELECT * FROM t1 WHERE 0 < ALL ( |
SELECT tbl_alias1.column_name_1 FROM t2 AS tbl_alias1, t3 AS tbl_alias2 |
WHERE tbl_alias2.b = tbl_alias1.column_name_1 AND tbl_alias2.c = tbl_alias1.column_name_2 |
);
|
Stack trace from d1522af7 |
sql/my_json_writer.cc:86: Json_writer& Json_writer::add_member(const char*): Assertion `!element_started' failed.
|
141204 20:14:59 [ERROR] mysqld got signal 6 ;
|
|
#6 0x00007faec77f06f1 in *__GI___assert_fail (assertion=0x7faecaa918f4 "!element_started", file=<optimized out>, line=86, function=0x7faecaa919a0 "Json_writer& Json_writer::add_member(const char*)") at assert.c:81
|
#7 0x00007faeca29ac7c in Json_writer::add_member (this=0x7faec9bc9020, name=0x7faec9bc902c "ref") at 10.1/sql/my_json_writer.cc:86
|
#8 0x00007faeca29b3f3 in Single_line_formatting_helper::disable_and_flush (this=0x7faec9bc9028) at 10.1/sql/my_json_writer.cc:326
|
#9 0x00007faeca29b221 in Single_line_formatting_helper::on_add_str (this=0x7faec9bc9028, str=0x7faec9bc9030 "test.tbl_alias1.column_name_2") at 10.1/sql/my_json_writer.cc:271
|
#10 0x00007faeca29af31 in Json_writer::add_str (this=0x7faec9bc9020, str=0x7faec9bc9030 "test.tbl_alias1.column_name_2") at 10.1/sql/my_json_writer.cc:168
|
#11 0x00007faeca29b422 in Single_line_formatting_helper::disable_and_flush (this=0x7faec9bc9028) at 10.1/sql/my_json_writer.cc:334
|
#12 0x00007faeca29b221 in Single_line_formatting_helper::on_add_str (this=0x7faec9bc9028, str=0x7faec9bc9030 "test.tbl_alias1.column_name_2") at 10.1/sql/my_json_writer.cc:271
|
#13 0x00007faeca29af31 in Json_writer::add_str (this=0x7faec9bc9020, str=0x7faec9bc9030 "test.tbl_alias1.column_name_2") at 10.1/sql/my_json_writer.cc:168
|
#14 0x00007faeca29b422 in Single_line_formatting_helper::disable_and_flush (this=0x7faec9bc9028) at 10.1/sql/my_json_writer.cc:334
|
#15 0x00007faeca29b1a7 in Single_line_formatting_helper::on_add_str (this=0x7faec9bc9028, str=0x7faeb32dd780 "test.tbl_alias1.column_name_1") at 10.1/sql/my_json_writer.cc:259
|
#16 0x00007faeca29af31 in Json_writer::add_str (this=0x7faec9bc9020, str=0x7faeb32dd780 "test.tbl_alias1.column_name_1") at 10.1/sql/my_json_writer.cc:168
|
#17 0x00007faeca273361 in Explain_table_access::print_explain_json (this=0x7faeb32dd448, query=0x7faeb32dd0a8, writer=0x7faec9bc9020, is_analyze=false) at 10.1/sql/sql_explain.cc:1211
|
#18 0x00007faeca271b2e in Explain_basic_join::print_explain_json (this=0x7faeb32dd118, query=0x7faeb32dd0a8, writer=0x7faec9bc9020, is_analyze=false) at 10.1/sql/sql_explain.cc:739
|
#19 0x00007faeca271a3a in Explain_select::print_explain_json (this=0x7faeb32dd118, query=0x7faeb32dd0a8, writer=0x7faec9bc9020, is_analyze=false) at 10.1/sql/sql_explain.cc:720
|
#20 0x00007faeca2713b1 in Explain_node::print_explain_json_for_children (this=0x7faeb32ddf40, query=0x7faeb32dd0a8, writer=0x7faec9bc9020, is_analyze=false) at 10.1/sql/sql_explain.cc:590
|
#21 0x00007faeca271b8b in Explain_basic_join::print_explain_json (this=0x7faeb32ddf40, query=0x7faeb32dd0a8, writer=0x7faec9bc9020, is_analyze=false) at 10.1/sql/sql_explain.cc:744
|
#22 0x00007faeca271a3a in Explain_select::print_explain_json (this=0x7faeb32ddf40, query=0x7faeb32dd0a8, writer=0x7faec9bc9020, is_analyze=false) at 10.1/sql/sql_explain.cc:720
|
#23 0x00007faeca26ffb0 in Explain_query::print_explain_json (this=0x7faeb32dd0a8, output=0x7faeb326cec0, is_analyze=false) at 10.1/sql/sql_explain.cc:205
|
#24 0x00007faeca117d57 in execute_sqlcom_select (thd=0x7faec01c8070, all_tables=0x7faeb3182408) at 10.1/sql/sql_parse.cc:5706
|
#25 0x00007faeca10e6c3 in mysql_execute_command (thd=0x7faec01c8070) at 10.1/sql/sql_parse.cc:2892
|
#26 0x00007faeca11b1d7 in mysql_parse (thd=0x7faec01c8070, rawbuf=0x7faeb3182088 "EXPLAIN FORMAT=JSON SELECT * FROM t1 WHERE 0 < ALL ( \nSELECT tbl_alias1.column_name_1 FROM t2 AS tbl_alias1, t3 AS tbl_alias2 \nWHERE tbl_alias2.b = tbl_alias1.column_name_1 AND tbl_alias2.c = tbl_alia"..., length=219, parser_state=0x7faec9bca1c0) at 10.1/sql/sql_parse.cc:7028
|
#27 0x00007faeca10aade in dispatch_command (command=COM_QUERY, thd=0x7faec01c8070, packet=0x7faec02a0071 "", packet_length=219) at 10.1/sql/sql_parse.cc:1460
|
#28 0x00007faeca1098fc in do_command (thd=0x7faec01c8070) at 10.1/sql/sql_parse.cc:1089
|
#29 0x00007faeca238538 in do_handle_one_connection (thd_arg=0x7faec01c8070) at 10.1/sql/sql_connect.cc:1347
|
#30 0x00007faeca23827d in handle_one_connection (arg=0x7faec01c8070) at 10.1/sql/sql_connect.cc:1258
|
#31 0x00007faeca7d4fee in pfs_spawn_thread (arg=0x7faec0240770) at 10.1/storage/perfschema/pfs.cc:1860
|
#32 0x00007faec980ab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
|
Attachments
Issue Links
- relates to
-
MDEV-6109 EXPLAIN JSON
- Closed