[MDEV-29088] Server crash upon CREATE VIEW with unknown column in ON condition Created: 2022-07-12  Updated: 2022-08-23  Resolved: 2022-08-23

Status: Closed
Project: MariaDB Server
Component/s: Views
Affects Version/s: 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10
Fix Version/s: 10.4.26, 10.5.17, 10.6.9, 10.7.5, 10.8.4, 10.9.2

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Igor Babaev
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-26214 INSERT from SELECT crashes server on ... Closed
relates to MDEV-26412 Server crash in Item_field::fix_outer... Closed

 Description   

Spawned from MDEV-26214 as instructed, because indeed, the fix for MDEV-26412 / MDEV-26214 is already in the main branches, but the test case below still fails.

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);

10.4 9a0cbd31

#2  0x0000562863bad5a1 in handle_fatal_signal (sig=11) at /data/src/10.4/sql/signal_handler.cc:366
        curr_time = 1657631306
        tm = {tm_sec = 26, tm_min = 8, tm_hour = 16, tm_mday = 12, tm_mon = 6, tm_year = 122, tm_wday = 2, tm_yday = 192, tm_isdst = 1, tm_gmtoff = 10800, tm_zone = 0x562867025930 "EEST"}
        thd = 0x7fcbfc000d90
        print_invalid_query_pointer = false
#3  <signal handler called>
No locals.
#4  0x0000562863bdeab6 in Item_field::fix_outer_field (this=0x7fcbfc016a08, thd=0x7fcbfc000d90, from_field=0x7fcc0c1e2c40, reference=0x7fcbfc016b20) 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 = 0x7fcbfc005518
        ref = 0x1
        current_sel = 0x7fcbfc016570
        outer_context = 0x7fcbfc005518
        select = 0x7fcbfc0054c8
        __PRETTY_FUNCTION__ = "int Item_field::fix_outer_field(THD*, Field**, Item**)"
#5  0x0000562863be0150 in Item_field::fix_fields (this=0x7fcbfc016a08, thd=0x7fcbfc000d90, reference=0x7fcbfc016b20) at /data/src/10.4/sql/item.cc:5984
        ret = 1669244287
        table_list = 0x56286500f3a0 <end_of_list>
        __PRETTY_FUNCTION__ = "virtual bool Item_field::fix_fields(THD*, Item**)"
        from_field = 0x1
        outer_fixed = false
        select = 0x7fcbfc016570
#6  0x0000562863760429 in Item::fix_fields_if_needed (this=0x7fcbfc016a08, thd=0x7fcbfc000d90, ref=0x7fcbfc016b20) at /data/src/10.4/sql/item.h:964
No locals.
#7  0x000056286376045f in Item::fix_fields_if_needed_for_scalar (this=0x7fcbfc016a08, thd=0x7fcbfc000d90, ref=0x7fcbfc016b20) at /data/src/10.4/sql/item.h:968
No locals.
#8  0x00005628637e02f0 in setup_fields (thd=0x7fcbfc000d90, ref_pointer_array={m_array = 0x7fcbfc0194e0, m_size = 3}, fields=@0x7fcbfc0166b8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fcbfc016b18, last = 0x7fcbfc016b18, elements = 1}, <No data fields>}, column_usage=MARK_COLUMNS_READ, sum_func_list=0x7fcbfc019290, pre_fix=0x7fcbfc0166d0, allow_sum_func=true) at /data/src/10.4/sql/sql_base.cc:7714
        item = 0x7fcbfc016a08
        saved_column_usage = MARK_COLUMNS_READ
        save_allow_sum_func = {buffer = {0}}
        it = {<base_list_iterator> = {list = 0x7fcbfc0166b8, el = 0x7fcbfc016b18, prev = 0x7fcbfc0166b8, current = 0x7fcbfc016b18}, <No data fields>}
        save_is_item_list_lookup = true
        make_pre_fix = true
        _db_stack_frame_ = {func = 0x562864579487 "JOIN::prepare", file = 0x562864578fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483661, line = -1, prev = 0x7fcc0c1e2ec0}
        __PRETTY_FUNCTION__ = "bool setup_fields(THD*, Ref_ptr_array, List<Item>&, enum_column_usage, List<Item>*, List<Item>*, bool)"
        li = {<base_list_iterator> = {list = 0x7fcbfc005c58, el = 0x56286500f3a0 <end_of_list>, prev = 0x7fcbfc005c58, current = 0x56286500f3a0 <end_of_list>}, <No data fields>}
        var = 0x0
        ref = {m_array = 0x7fcbfc0194e0, m_size = 3}
