Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-26214

INSERT from SELECT crashes server on error missing column.

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.5.11, 10.4(EOL), 10.5, 10.6
    • 10.4.25, 10.5.16, 10.6.8, 10.7.4, 10.8.3
    • None
    • Microsoft Windows 10
      mariadb Ver 15.1 Distrib 10.5.11-MariaDB, for Win64 (AMD64), source revision dc82effa5df5e59be6c7de4038f0a832f37d9bdc
      Lenovo t560 (Intel)

    Description

      Expected:
      Running the following query should produce an error about missing column 't.fup'.

      Actual:
      Instead I get error code 1, "MySQL server has gone away". Which indicates the server has crashed.

      — Query code —
      use test;

      DROP TABLE IF EXISTS tmp;
      CREATE TEMPORARY TABLE tmp (ID INTEGER UNSIGNED NOT NULL);
       
      INSERT INTO tmp
      SELECT t.foo AS ID
      FROM (select 1 AS foo) AS t
      LEFT JOIN (SELECT 1 AS dbl) AS broken ON (
                   SELECT MAX(1) 
                   FROM (select 3 AS baz) AS c 
                   WHERE c.baz = t.fup
      )
      ;
      

      See attached *.err file for crash details. I tested this same query on MariaDB 10.4.12 and it worked fine (produced expected error without crash).

      Attachments

        Issue Links

          Activity

            alice Alice Sherepa added a comment -

            Thank you! I repeated as described on 10.4-10.6

            10.4 0604592a855a9c1f33e99

            210723 12:27:31 [ERROR] mysqld got signal 11 ;
             
            Server version: 10.4.21-MariaDB-debug-log
             
            sigaction.c:0(__restore_rt)[0x7ff970a0f3c0]
            sql/item.cc:5455(Item_field::fix_outer_field(THD*, Field**, Item**))[0x56453bffb0de]
            sql/item.cc:5870(Item_field::fix_fields(THD*, Item**))[0x56453bffeaf9]
            sql/item.h:964(Item::fix_fields_if_needed(THD*, Item**))[0x56453b4df8bf]
            sql/item_func.cc:352(Item_func::fix_fields(THD*, Item**))[0x56453c0d365c]
            sql/item.h:964(Item::fix_fields_if_needed(THD*, Item**))[0x56453b4df8bf]
            sql/item.h:968(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x56453b4df8f9]
            sql/item.h:973(Item::fix_fields_if_needed_for_bool(THD*, Item**))[0x56453b6121f9]
            sql/sql_base.cc:8450(setup_conds(THD*, TABLE_LIST*, List<TABLE_LIST>&, Item**))[0x56453b608e84]
            sql/sql_select.cc:724(setup_without_group(THD*, Bounds_checked_array<Item*>, TABLE_LIST*, List<TABLE_LIST>&, List<Item>&, List<Item>&, Item**, st_order*, st_order*, List<Window_spec>&, List<Item_window_func>&, bool*, unsigned int*))[0x56453b81ea6c]
            sql/sql_select.cc:1280(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x56453b825e33]
            sql/item_subselect.cc:3825(subselect_single_select_engine::prepare(THD*))[0x56453c1cbe3a]
            sql/item_subselect.cc:289(Item_subselect::fix_fields(THD*, Item**))[0x56453c1a5a8b]
            sql/item.h:964(Item::fix_fields_if_needed(THD*, Item**))[0x56453b4df8bf]
            sql/item.h:968(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x56453b4df8f9]
            sql/item.h:973(Item::fix_fields_if_needed_for_bool(THD*, Item**))[0x56453b6121f9]
            sql/sql_base.cc:8341(setup_on_expr(THD*, TABLE_LIST*, bool))[0x56453b6082f5]
            sql/sql_base.cc:8458(setup_conds(THD*, TABLE_LIST*, List<TABLE_LIST>&, Item**))[0x56453b608eac]
            sql/sql_select.cc:724(setup_without_group(THD*, Bounds_checked_array<Item*>, TABLE_LIST*, List<TABLE_LIST>&, List<Item>&, List<Item>&, Item**, st_order*, st_order*, List<Window_spec>&, List<Item_window_func>&, bool*, unsigned int*))[0x56453b81ea6c]
            sql/sql_select.cc:1280(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x56453b825e33]
            sql/sql_select.cc:4716(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*))[0x56453b84b50f]
            sql/sql_select.cc:436(handle_select(THD*, LEX*, select_result*, unsigned long))[0x56453b81cb6c]
            sql/sql_parse.cc:4714(mysql_execute_command(THD*))[0x56453b77e332]
            sql/sql_parse.cc:7992(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x56453b795131]
            sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x56453b76b8e1]
            sql/sql_parse.cc:1373(do_command(THD*))[0x56453b76835e]
            sql/sql_connect.cc:1412(do_handle_one_connection(CONNECT*))[0x56453bb60a5a]
            sql/sql_connect.cc:1317(handle_one_connection)[0x56453bb602fe]
            perfschema/pfs.cc:1871(pfs_spawn_thread)[0x56453d238cc9]
            nptl/pthread_create.c:478(start_thread)[0x7ff970a03609]
            x86_64/clone.S:97(__GI___clone)[0x7ff9705d8293]
             
             
            Query (0x62b000111290): INSERT INTO tmp
            SELECT t.foo AS id
            FROM
            (SELECT 1 AS foo) AS t
            LEFT JOIN
            (SELECT 1 AS dbl) AS broken ON
            ( SELECT max(1)
            FROM
            (SELECT 3 AS baz) AS c
            WHERE c.baz = t.fup)
            

            alice Alice Sherepa added a comment - Thank you! I repeated as described on 10.4-10.6 10.4 0604592a855a9c1f33e99 210723 12:27:31 [ERROR] mysqld got signal 11 ;   Server version: 10.4.21-MariaDB-debug-log   sigaction.c:0(__restore_rt)[0x7ff970a0f3c0] sql/item.cc:5455(Item_field::fix_outer_field(THD*, Field**, Item**))[0x56453bffb0de] sql/item.cc:5870(Item_field::fix_fields(THD*, Item**))[0x56453bffeaf9] sql/item.h:964(Item::fix_fields_if_needed(THD*, Item**))[0x56453b4df8bf] sql/item_func.cc:352(Item_func::fix_fields(THD*, Item**))[0x56453c0d365c] sql/item.h:964(Item::fix_fields_if_needed(THD*, Item**))[0x56453b4df8bf] sql/item.h:968(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x56453b4df8f9] sql/item.h:973(Item::fix_fields_if_needed_for_bool(THD*, Item**))[0x56453b6121f9] sql/sql_base.cc:8450(setup_conds(THD*, TABLE_LIST*, List<TABLE_LIST>&, Item**))[0x56453b608e84] sql/sql_select.cc:724(setup_without_group(THD*, Bounds_checked_array<Item*>, TABLE_LIST*, List<TABLE_LIST>&, List<Item>&, List<Item>&, Item**, st_order*, st_order*, List<Window_spec>&, List<Item_window_func>&, bool*, unsigned int*))[0x56453b81ea6c] sql/sql_select.cc:1280(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x56453b825e33] sql/item_subselect.cc:3825(subselect_single_select_engine::prepare(THD*))[0x56453c1cbe3a] sql/item_subselect.cc:289(Item_subselect::fix_fields(THD*, Item**))[0x56453c1a5a8b] sql/item.h:964(Item::fix_fields_if_needed(THD*, Item**))[0x56453b4df8bf] sql/item.h:968(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x56453b4df8f9] sql/item.h:973(Item::fix_fields_if_needed_for_bool(THD*, Item**))[0x56453b6121f9] sql/sql_base.cc:8341(setup_on_expr(THD*, TABLE_LIST*, bool))[0x56453b6082f5] sql/sql_base.cc:8458(setup_conds(THD*, TABLE_LIST*, List<TABLE_LIST>&, Item**))[0x56453b608eac] sql/sql_select.cc:724(setup_without_group(THD*, Bounds_checked_array<Item*>, TABLE_LIST*, List<TABLE_LIST>&, List<Item>&, List<Item>&, Item**, st_order*, st_order*, List<Window_spec>&, List<Item_window_func>&, bool*, unsigned int*))[0x56453b81ea6c] sql/sql_select.cc:1280(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x56453b825e33] sql/sql_select.cc:4716(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*))[0x56453b84b50f] sql/sql_select.cc:436(handle_select(THD*, LEX*, select_result*, unsigned long))[0x56453b81cb6c] sql/sql_parse.cc:4714(mysql_execute_command(THD*))[0x56453b77e332] sql/sql_parse.cc:7992(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x56453b795131] sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x56453b76b8e1] sql/sql_parse.cc:1373(do_command(THD*))[0x56453b76835e] sql/sql_connect.cc:1412(do_handle_one_connection(CONNECT*))[0x56453bb60a5a] sql/sql_connect.cc:1317(handle_one_connection)[0x56453bb602fe] perfschema/pfs.cc:1871(pfs_spawn_thread)[0x56453d238cc9] nptl/pthread_create.c:478(start_thread)[0x7ff970a03609] x86_64/clone.S:97(__GI___clone)[0x7ff9705d8293]     Query (0x62b000111290): INSERT INTO tmp SELECT t.foo AS id FROM (SELECT 1 AS foo) AS t LEFT JOIN (SELECT 1 AS dbl) AS broken ON ( SELECT max(1) FROM (SELECT 3 AS baz) AS c WHERE c.baz = t.fup)

            With CREATE VIEW instead of INSERT:

            CREATE TABLE t (a int);
            INSERT INTO t VALUES (1),(2); # Optional, fails either way
             
            CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column FROM t);
            

            10.4 9a0cbd31

            #2  0x0000560107e5c5a1 in handle_fatal_signal (sig=11) at /data/src/10.4/sql/signal_handler.cc:366
                    curr_time = 1657456648
                    tm = {tm_sec = 28, tm_min = 37, tm_hour = 15, tm_mday = 10, tm_mon = 6, tm_year = 122, tm_wday = 0, tm_yday = 190, tm_isdst = 1, tm_gmtoff = 10800, tm_zone = 0x56010b924930 "EEST"}
                    thd = 0x7fd280000d90
                    print_invalid_query_pointer = false
            #3  <signal handler called>
            No locals.
            #4  0x0000560107e8dab6 in Item_field::fix_outer_field (this=0x7fd280016a18, thd=0x7fd280000d90, from_field=0x7fd2908a9c40, reference=0x7fd280016b30) at /data/src/10.4/sql/item.cc:5567
                    prev_subselect_item = 0x0
                    place = IN_ON
                    field_found = false
                    upward_lookup = true
                    table_list = 0x0
                    last_checked_context = 0x7fd280005518
                    ref = 0x1
                    current_sel = 0x7fd280016580
                    outer_context = 0x7fd280005518
                    select = 0x7fd2800054c8
                    __PRETTY_FUNCTION__ = "int Item_field::fix_outer_field(THD*, Field**, Item**)"
            #5  0x0000560107e8f150 in Item_field::fix_fields (this=0x7fd280016a18, thd=0x7fd280000d90, reference=0x7fd280016b30) at /data/src/10.4/sql/item.cc:5984
                    ret = 0
                    table_list = 0x5601092be3a0 <end_of_list>
                    __PRETTY_FUNCTION__ = "virtual bool Item_field::fix_fields(THD*, Item**)"
                    from_field = 0x1
                    outer_fixed = false
                    select = 0x7fd280016580
            #6  0x0000560107a0f429 in Item::fix_fields_if_needed (this=0x7fd280016a18, thd=0x7fd280000d90, ref=0x7fd280016b30) at /data/src/10.4/sql/item.h:964
            No locals.
            #7  0x0000560107a0f45f in Item::fix_fields_if_needed_for_scalar (this=0x7fd280016a18, thd=0x7fd280000d90, ref=0x7fd280016b30) at /data/src/10.4/sql/item.h:968
            No locals.
            #8  0x0000560107a8f2f0 in setup_fields (thd=0x7fd280000d90, ref_pointer_array={m_array = 0x7fd280019c38, m_size = 3}, fields=@0x7fd2800166c8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fd280016b28, last = 0x7fd280016b28, elements = 1}, <No data fields>}, column_usage=MARK_COLUMNS_READ, sum_func_list=0x7fd2800199d8, pre_fix=0x7fd2800166e0, allow_sum_func=true) at /data/src/10.4/sql/sql_base.cc:7714
                    item = 0x7fd280016a18
                    saved_column_usage = MARK_COLUMNS_READ
                    save_allow_sum_func = {buffer = {0}}
                    it = {<base_list_iterator> = {list = 0x7fd2800166c8, el = 0x7fd280016b28, prev = 0x7fd2800166c8, current = 0x7fd280016b28}, <No data fields>}
                    save_is_item_list_lookup = true
                    make_pre_fix = true
                    _db_stack_frame_ = {func = 0x560108828487 "JOIN::prepare", file = 0x560108827fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483661, line = -1, prev = 0x7fd2908a9ec0}
                    __PRETTY_FUNCTION__ = "bool setup_fields(THD*, Ref_ptr_array, List<Item>&, enum_column_usage, List<Item>*, List<Item>*, bool)"
                    li = {<base_list_iterator> = {list = 0x7fd280005c58, el = 0x5601092be3a0 <end_of_list>, prev = 0x7fd280005c58, current = 0x5601092be3a0 <end_of_list>}, <No data fields>}
                    var = 0x0
                    ref = {m_array = 0x7fd280019c38, m_size = 3}
            #9  0x0000560107b6ff2a in JOIN::prepare (this=0x7fd2800196b8, tables_init=0x7fd280016b70, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7fd280016580, unit_arg=0x7fd280017260) at /data/src/10.4/sql/sql_select.cc:1278
                    _db_stack_frame_ = {func = 0x5601089d999a "Item_in_subselect::fix_fields", file = 0x5601089d82b8 "/data/src/10.4/sql/item_subselect.cc", level = 2147483660, line = -1, prev = 0x7fd2908aa0c0}
                    trace_wrapper = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f94510 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
                    trace_prepare = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f94510 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
                    trace_steps = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f944f0 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
                    tbl = 0x0
                    li = {<base_list_iterator> = {list = 0x7fd2800167b8, el = 0x5601092be3a0 <end_of_list>, prev = 0x0, current = 0x0}, <No data fields>}
                    real_og_num = 0
                    __PRETTY_FUNCTION__ = "int JOIN::prepare(TABLE_LIST*, uint, COND*, uint, ORDER*, bool, ORDER*, Item*, ORDER*, SELECT_LEX*, SELECT_LEX_UNIT*)"
                    save_place = NO_MATTER
                    with_clause = 0x560108723088 <my_thread_var_dbug+31>
                    with_elem = 0x7fd280000cd0
                    res = 324
            #10 0x0000560107f4ec6d in subselect_single_select_engine::prepare (this=0x7fd280017c90, thd=0x7fd280000d90) at /data/src/10.4/sql/item_subselect.cc:3845
                    save_select = 0x7fd280015000
            #11 0x0000560107f412f1 in Item_subselect::fix_fields (this=0x7fd280017a68, thd_param=0x7fd280000d90, ref=0x7fd280015d70) at /data/src/10.4/sql/item_subselect.cc:289
                    save_where = 0x5601089d9952 "IN/ALL/ANY subquery"
                    uncacheable = 0 '\000'
                    res = false
                    __PRETTY_FUNCTION__ = "virtual bool Item_subselect::fix_fields(THD*, Item**)"
            #12 0x0000560107f4dbb6 in Item_in_subselect::fix_fields (this=0x7fd280017a68, thd_arg=0x7fd280000d90, ref=0x7fd280015d70) at /data/src/10.4/sql/item_subselect.cc:3507
                    outer_cols_num = 0
                    inner_cols = 0x7fd2908aa320
                    save_where = 0x560108803c11 "on clause"
                    _db_stack_frame_ = {func = 0x560108803c1b "setup_conds", file = 0x560108801108 "/data/src/10.4/sql/sql_base.cc", level = 2147483659, line = -1, prev = 0x7fd2908aa3d0}
                    __PRETTY_FUNCTION__ = "virtual bool Item_in_subselect::fix_fields(THD*, Item**)"
            #13 0x0000560107a0f429 in Item::fix_fields_if_needed (this=0x7fd280017a68, thd=0x7fd280000d90, ref=0x7fd280015d70) at /data/src/10.4/sql/item.h:964
            No locals.
            #14 0x0000560107a0f45f in Item::fix_fields_if_needed_for_scalar (this=0x7fd280017a68, thd=0x7fd280000d90, ref=0x7fd280015d70) at /data/src/10.4/sql/item.h:968
            No locals.
            #15 0x0000560107a953af in Item::fix_fields_if_needed_for_bool (this=0x7fd280017a68, thd=0x7fd280000d90, ref=0x7fd280015d70) at /data/src/10.4/sql/item.h:972
            No locals.
            #16 0x0000560107a913b2 in setup_on_expr (thd=0x7fd280000d90, table=0x7fd280015d10, is_update=false) at /data/src/10.4/sql/sql_base.cc:8332
                    embedded = 0x7fd280015d10
                    embedding = 0x7fd280015d10
                    buff = " \242\212\220\322\177\000\000\306\030\306\a\001V\000\000\230\203\001\200\000\000\000\000\370U\001\200\322\177\000\000\200\242\212\220\322\177\000\000\061\032\306\a\000\000\000\000\b\001\275\b\001V\000\000\000\000\000\000\000\000\000\000`\242\212\220\322\177\000\000\\/r\b\001V\000\000p\242\212\220\322\177\000\000\\/r\b\001V\000\000\200\242\212\220\322\177\000\000\210\060r\b\001V\000\000\220\242\212\220\322\177\000\000`\v\000\200\322\177\000\000\240\242\212\220\322\177\000\000\341rt\b\001V\000\000\320\f\000\200\322\177\000\000\260\f\000\200\322\177\000\000\320\242\212\220\322\177\000\000\002\233t\b\001V\000\000W\001\275\b\001V\000\000\320\f\000\200\030\001\000\000\320|\001\200\322\177\000\000\000"...
            #17 0x0000560107a91847 in setup_conds (thd=0x7fd280000d90, tables=0x7fd2800155f8, leaves=@0x7fd280015238: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fd280019470, last = 0x7fd280019480, elements = 2}, <No data fields>}, conds=0x7fd280019308) at /data/src/10.4/sql/sql_base.cc:8451
                    select_lex = 0x7fd280015000
                    table = 0x0
                    it_is_update = false
                    save_is_item_list_lookup = true
                    derived = 0x0
                    save_resolve_in_select_list = true
                    _db_stack_frame_ = {func = 0x5601088281a1 "setup_without_group", file = 0x560108827fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483658, line = -1, prev = 0x7fd2908aa460}
            #18 0x0000560107b6d213 in setup_without_group (thd=0x7fd280000d90, ref_pointer_array={m_array = 0x7fd2800195b8, m_size = 6}, tables=0x7fd2800155f8, leaves=@0x7fd280015238: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fd280019470, last = 0x7fd280019480, elements = 2}, <No data fields>}, fields=@0x7fd280015148: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fd2800155a0, last = 0x7fd2800155a0, elements = 1}, <No data fields>}, all_fields=@0x7fd280019220: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fd2800155a0, last = 0x7fd2800155a0, elements = 1}, <No data fields>}, conds=0x7fd280019308, order=0x0, group=0x0, win_specs=@0x7fd280015430: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5601092be3a0 <end_of_list>, last = 0x7fd280015430, elements = 0}, <No data fields>}, win_funcs=@0x7fd280015448: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5601092be3a0 <end_of_list>, last = 0x7fd280015448, elements = 0}, <No data fields>}, hidden_group_fields=0x7fd2800191e7, reserved=0x7fd280015304) at /data/src/10.4/sql/sql_select.cc:724
                    res = 5
                    save_place = NO_MATTER
                    select = 0x7fd280015000
                    save_allow_sum_func = {buffer = {0}}
                    saved_non_agg_field_used = false
                    _db_stack_frame_ = {func = 0x560108828487 "JOIN::prepare", file = 0x560108827fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483657, line = -1, prev = 0x7fd2908aa590}
            #19 0x0000560107b70063 in JOIN::prepare (this=0x7fd280018f00, tables_init=0x7fd2800155f8, wild_num=1, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7fd280015000, unit_arg=0x7fd280004cc0) at /data/src/10.4/sql/sql_select.cc:1283
                    _db_stack_frame_ = {func = 0x56010883e720 "st_select_lex_unit::prepare_join", file = 0x56010883e558 "/data/src/10.4/sql/sql_union.cc", level = 2147483656, line = -1, prev = 0x7fd2908aa710}
                    trace_wrapper = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f94510 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
                    trace_prepare = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f94510 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
                    trace_steps = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f944f0 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
                    tbl = 0x0
                    li = {<base_list_iterator> = {list = 0x7fd280015238, el = 0x5601092be3a0 <end_of_list>, prev = 0x0, current = 0x0}, <No data fields>}
                    real_og_num = 0
                    __PRETTY_FUNCTION__ = "int JOIN::prepare(TABLE_LIST*, uint, COND*, uint, ORDER*, bool, ORDER*, Item*, ORDER*, SELECT_LEX*, SELECT_LEX_UNIT*)"
                    save_place = NO_MATTER
                    with_clause = 0x560108723088 <my_thread_var_dbug+31>
                    with_elem = 0x7fd280000cd0
                    res = 1
            #20 0x0000560107c34730 in st_select_lex_unit::prepare_join (this=0x7fd280004cc0, thd_arg=0x7fd280000d90, sl=0x7fd280015000, tmp_result=0x0, additional_options=0, is_union_select=false) at /data/src/10.4/sql/sql_union.cc:647
                    _db_stack_frame_ = {func = 0x56010883e931 "st_select_lex_unit::prepare", file = 0x56010883e558 "/data/src/10.4/sql/sql_union.cc", level = 2147483655, line = -1, prev = 0x7fd2908aa830}
                    derived = 0x0
                    can_skip_order_by = false
                    join = 0x7fd280018f00
            #21 0x0000560107c35df8 in st_select_lex_unit::prepare (this=0x7fd280004cc0, derived_arg=0x0, sel_result=0x0, additional_options=0) at /data/src/10.4/sql/sql_union.cc:994
                    lex_select_save = 0x7fd280015000
                    sl = 0x7fd280015000
                    first_sl = 0x7fd280015000
                    is_recursive = false
                    is_rec_result_table_created = false
                    union_part_count = 0
                    tmp_result = 0x0
                    is_union_select = false
                    have_except = false
                    have_intersect = false
                    instantiate_tmp_table = false
                    single_tvc = false
                    single_tvc_wo_order = false
                    _db_stack_frame_ = {func = 0x5601088408fa "mysql_create_view", file = 0x560108840888 "/data/src/10.4/sql/sql_view.cc", level = 2147483654, line = -1, prev = 0x7fd2908aa990}
                    __PRETTY_FUNCTION__ = "bool st_select_lex_unit::prepare(TABLE_LIST*, select_result*, ulong)"
            #22 0x0000560107c4794d in mysql_create_view (thd=0x7fd280000d90, views=0x7fd280014930, mode=VIEW_CREATE_NEW) at /data/src/10.4/sql/sql_view.cc:539
                    lex = 0x7fd280004c00
                    link_to_local = true
                    view = 0x7fd280014930
                    tables = 0x7fd2800155f8
                    tbl = 0x0
                    select_lex = 0x7fd280015000
                    sl = 0x7fd200000000
                    unit = 0x7fd280004cc0
                    res = false
                    _db_stack_frame_ = {func = 0x56010881b930 "mysql_execute_command", file = 0x56010881acc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7fd2908aac80}
                    __PRETTY_FUNCTION__ = "bool mysql_create_view(THD*, TABLE_LIST*, enum_view_create_mode)"
            #23 0x0000560107b300d2 in mysql_execute_command (thd=0x7fd280000d90) at /data/src/10.4/sql/sql_parse.cc:6007
                    res = 0
                    up_result = 0
                    lex = 0x7fd280004c00
                    select_lex = 0x7fd280015000
                    first_table = 0x7fd280014930
                    all_tables = 0x7fd280014930
                    unit = 0x7fd280004cc0
                    have_table_map_for_update = false
                    rpl_filter = 0x560107f84d49 <inline_mysql_mutex_unlock(mysql_mutex_t*, char const*, uint)+107>
                    _db_stack_frame_ = {func = 0x56010881cbb8 "mysql_parse", file = 0x56010881acc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7fd2908ab250}
                    __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)"
                    ots = {ctx = 0x7fd2800048e0, traceable = false}
                    trace_command = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f94510 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
                    trace_command_steps = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f944f0 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
                    orig_binlog_format = BINLOG_FORMAT_MIXED
                    orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT
            #24 0x0000560107b35e72 in mysql_parse (thd=0x7fd280000d90, rawbuf=0x7fd2800147a8 "CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column FROM t)", length=96, parser_state=0x7fd2908ab410, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7995
                    found_semicolon = 0x0
                    error = 32722
                    lex = 0x7fd280004c00
                    err = false
                    _db_stack_frame_ = {func = 0x56010881b13a "dispatch_command", file = 0x56010881acc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7fd2908ab3f0}
                    __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*, bool, bool)"
            #25 0x0000560107b22312 in dispatch_command (command=COM_QUERY, thd=0x7fd280000d90, packet=0x7fd28000ac01 "CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column FROM t)", packet_length=96, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857
                    packet_end = 0x7fd280014808 ""
                    parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7fd280000d90, m_ptr = 0x7fd280014809 "\004", m_tok_start = 0x7fd280014809 "\004", m_tok_end = 0x7fd280014809 "\004", m_end_of_query = 0x7fd280014808 "", m_tok_start_prev = 0x7fd280014808 "", m_buf = 0x7fd2800147a8 "CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column FROM t)", m_buf_length = 96, m_echo = true, m_echo_saved = 12, m_cpp_buf = 0x7fd280014860 "CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column FROM t)", m_cpp_ptr = 0x7fd2800148c0 "", m_cpp_tok_start = 0x7fd2800148c0 "", m_cpp_tok_start_prev = 0x7fd2800148c0 "", m_cpp_tok_end = 0x7fd2800148c0 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x56010874a6d3 <DoTrace+150> "\203\370\005\177\063\205\300\017\210\255", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, ignore_space = false, stmt_prepare_mode = false, multi_statements = true, yylineno = 1, m_digest = 0x0, in_comment = NO_COMMENT, in_comment_saved = (PRESERVE_COMMENT | unknown: 0x5600), m_cpp_text_start = 0x7fd2800148be "t)", m_cpp_text_end = 0x7fd2800148bf ")", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 <repeats 12 times>}}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x7fd2800046e0}
                    net = 0x7fd2800010b8
                    error = false
                    do_end_of_statement = true
                    _db_stack_frame_ = {func = 0x56010881aec5 "do_command", file = 0x56010881acc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7fd2908abcb0}
                    drop_more_results = false
                    __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint, bool, bool)"
                    __FUNCTION__ = "dispatch_command"
                    res = <optimized out>
            #26 0x0000560107b20bc5 in do_command (thd=0x7fd280000d90) at /data/src/10.4/sql/sql_parse.cc:1378
                    return_value = false
                    packet = 0x7fd28000ac00 "\003CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column FROM t)"
                    packet_length = 97
                    net = 0x7fd2800010b8
                    command = COM_QUERY
                    _db_stack_frame_ = {func = 0x560108bd6368 "?func", file = 0x560108bd636e "?file", level = 2147483649, line = -1, prev = 0x0}
                    __PRETTY_FUNCTION__ = "bool do_command(THD*)"
                    __FUNCTION__ = "do_command"
            #27 0x0000560107cafcb1 in do_handle_one_connection (connect=0x56010bc1d460) at /data/src/10.4/sql/sql_connect.cc:1420
                    create_user = true
                    thr_create_utime = 3878760542504
                    thd = 0x7fd280000d90
                    __PRETTY_FUNCTION__ = "void do_handle_one_connection(CONNECT*)"
            #28 0x0000560107caf959 in handle_one_connection (arg=0x56010bc1d460) at /data/src/10.4/sql/sql_connect.cc:1316
                    connect = 0x56010bc1d460
            #29 0x00005601081ccc69 in pfs_spawn_thread (arg=0x56010bc94e60) at /data/src/10.4/storage/perfschema/pfs.cc:1869
                    typed_arg = 0x56010bc94e60
                    user_arg = 0x56010bc1d460
                    user_start_routine = 0x560107caf929 <handle_one_connection(void*)>
                    pfs = 0x7fd294bd06c0
                    klass = 0x56010b93ec00
            #30 0x00007fd296da5ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
                    ret = <optimized out>
                    pd = <optimized out>
                    unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140542344873728, -6042312553587541252, 140724509942974, 140724509942975, 140542344871552, 311296, 6016885705157376764, 6016889410557967100}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
                    not_first_call = 0
            #31 0x00007fd2969a2def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
            

            elenst Elena Stepanova added a comment - With CREATE VIEW instead of INSERT : CREATE TABLE t (a int ); INSERT INTO t VALUES (1),(2); # Optional, fails either way   CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN ( SELECT unknown_column FROM t); 10.4 9a0cbd31 #2 0x0000560107e5c5a1 in handle_fatal_signal (sig=11) at /data/src/10.4/sql/signal_handler.cc:366 curr_time = 1657456648 tm = {tm_sec = 28, tm_min = 37, tm_hour = 15, tm_mday = 10, tm_mon = 6, tm_year = 122, tm_wday = 0, tm_yday = 190, tm_isdst = 1, tm_gmtoff = 10800, tm_zone = 0x56010b924930 "EEST"} thd = 0x7fd280000d90 print_invalid_query_pointer = false #3 <signal handler called> No locals. #4 0x0000560107e8dab6 in Item_field::fix_outer_field (this=0x7fd280016a18, thd=0x7fd280000d90, from_field=0x7fd2908a9c40, reference=0x7fd280016b30) at /data/src/10.4/sql/item.cc:5567 prev_subselect_item = 0x0 place = IN_ON field_found = false upward_lookup = true table_list = 0x0 last_checked_context = 0x7fd280005518 ref = 0x1 current_sel = 0x7fd280016580 outer_context = 0x7fd280005518 select = 0x7fd2800054c8 __PRETTY_FUNCTION__ = "int Item_field::fix_outer_field(THD*, Field**, Item**)" #5 0x0000560107e8f150 in Item_field::fix_fields (this=0x7fd280016a18, thd=0x7fd280000d90, reference=0x7fd280016b30) at /data/src/10.4/sql/item.cc:5984 ret = 0 table_list = 0x5601092be3a0 <end_of_list> __PRETTY_FUNCTION__ = "virtual bool Item_field::fix_fields(THD*, Item**)" from_field = 0x1 outer_fixed = false select = 0x7fd280016580 #6 0x0000560107a0f429 in Item::fix_fields_if_needed (this=0x7fd280016a18, thd=0x7fd280000d90, ref=0x7fd280016b30) at /data/src/10.4/sql/item.h:964 No locals. #7 0x0000560107a0f45f in Item::fix_fields_if_needed_for_scalar (this=0x7fd280016a18, thd=0x7fd280000d90, ref=0x7fd280016b30) at /data/src/10.4/sql/item.h:968 No locals. #8 0x0000560107a8f2f0 in setup_fields (thd=0x7fd280000d90, ref_pointer_array={m_array = 0x7fd280019c38, m_size = 3}, fields=@0x7fd2800166c8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fd280016b28, last = 0x7fd280016b28, elements = 1}, <No data fields>}, column_usage=MARK_COLUMNS_READ, sum_func_list=0x7fd2800199d8, pre_fix=0x7fd2800166e0, allow_sum_func=true) at /data/src/10.4/sql/sql_base.cc:7714 item = 0x7fd280016a18 saved_column_usage = MARK_COLUMNS_READ save_allow_sum_func = {buffer = {0}} it = {<base_list_iterator> = {list = 0x7fd2800166c8, el = 0x7fd280016b28, prev = 0x7fd2800166c8, current = 0x7fd280016b28}, <No data fields>} save_is_item_list_lookup = true make_pre_fix = true _db_stack_frame_ = {func = 0x560108828487 "JOIN::prepare", file = 0x560108827fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483661, line = -1, prev = 0x7fd2908a9ec0} __PRETTY_FUNCTION__ = "bool setup_fields(THD*, Ref_ptr_array, List<Item>&, enum_column_usage, List<Item>*, List<Item>*, bool)" li = {<base_list_iterator> = {list = 0x7fd280005c58, el = 0x5601092be3a0 <end_of_list>, prev = 0x7fd280005c58, current = 0x5601092be3a0 <end_of_list>}, <No data fields>} var = 0x0 ref = {m_array = 0x7fd280019c38, m_size = 3} #9 0x0000560107b6ff2a in JOIN::prepare (this=0x7fd2800196b8, tables_init=0x7fd280016b70, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7fd280016580, unit_arg=0x7fd280017260) at /data/src/10.4/sql/sql_select.cc:1278 _db_stack_frame_ = {func = 0x5601089d999a "Item_in_subselect::fix_fields", file = 0x5601089d82b8 "/data/src/10.4/sql/item_subselect.cc", level = 2147483660, line = -1, prev = 0x7fd2908aa0c0} trace_wrapper = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f94510 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>} trace_prepare = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f94510 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>} trace_steps = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f944f0 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>} tbl = 0x0 li = {<base_list_iterator> = {list = 0x7fd2800167b8, el = 0x5601092be3a0 <end_of_list>, prev = 0x0, current = 0x0}, <No data fields>} real_og_num = 0 __PRETTY_FUNCTION__ = "int JOIN::prepare(TABLE_LIST*, uint, COND*, uint, ORDER*, bool, ORDER*, Item*, ORDER*, SELECT_LEX*, SELECT_LEX_UNIT*)" save_place = NO_MATTER with_clause = 0x560108723088 <my_thread_var_dbug+31> with_elem = 0x7fd280000cd0 res = 324 #10 0x0000560107f4ec6d in subselect_single_select_engine::prepare (this=0x7fd280017c90, thd=0x7fd280000d90) at /data/src/10.4/sql/item_subselect.cc:3845 save_select = 0x7fd280015000 #11 0x0000560107f412f1 in Item_subselect::fix_fields (this=0x7fd280017a68, thd_param=0x7fd280000d90, ref=0x7fd280015d70) at /data/src/10.4/sql/item_subselect.cc:289 save_where = 0x5601089d9952 "IN/ALL/ANY subquery" uncacheable = 0 '\000' res = false __PRETTY_FUNCTION__ = "virtual bool Item_subselect::fix_fields(THD*, Item**)" #12 0x0000560107f4dbb6 in Item_in_subselect::fix_fields (this=0x7fd280017a68, thd_arg=0x7fd280000d90, ref=0x7fd280015d70) at /data/src/10.4/sql/item_subselect.cc:3507 outer_cols_num = 0 inner_cols = 0x7fd2908aa320 save_where = 0x560108803c11 "on clause" _db_stack_frame_ = {func = 0x560108803c1b "setup_conds", file = 0x560108801108 "/data/src/10.4/sql/sql_base.cc", level = 2147483659, line = -1, prev = 0x7fd2908aa3d0} __PRETTY_FUNCTION__ = "virtual bool Item_in_subselect::fix_fields(THD*, Item**)" #13 0x0000560107a0f429 in Item::fix_fields_if_needed (this=0x7fd280017a68, thd=0x7fd280000d90, ref=0x7fd280015d70) at /data/src/10.4/sql/item.h:964 No locals. #14 0x0000560107a0f45f in Item::fix_fields_if_needed_for_scalar (this=0x7fd280017a68, thd=0x7fd280000d90, ref=0x7fd280015d70) at /data/src/10.4/sql/item.h:968 No locals. #15 0x0000560107a953af in Item::fix_fields_if_needed_for_bool (this=0x7fd280017a68, thd=0x7fd280000d90, ref=0x7fd280015d70) at /data/src/10.4/sql/item.h:972 No locals. #16 0x0000560107a913b2 in setup_on_expr (thd=0x7fd280000d90, table=0x7fd280015d10, is_update=false) at /data/src/10.4/sql/sql_base.cc:8332 embedded = 0x7fd280015d10 embedding = 0x7fd280015d10 buff = " \242\212\220\322\177\000\000\306\030\306\a\001V\000\000\230\203\001\200\000\000\000\000\370U\001\200\322\177\000\000\200\242\212\220\322\177\000\000\061\032\306\a\000\000\000\000\b\001\275\b\001V\000\000\000\000\000\000\000\000\000\000`\242\212\220\322\177\000\000\\/r\b\001V\000\000p\242\212\220\322\177\000\000\\/r\b\001V\000\000\200\242\212\220\322\177\000\000\210\060r\b\001V\000\000\220\242\212\220\322\177\000\000`\v\000\200\322\177\000\000\240\242\212\220\322\177\000\000\341rt\b\001V\000\000\320\f\000\200\322\177\000\000\260\f\000\200\322\177\000\000\320\242\212\220\322\177\000\000\002\233t\b\001V\000\000W\001\275\b\001V\000\000\320\f\000\200\030\001\000\000\320|\001\200\322\177\000\000\000"... #17 0x0000560107a91847 in setup_conds (thd=0x7fd280000d90, tables=0x7fd2800155f8, leaves=@0x7fd280015238: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fd280019470, last = 0x7fd280019480, elements = 2}, <No data fields>}, conds=0x7fd280019308) at /data/src/10.4/sql/sql_base.cc:8451 select_lex = 0x7fd280015000 table = 0x0 it_is_update = false save_is_item_list_lookup = true derived = 0x0 save_resolve_in_select_list = true _db_stack_frame_ = {func = 0x5601088281a1 "setup_without_group", file = 0x560108827fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483658, line = -1, prev = 0x7fd2908aa460} #18 0x0000560107b6d213 in setup_without_group (thd=0x7fd280000d90, ref_pointer_array={m_array = 0x7fd2800195b8, m_size = 6}, tables=0x7fd2800155f8, leaves=@0x7fd280015238: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fd280019470, last = 0x7fd280019480, elements = 2}, <No data fields>}, fields=@0x7fd280015148: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fd2800155a0, last = 0x7fd2800155a0, elements = 1}, <No data fields>}, all_fields=@0x7fd280019220: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fd2800155a0, last = 0x7fd2800155a0, elements = 1}, <No data fields>}, conds=0x7fd280019308, order=0x0, group=0x0, win_specs=@0x7fd280015430: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5601092be3a0 <end_of_list>, last = 0x7fd280015430, elements = 0}, <No data fields>}, win_funcs=@0x7fd280015448: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5601092be3a0 <end_of_list>, last = 0x7fd280015448, elements = 0}, <No data fields>}, hidden_group_fields=0x7fd2800191e7, reserved=0x7fd280015304) at /data/src/10.4/sql/sql_select.cc:724 res = 5 save_place = NO_MATTER select = 0x7fd280015000 save_allow_sum_func = {buffer = {0}} saved_non_agg_field_used = false _db_stack_frame_ = {func = 0x560108828487 "JOIN::prepare", file = 0x560108827fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483657, line = -1, prev = 0x7fd2908aa590} #19 0x0000560107b70063 in JOIN::prepare (this=0x7fd280018f00, tables_init=0x7fd2800155f8, wild_num=1, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7fd280015000, unit_arg=0x7fd280004cc0) at /data/src/10.4/sql/sql_select.cc:1283 _db_stack_frame_ = {func = 0x56010883e720 "st_select_lex_unit::prepare_join", file = 0x56010883e558 "/data/src/10.4/sql/sql_union.cc", level = 2147483656, line = -1, prev = 0x7fd2908aa710} trace_wrapper = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f94510 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>} trace_prepare = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f94510 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>} trace_steps = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f944f0 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>} tbl = 0x0 li = {<base_list_iterator> = {list = 0x7fd280015238, el = 0x5601092be3a0 <end_of_list>, prev = 0x0, current = 0x0}, <No data fields>} real_og_num = 0 __PRETTY_FUNCTION__ = "int JOIN::prepare(TABLE_LIST*, uint, COND*, uint, ORDER*, bool, ORDER*, Item*, ORDER*, SELECT_LEX*, SELECT_LEX_UNIT*)" save_place = NO_MATTER with_clause = 0x560108723088 <my_thread_var_dbug+31> with_elem = 0x7fd280000cd0 res = 1 #20 0x0000560107c34730 in st_select_lex_unit::prepare_join (this=0x7fd280004cc0, thd_arg=0x7fd280000d90, sl=0x7fd280015000, tmp_result=0x0, additional_options=0, is_union_select=false) at /data/src/10.4/sql/sql_union.cc:647 _db_stack_frame_ = {func = 0x56010883e931 "st_select_lex_unit::prepare", file = 0x56010883e558 "/data/src/10.4/sql/sql_union.cc", level = 2147483655, line = -1, prev = 0x7fd2908aa830} derived = 0x0 can_skip_order_by = false join = 0x7fd280018f00 #21 0x0000560107c35df8 in st_select_lex_unit::prepare (this=0x7fd280004cc0, derived_arg=0x0, sel_result=0x0, additional_options=0) at /data/src/10.4/sql/sql_union.cc:994 lex_select_save = 0x7fd280015000 sl = 0x7fd280015000 first_sl = 0x7fd280015000 is_recursive = false is_rec_result_table_created = false union_part_count = 0 tmp_result = 0x0 is_union_select = false have_except = false have_intersect = false instantiate_tmp_table = false single_tvc = false single_tvc_wo_order = false _db_stack_frame_ = {func = 0x5601088408fa "mysql_create_view", file = 0x560108840888 "/data/src/10.4/sql/sql_view.cc", level = 2147483654, line = -1, prev = 0x7fd2908aa990} __PRETTY_FUNCTION__ = "bool st_select_lex_unit::prepare(TABLE_LIST*, select_result*, ulong)" #22 0x0000560107c4794d in mysql_create_view (thd=0x7fd280000d90, views=0x7fd280014930, mode=VIEW_CREATE_NEW) at /data/src/10.4/sql/sql_view.cc:539 lex = 0x7fd280004c00 link_to_local = true view = 0x7fd280014930 tables = 0x7fd2800155f8 tbl = 0x0 select_lex = 0x7fd280015000 sl = 0x7fd200000000 unit = 0x7fd280004cc0 res = false _db_stack_frame_ = {func = 0x56010881b930 "mysql_execute_command", file = 0x56010881acc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7fd2908aac80} __PRETTY_FUNCTION__ = "bool mysql_create_view(THD*, TABLE_LIST*, enum_view_create_mode)" #23 0x0000560107b300d2 in mysql_execute_command (thd=0x7fd280000d90) at /data/src/10.4/sql/sql_parse.cc:6007 res = 0 up_result = 0 lex = 0x7fd280004c00 select_lex = 0x7fd280015000 first_table = 0x7fd280014930 all_tables = 0x7fd280014930 unit = 0x7fd280004cc0 have_table_map_for_update = false rpl_filter = 0x560107f84d49 <inline_mysql_mutex_unlock(mysql_mutex_t*, char const*, uint)+107> _db_stack_frame_ = {func = 0x56010881cbb8 "mysql_parse", file = 0x56010881acc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7fd2908ab250} __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" ots = {ctx = 0x7fd2800048e0, traceable = false} trace_command = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f94510 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>} trace_command_steps = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f944f0 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>} orig_binlog_format = BINLOG_FORMAT_MIXED orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT #24 0x0000560107b35e72 in mysql_parse (thd=0x7fd280000d90, rawbuf=0x7fd2800147a8 "CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column FROM t)", length=96, parser_state=0x7fd2908ab410, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7995 found_semicolon = 0x0 error = 32722 lex = 0x7fd280004c00 err = false _db_stack_frame_ = {func = 0x56010881b13a "dispatch_command", file = 0x56010881acc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7fd2908ab3f0} __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*, bool, bool)" #25 0x0000560107b22312 in dispatch_command (command=COM_QUERY, thd=0x7fd280000d90, packet=0x7fd28000ac01 "CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column FROM t)", packet_length=96, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857 packet_end = 0x7fd280014808 "" parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7fd280000d90, m_ptr = 0x7fd280014809 "\004", m_tok_start = 0x7fd280014809 "\004", m_tok_end = 0x7fd280014809 "\004", m_end_of_query = 0x7fd280014808 "", m_tok_start_prev = 0x7fd280014808 "", m_buf = 0x7fd2800147a8 "CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column FROM t)", m_buf_length = 96, m_echo = true, m_echo_saved = 12, m_cpp_buf = 0x7fd280014860 "CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column FROM t)", m_cpp_ptr = 0x7fd2800148c0 "", m_cpp_tok_start = 0x7fd2800148c0 "", m_cpp_tok_start_prev = 0x7fd2800148c0 "", m_cpp_tok_end = 0x7fd2800148c0 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x56010874a6d3 <DoTrace+150> "\203\370\005\177\063\205\300\017\210\255", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, ignore_space = false, stmt_prepare_mode = false, multi_statements = true, yylineno = 1, m_digest = 0x0, in_comment = NO_COMMENT, in_comment_saved = (PRESERVE_COMMENT | unknown: 0x5600), m_cpp_text_start = 0x7fd2800148be "t)", m_cpp_text_end = 0x7fd2800148bf ")", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 <repeats 12 times>}}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x7fd2800046e0} net = 0x7fd2800010b8 error = false do_end_of_statement = true _db_stack_frame_ = {func = 0x56010881aec5 "do_command", file = 0x56010881acc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7fd2908abcb0} drop_more_results = false __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint, bool, bool)" __FUNCTION__ = "dispatch_command" res = <optimized out> #26 0x0000560107b20bc5 in do_command (thd=0x7fd280000d90) at /data/src/10.4/sql/sql_parse.cc:1378 return_value = false packet = 0x7fd28000ac00 "\003CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column FROM t)" packet_length = 97 net = 0x7fd2800010b8 command = COM_QUERY _db_stack_frame_ = {func = 0x560108bd6368 "?func", file = 0x560108bd636e "?file", level = 2147483649, line = -1, prev = 0x0} __PRETTY_FUNCTION__ = "bool do_command(THD*)" __FUNCTION__ = "do_command" #27 0x0000560107cafcb1 in do_handle_one_connection (connect=0x56010bc1d460) at /data/src/10.4/sql/sql_connect.cc:1420 create_user = true thr_create_utime = 3878760542504 thd = 0x7fd280000d90 __PRETTY_FUNCTION__ = "void do_handle_one_connection(CONNECT*)" #28 0x0000560107caf959 in handle_one_connection (arg=0x56010bc1d460) at /data/src/10.4/sql/sql_connect.cc:1316 connect = 0x56010bc1d460 #29 0x00005601081ccc69 in pfs_spawn_thread (arg=0x56010bc94e60) at /data/src/10.4/storage/perfschema/pfs.cc:1869 typed_arg = 0x56010bc94e60 user_arg = 0x56010bc1d460 user_start_routine = 0x560107caf929 <handle_one_connection(void*)> pfs = 0x7fd294bd06c0 klass = 0x56010b93ec00 #30 0x00007fd296da5ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477 ret = <optimized out> pd = <optimized out> unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140542344873728, -6042312553587541252, 140724509942974, 140724509942975, 140542344871552, 311296, 6016885705157376764, 6016889410557967100}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = 0 #31 0x00007fd2969a2def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
            igor Igor Babaev added a comment -

            Closed as it duplicates MDEV-26412 that has been already fixed.

            igor Igor Babaev added a comment - Closed as it duplicates MDEV-26412 that has been already fixed.
            igor Igor Babaev added a comment -

            elenst,
            Please create a new bug report for your test case. Your test case reproduces a bug that is similar to MDEV-26412, but needs a separate fix. And the bug of your test case has nothing to do with the bug MDEV-25206.

            igor Igor Babaev added a comment - elenst , Please create a new bug report for your test case. Your test case reproduces a bug that is similar to MDEV-26412 , but needs a separate fix. And the bug of your test case has nothing to do with the bug MDEV-25206 .
            elenst Elena Stepanova added a comment - Done: MDEV-29088

            People

              igor Igor Babaev
              ebyrob Robert Eby
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.