Details
-
Bug
-
Status: In Review (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
Description
SET optimizer_trace='enabled=on'; |
CREATE TABLE t1 (a int); |
INSERT INTO t1 VALUES (1),(2),(3); |
|
SELECT * FROM t1 WHERE a IN (SELECT 1 a FROM t1 WHERE EXISTS (select 1)); |
bb-10.4-release 2ab6983e595ab994b1d8 |
Version: '10.4.25-MariaDB-debug-log'
|
mysqld: /sql/my_json_writer.cc:42: void Json_writer::on_start_object(): Assertion `got_name == named_item_expected()' failed.
|
220517 16:06:33 [ERROR] mysqld got signal 6 ;
|
|
Server version: 10.4.25-MariaDB-debug-log
|
|
linux/raise.c:51(__GI_raise)[0x7f68795d97bb]
|
stdlib/abort.c:81(__GI_abort)[0x7f68795c4535]
|
intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f68795c440f]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x30102)[0x7f68795d2102]
|
sql/my_json_writer.cc:43(Json_writer::on_start_object())[0x55b2691cd506]
|
sql/my_json_writer.cc:53(Json_writer::start_object())[0x55b2691cbab2]
|
sql/my_json_writer.h:424(Json_writer_object::Json_writer_object(Json_writer*, char const*))[0x55b268ee437a]
|
sql/my_json_writer.h:429(Json_writer_object::Json_writer_object(THD*, char const*))[0x55b268ee43da]
|
sql/sql_select.cc:1864(JOIN::optimize_inner())[0x55b269016856]
|
sql/sql_select.cc:1661(JOIN::optimize())[0x55b269015e1d]
|
sql/item_subselect.cc:3978(subselect_single_select_engine::exec())[0x55b2693edaaa]
|
sql/item_subselect.cc:801(Item_subselect::exec())[0x55b2693e1155]
|
sql/item_subselect.cc:1760(Item_exists_subselect::val_int())[0x55b2693e4835]
|
sql/item_cmpfunc.cc:1565(Item_in_optimizer::val_int())[0x55b26934cc6c]
|
sql/sql_type.cc:4602(Type_handler_int_result::Item_val_bool(Item*) const)[0x55b2691f29e1]
|
sql/item.h:1466(Item::val_bool())[0x55b268ea7506]
|
sql/item.h:1474(Item::eval_const_cond())[0x55b2690661bb]
|
sql/item_cmpfunc.cc:4858(Item_cond::fix_fields(THD*, Item**))[0x55b2693589c3]
|
sql/item.h:965(Item::fix_fields_if_needed(THD*, Item**))[0x55b268eb3ec1]
|
sql/opt_subselect.cc:1922(convert_subq_to_sj(JOIN*, Item_in_subselect*))[0x55b2691b4b4a]
|
sql/opt_subselect.cc:1295(convert_join_subqueries_to_semijoins(JOIN*))[0x55b2691b2d27]
|
sql/sql_select.cc:1915(JOIN::optimize_inner())[0x55b269016af9]
|
sql/sql_select.cc:1661(JOIN::optimize())[0x55b269015e1d]
|
sql/sql_select.cc:4752(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55b2690213f1]
|
sql/sql_select.cc:436(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55b269010d08]
|
sql/sql_parse.cc:6465(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55b268fd63c7]
|
sql/sql_parse.cc:3979(mysql_execute_command(THD*))[0x55b268fccb9d]
|
sql/sql_parse.cc:8011(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55b268fda37b]
|
sql/sql_parse.cc:1876(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55b268fc67e3]
|
sql/sql_parse.cc:1378(do_command(THD*))[0x55b268fc4ef0]
|
sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x55b269152d3f]
|
sql/sql_connect.cc:1317(handle_one_connection)[0x55b2691529e4]
|
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55b26969590e]
|
nptl/pthread_create.c:487(start_thread)[0x7f6879a91fa3]
|
x86_64/clone.S:97(clone)[0x7f687969aeff]
|
|
Query (0x7f6858014768): SELECT * FROM t1 WHERE a IN (SELECT 1 a FROM t1 WHERE EXISTS (select 1))
|
Attachments
Issue Links
- includes
-
MDEV-31752 Assertion `got_name == named_item_expected()' failed in void Json_writer::on_start_object()
- Stalled
- relates to
-
MDEV-27878 Assertion `got_name == named_item_expected()' failed in Json_writer::on_start_object
- Open