#9  0x00005628638c0f2a in JOIN::prepare (this=0x7fcbfc018f70, tables_init=0x0, 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=0x7fcbfc016570, unit_arg=0x7fcbfc016b38) at /data/src/10.4/sql/sql_select.cc:1278
        _db_stack_frame_ = {func = 0x56286472a99a "Item_in_subselect::fix_fields", file = 0x5628647292b8 "/data/src/10.4/sql/item_subselect.cc", level = 2147483660, line = -1, prev = 0x7fcc0c1e30c0}
        trace_wrapper = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x562864ce5510 <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 = 0x562864ce5510 <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 = 0x562864ce54f0 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
        tbl = 0x0
        li = {<base_list_iterator> = {list = 0x7fcbfc0167a8, el = 0x56286500f3a0 <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 = 0x562864474088 <my_thread_var_dbug+31>
        with_elem = 0x7fcbfc000cd0
        res = 216
#10 0x0000562863c9fc6d in subselect_single_select_engine::prepare (this=0x7fcbfc017568, thd=0x7fcbfc000d90) at /data/src/10.4/sql/item_subselect.cc:3845
        save_select = 0x7fcbfc014ff0
#11 0x0000562863c922f1 in Item_subselect::fix_fields (this=0x7fcbfc017340, thd_param=0x7fcbfc000d90, ref=0x7fcbfc015d60) at /data/src/10.4/sql/item_subselect.cc:289
        save_where = 0x56286472a952 "IN/ALL/ANY subquery"
        uncacheable = 0 '\000'
        res = false
        __PRETTY_FUNCTION__ = "virtual bool Item_subselect::fix_fields(THD*, Item**)"
#12 0x0000562863c9ebb6 in Item_in_subselect::fix_fields (this=0x7fcbfc017340, thd_arg=0x7fcbfc000d90, ref=0x7fcbfc015d60) at /data/src/10.4/sql/item_subselect.cc:3507
        outer_cols_num = 0
        inner_cols = 0x7fcc0c1e3320
        save_where = 0x562864554c11 "on clause"
        _db_stack_frame_ = {func = 0x562864554c1b "setup_conds", file = 0x562864552108 "/data/src/10.4/sql/sql_base.cc", level = 2147483659, line = -1, prev = 0x7fcc0c1e33d0}
        __PRETTY_FUNCTION__ = "virtual bool Item_in_subselect::fix_fields(THD*, Item**)"
#13 0x0000562863760429 in Item::fix_fields_if_needed (this=0x7fcbfc017340, thd=0x7fcbfc000d90, ref=0x7fcbfc015d60) at /data/src/10.4/sql/item.h:964
No locals.
#14 0x000056286376045f in Item::fix_fields_if_needed_for_scalar (this=0x7fcbfc017340, thd=0x7fcbfc000d90, ref=0x7fcbfc015d60) at /data/src/10.4/sql/item.h:968
No locals.
#15 0x00005628637e63af in Item::fix_fields_if_needed_for_bool (this=0x7fcbfc017340, thd=0x7fcbfc000d90, ref=0x7fcbfc015d60) at /data/src/10.4/sql/item.h:972
No locals.
#16 0x00005628637e23b2 in setup_on_expr (thd=0x7fcbfc000d90, table=0x7fcbfc015d00, is_update=false) at /data/src/10.4/sql/sql_base.cc:8332
        embedded = 0x7fcbfc015d00
        embedding = 0x7fcbfc015d00
        buff = " 2\036\f\314\177\000\000\306(\233c(V\000\000p|\001\374\000\000\000\000\350U\001\374\313\177\000\000\200\062\036\f\314\177\000\000\061*\233c\000\000\000\000\b\021\222d(V\000\000\000\000\000\000\000\000\000\000`2\036\f\314\177\000\000\\?Gd(V\000\000p2\036\f\314\177\000\000\\?Gd(V\000\000\200\062\036\f\314\177\000\000\210@Gd(V\000\000\220\062\036\f\314\177\000\000`\v\000\374\313\177\000\000\240\062\036\f\314\177\000\000\341\202Id(V\000\000\320\f\000\374\313\177\000\000\260\f\000\374\313\177\000\000\320\062\036\f\314\177\000\000\002\253Id(V\000\000W\021\222d(V\000\000\320\f\000\374\030\001\000\000\250u\001\374\313\177\000\000\000"...
#17 0x00005628637e2847 in setup_conds (thd=0x7fcbfc000d90, tables=0x7fcbfc0155e8, leaves=@0x7fcbfc015228: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fcbfc018d28, last = 0x7fcbfc018d38, elements = 2}, <No data fields>}, conds=0x7fcbfc018bc0) at /data/src/10.4/sql/sql_base.cc:8451
        select_lex = 0x7fcbfc014ff0
        table = 0x0
        it_is_update = false
        save_is_item_list_lookup = true
        derived = 0x0
        save_resolve_in_select_list = true
        _db_stack_frame_ = {func = 0x5628645791a1 "setup_without_group", file = 0x562864578fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483658, line = -1, prev = 0x7fcc0c1e3460}
#18 0x00005628638be213 in setup_without_group (thd=0x7fcbfc000d90, ref_pointer_array={m_array = 0x7fcbfc018e70, m_size = 6}, tables=0x7fcbfc0155e8, leaves=@0x7fcbfc015228: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fcbfc018d28, last = 0x7fcbfc018d38, elements = 2}, <No data fields>}, fields=@0x7fcbfc015138: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fcbfc015590, last = 0x7fcbfc015590, elements = 1}, <No data fields>}, all_fields=@0x7fcbfc018ad8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fcbfc015590, last = 0x7fcbfc015590, elements = 1}, <No data fields>}, conds=0x7fcbfc018bc0, order=0x0, group=0x0, win_specs=@0x7fcbfc015420: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x56286500f3a0 <end_of_list>, last = 0x7fcbfc015420, elements = 0}, <No data fields>}, win_funcs=@0x7fcbfc015438: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x56286500f3a0 <end_of_list>, last = 0x7fcbfc015438, elements = 0}, <No data fields>}, hidden_group_fields=0x7fcbfc018a9f, reserved=0x7fcbfc0152f4) at /data/src/10.4/sql/sql_select.cc:724
        res = 5
        save_place = NO_MATTER
        select = 0x7fcbfc014ff0
        save_allow_sum_func = {buffer = {0}}
        saved_non_agg_field_used = false
        _db_stack_frame_ = {func = 0x562864579487 "JOIN::prepare", file = 0x562864578fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483657, line = -1, prev = 0x7fcc0c1e3590}
#19 0x00005628638c1063 in JOIN::prepare (this=0x7fcbfc0187b8, tables_init=0x7fcbfc0155e8, 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=0x7fcbfc014ff0, unit_arg=0x7fcbfc004cc0) at /data/src/10.4/sql/sql_select.cc:1283
        _db_stack_frame_ = {func = 0x56286458f720 "st_select_lex_unit::prepare_join", file = 0x56286458f558 "/data/src/10.4/sql/sql_union.cc", level = 2147483656, line = -1, prev = 0x7fcc0c1e3710}
        trace_wrapper = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x562864ce5510 <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 = 0x562864ce5510 <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 = 0x562864ce54f0 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
        tbl = 0x0
        li = {<base_list_iterator> = {list = 0x7fcbfc015228, el = 0x56286500f3a0 <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 = 0x562864474088 <my_thread_var_dbug+31>
        with_elem = 0x7fcbfc000cd0
        res = 1
#20 0x0000562863985730 in st_select_lex_unit::prepare_join (this=0x7fcbfc004cc0, thd_arg=0x7fcbfc000d90, sl=0x7fcbfc014ff0, tmp_result=0x0, additional_options=0, is_union_select=false) at /data/src/10.4/sql/sql_union.cc:647
        _db_stack_frame_ = {func = 0x56286458f931 "st_select_lex_unit::prepare", file = 0x56286458f558 "/data/src/10.4/sql/sql_union.cc", level = 2147483655, line = -1, prev = 0x7fcc0c1e3830}
        derived = 0x0
        can_skip_order_by = false
        join = 0x7fcbfc0187b8
#21 0x0000562863986df8 in st_select_lex_unit::prepare (this=0x7fcbfc004cc0, derived_arg=0x0, sel_result=0x0, additional_options=0) at /data/src/10.4/sql/sql_union.cc:994
        lex_select_save = 0x7fcbfc014ff0
        sl = 0x7fcbfc014ff0
        first_sl = 0x7fcbfc014ff0
        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 = 0x5628645918fa "mysql_create_view", file = 0x562864591888 "/data/src/10.4/sql/sql_view.cc", level = 2147483654, line = -1, prev = 0x7fcc0c1e3990}
        __PRETTY_FUNCTION__ = "bool st_select_lex_unit::prepare(TABLE_LIST*, select_result*, ulong)"
#22 0x000056286399894d in mysql_create_view (thd=0x7fcbfc000d90, views=0x7fcbfc014920, mode=VIEW_CREATE_NEW) at /data/src/10.4/sql/sql_view.cc:539
        lex = 0x7fcbfc004c00
        link_to_local = true
        view = 0x7fcbfc014920
        tables = 0x7fcbfc0155e8
        tbl = 0x0
        select_lex = 0x7fcbfc014ff0
        sl = 0x7fcb00000000
        unit = 0x7fcbfc004cc0
        res = false
        _db_stack_frame_ = {func = 0x56286456c930 "mysql_execute_command", file = 0x56286456bcc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7fcc0c1e3c80}
        __PRETTY_FUNCTION__ = "bool mysql_create_view(THD*, TABLE_LIST*, enum_view_create_mode)"
#23 0x00005628638810d2 in mysql_execute_command (thd=0x7fcbfc000d90) at /data/src/10.4/sql/sql_parse.cc:6007
        res = 0
        up_result = 0
        lex = 0x7fcbfc004c00
        select_lex = 0x7fcbfc014ff0
        first_table = 0x7fcbfc014920
        all_tables = 0x7fcbfc014920
        unit = 0x7fcbfc004cc0
        have_table_map_for_update = false
        rpl_filter = 0x562863cd5d49 <inline_mysql_mutex_unlock(mysql_mutex_t*, char const*, uint)+107>
        _db_stack_frame_ = {func = 0x56286456dbb8 "mysql_parse", file = 0x56286456bcc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7fcc0c1e4250}
        __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)"
        ots = {ctx = 0x7fcbfc0048e0, traceable = false}
        trace_command = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x562864ce5510 <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 = 0x562864ce54f0 <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 0x0000562863886e72 in mysql_parse (thd=0x7fcbfc000d90, rawbuf=0x7fcbfc0147a8 "CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column)", length=89, parser_state=0x7fcc0c1e4410, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7995
        found_semicolon = 0x0
        error = 32715
        lex = 0x7fcbfc004c00
        err = false
        _db_stack_frame_ = {func = 0x56286456c13a "dispatch_command", file = 0x56286456bcc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7fcc0c1e43f0}
        __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*, bool, bool)"
#25 0x0000562863873312 in dispatch_command (command=COM_QUERY, thd=0x7fcbfc000d90, packet=0x7fcbfc00ac01 "CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column)", packet_length=89, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857
        packet_end = 0x7fcbfc014801 ""
        parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7fcbfc000d90, m_ptr = 0x7fcbfc014802 "\004", m_tok_start = 0x7fcbfc014802 "\004", m_tok_end = 0x7fcbfc014802 "\004", m_end_of_query = 0x7fcbfc014801 "", m_tok_start_prev = 0x7fcbfc014801 "", m_buf = 0x7fcbfc0147a8 "CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column)", m_buf_length = 89, m_echo = true, m_echo_saved = 12, m_cpp_buf = 0x7fcbfc014858 "CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column)", m_cpp_ptr = 0x7fcbfc0148b1 "", m_cpp_tok_start = 0x7fcbfc0148b1 "", m_cpp_tok_start_prev = 0x7fcbfc0148b1 "", m_cpp_tok_end = 0x7fcbfc0148b1 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x56286449b6d3 <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 = (unknown: 0x5628), m_cpp_text_start = 0x7fcbfc0148a2 "unknown_column)", m_cpp_text_end = 0x7fcbfc0148b0 ")", 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 = 0x7fcbfc0046e0}
        net = 0x7fcbfc0010b8
        error = false
        do_end_of_statement = true
        _db_stack_frame_ = {func = 0x56286456bec5 "do_command", file = 0x56286456bcc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7fcc0c1e4cb0}
        drop_more_results = false
        __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint, bool, bool)"
        __FUNCTION__ = "dispatch_command"
        res = <optimized out>
#26 0x0000562863871bc5 in do_command (thd=0x7fcbfc000d90) at /data/src/10.4/sql/sql_parse.cc:1378
        return_value = false
        packet = 0x7fcbfc00ac00 "\003CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column)"
        packet_length = 90
        net = 0x7fcbfc0010b8
        command = COM_QUERY
        _db_stack_frame_ = {func = 0x562864927368 "?func", file = 0x56286492736e "?file", level = 2147483649, line = -1, prev = 0x0}
        __PRETTY_FUNCTION__ = "bool do_command(THD*)"
        __FUNCTION__ = "do_command"
#27 0x0000562863a00cb1 in do_handle_one_connection (connect=0x56286731e460) at /data/src/10.4/sql/sql_connect.cc:1420
        create_user = true
        thr_create_utime = 4053418466516
        thd = 0x7fcbfc000d90
        __PRETTY_FUNCTION__ = "void do_handle_one_connection(CONNECT*)"
#28 0x0000562863a00959 in handle_one_connection (arg=0x56286731e460) at /data/src/10.4/sql/sql_connect.cc:1316
        connect = 0x56286731e460
#29 0x0000562863f1dc69 in pfs_spawn_thread (arg=0x562867395e60) at /data/src/10.4/storage/perfschema/pfs.cc:1869
        typed_arg = 0x562867395e60
        user_arg = 0x56286731e460
        user_start_routine = 0x562863a00929 <handle_one_connection(void*)>
        pfs = 0x7fcc105096c0
        klass = 0x56286703fc00
#30 0x00007fcc126deea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
        ret = <optimized out>
        pd = <optimized out>
        unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140514353370880, 4331299997716158390, 140725082441022, 140725082441023, 140514353368704, 311296, -4358421921159342154, -4358364322307532874}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
        not_first_call = 0
#31 0x00007fcc122dbdef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Reproducible on 10.4-10.10.
10.3 produces the expected ER_BAD_FIELD_ERROR:

10.3

mysqltest: At line 4: query 'CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column)' failed: 1054: Unknown column 'unknown_column' in 'field list'



 Comments   
Comment by Sergei Petrunia [ 2022-07-13 ]

Ok to push.

Generated at Thu Feb 08 10:05:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.