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

Assertion `table_list->table' failed in find_field_in_table_ref

Details

    Description

      CREATE TABLE t1 (f INT);
      		 
      INSERT INTO t1 VALUES (1),(2); # Optional
      		 
       
      		 
      CREATE ALGORITHM = MERGE VIEW v1 AS SELECT * FROM t1;
      		 
      CREATE ALGORITHM = TEMPTABLE VIEW v2 AS SELECT * FROM t1;
      		 
       
      		 
      PREPARE ps FROM 'SELECT * FROM v1 RIGHT JOIN v2 ON v1.f = v2.f';
      		 
      EXECUTE ps;
      		 
      EXECUTE ps;
      		 
       
      		 
      # Cleanup
      		 
      DROP VIEW v1, v2;
      		 
      DROP TABLE t1;

      10.3 b8c92d752c34

      		 
      mysqld: /data/src/10.3/sql/sql_base.cc:5793: Field* find_field_in_table_ref(THD*, TABLE_LIST*, const char*, uint, const char*, const char*, const char*, Item**, bool, bool, uint*, bool, TABLE_LIST**): Assertion `table_list->table' failed.
      		 
      180128 17:47:21 [ERROR] mysqld got signal 6 ;
      		 
       
      		 
      #7  0x00007f71d4458ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      		 
      #8  0x0000564496136194 in find_field_in_table_ref (thd=0x7f71bc000b00, table_list=0x7f71bc076960, name=0x7f71bc077128 "f", length=1, item_name=0x7f71bc077128 "f", db_name=0x0, table_name=0x0, ref=0x7f71bc0772d0, check_privileges=true, allow_rowid=true, cached_field_index_ptr=0x7f71bc077204, register_tree_change=true, actual_table=0x7f71ce6c39e8) at /data/src/10.3/sql/sql_base.cc:5793
      		 
      #9  0x00005644961369ff in find_field_in_tables (thd=0x7f71bc000b00, item=0x7f71bc077130, first_table=0x7f71bc0762e0, last_table=0x7f71bc076960, ref=0x7f71bc0772d0, report_error=IGNORE_EXCEPT_NON_UNIQUE, check_privileges=true, register_tree_change=true) at /data/src/10.3/sql/sql_base.cc:6024
      		 
      #10 0x00005644964c1e0f in Item_field::fix_fields (this=0x7f71bc077130, thd=0x7f71bc000b00, reference=0x7f71bc0772d0) at /data/src/10.3/sql/item.cc:6074
      		 
      #11 0x0000564496516597 in Item_func::fix_fields (this=0x7f71bc077238, thd=0x7f71bc000b00, ref=0x7f71bc076320) at /data/src/10.3/sql/item_func.cc:361
      		 
      #12 0x000056449613b9ec in setup_on_expr (thd=0x7f71bc000b00, table=0x7f71bc0794b0, is_update=false) at /data/src/10.3/sql/sql_base.cc:7922
      		 
      #13 0x000056449613bf32 in setup_conds (thd=0x7f71bc000b00, tables=0x7f71bc0794b0, leaves=..., conds=0x7f71bc0158a8) at /data/src/10.3/sql/sql_base.cc:8040
      		 
      #14 0x00005644961f22f8 in setup_without_group (thd=0x7f71bc000b00, ref_pointer_array=..., tables=0x7f71bc0794b0, leaves=..., fields=..., all_fields=..., conds=0x7f71bc0158a8, order=0x0, group=0x0, win_specs=..., win_funcs=..., hidden_group_fields=0x7f71bc015787, reserved=0x7f71bc07868c) at /data/src/10.3/sql/sql_select.cc:643
      		 
      #15 0x00005644961f4b8d in JOIN::prepare (this=0x7f71bc0154a0, tables_init=0x7f71bc0794b0, 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=0x7f71bc0783b8, unit_arg=0x7f71bc077c60) at /data/src/10.3/sql/sql_select.cc:1217
      		 
      #16 0x00005644962a255b in st_select_lex_unit::prepare_join (this=0x7f71bc077c60, thd_arg=0x7f71bc000b00, sl=0x7f71bc0783b8, tmp_result=0x7f71bc0153b8, additional_options=0, is_union_select=false) at /data/src/10.3/sql/sql_union.cc:675
      		 
      #17 0x00005644962a3912 in st_select_lex_unit::prepare (this=0x7f71bc077c60, thd_arg=0x7f71bc000b00, sel_result=0x7f71bc0153b8, additional_options=0) at /data/src/10.3/sql/sql_union.cc:947
      		 
      #18 0x0000564496173e87 in mysql_derived_prepare (thd=0x7f71bc000b00, lex=0x7f71bc0749a0, derived=0x7f71bc0762e0) at /data/src/10.3/sql/sql_derived.cc:755
      		 
      #19 0x0000564496172c6b in mysql_handle_single_derived (lex=0x7f71bc0749a0, derived=0x7f71bc0762e0, phases=2) at /data/src/10.3/sql/sql_derived.cc:197
      		 
      #20 0x00005644962d02e8 in TABLE_LIST::handle_derived (this=0x7f71bc0762e0, lex=0x7f71bc0749a0, phases=2) at /data/src/10.3/sql/table.cc:8077
      		 
      #21 0x0000564496195c84 in st_select_lex::handle_derived (this=0x7f71bc0751c0, lex=0x7f71bc0749a0, phases=2) at /data/src/10.3/sql/sql_lex.cc:4036
      		 
      #22 0x00005644961f44dd in JOIN::prepare (this=0x7f71bc014e50, tables_init=0x7f71bc0762e0, 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=0x7f71bc0751c0, unit_arg=0x7f71bc074a68) at /data/src/10.3/sql/sql_select.cc:1106
      		 
      #23 0x00005644961ff8f9 in mysql_select (thd=0x7f71bc000b00, tables=0x7f71bc0762e0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7f71bc077a88, unit=0x7f71bc074a68, select_lex=0x7f71bc0751c0) at /data/src/10.3/sql/sql_select.cc:4236
      		 
      #24 0x00005644961f18fc in handle_select (thd=0x7f71bc000b00, lex=0x7f71bc0749a0, result=0x7f71bc077a88, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:379
      		 
      #25 0x00005644961bc6fc in execute_sqlcom_select (thd=0x7f71bc000b00, all_tables=0x7f71bc0762e0) at /data/src/10.3/sql/sql_parse.cc:6530
      		 
      #26 0x00005644961b2de6 in mysql_execute_command (thd=0x7f71bc000b00) at /data/src/10.3/sql/sql_parse.cc:3751
      		 
      #27 0x00005644961dde0f in Prepared_statement::execute (this=0x7f71bc06f410, expanded_query=0x7f71ce6c6410, open_cursor=false) at /data/src/10.3/sql/sql_prepare.cc:4736
      		 
      #28 0x00005644961dc212 in Prepared_statement::execute_loop (this=0x7f71bc06f410, expanded_query=0x7f71ce6c6410, open_cursor=false, packet=0x0, packet_end=0x0) at /data/src/10.3/sql/sql_prepare.cc:4165
      		 
      #29 0x00005644961d9e06 in mysql_sql_stmt_execute (thd=0x7f71bc000b00) at /data/src/10.3/sql/sql_prepare.cc:3271
      		 
      #30 0x00005644961b2e2b in mysql_execute_command (thd=0x7f71bc000b00) at /data/src/10.3/sql/sql_parse.cc:3767
      		 
      #31 0x00005644961c0050 in mysql_parse (thd=0x7f71bc000b00, rawbuf=0x7f71bc014c38 "EXECUTE ps", length=10, parser_state=0x7f71ce6c75f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7987
      		 
      #32 0x00005644961ad87f in dispatch_command (command=COM_QUERY, thd=0x7f71bc000b00, packet=0x7f71bc00b141 "EXECUTE ps", packet_length=10, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1826
      		 
      #33 0x00005644961ac2b3 in do_command (thd=0x7f71bc000b00) at /data/src/10.3/sql/sql_parse.cc:1370
      		 
      #34 0x00005644963137e8 in do_handle_one_connection (connect=0x564498a15e80) at /data/src/10.3/sql/sql_connect.cc:1401
      		 
      #35 0x0000564496313575 in handle_one_connection (arg=0x564498a15e80) at /data/src/10.3/sql/sql_connect.cc:1307
      		 
      #36 0x00005644967b11b4 in pfs_spawn_thread (arg=0x564498a31660) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      		 
      #37 0x00007f71d612f494 in start_thread (arg=0x7f71ce6c8700) at pthread_create.c:333
      		 
      #38 0x00007f71d451593f in clone () from /lib/x86_64-linux-gnu/libc.so.6

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          elenst Elena Stepanova created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Component/s Prepared Statements [ 10804 ]
          Component/s Views [ 10111 ]
          Fix Version/s 10.3 [ 22126 ]
          Description https://api.travis-ci.org/v3/job/330429278/log.txt
          {noformat:title=10.3 e15f4af4dc5105c99368ea02b7c45ec3068a996a}
          mysqld: /home/travis/src/sql/sql_base.cc:5793: Field* find_field_in_table_ref(THD*, TABLE_LIST*, const char*, uint, const char*, const char*, const char*, Item**, bool, bool, uint*, bool, TABLE_LIST**): Assertion `table_list->table' failed.
          180119 12:46:40 [ERROR] mysqld got signal 6 ;

          Query (0x7f0314013b40): SELECT a2.field1 AS field1, a2.field2 AS field2, a2.field3 AS field3, a2.field4 AS field4 FROM view5 AS a1 RIGHT JOIN view3 AS a2 ON a1.field2 <=> a2.field4 WHERE a2.field1 <= NULL AND a2.field1 != 'sin' /* QNO 5950 CON_ID 17 */
          Connection ID (thread ID): 17
          Status: NOT_KILLED
          {noformat}
          {noformat}
          #7 0x00007f036abb6ec2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
          #8 0x0000000000730a7c in find_field_in_table_ref (thd=0x7f0314000c00, table_list=0x7f0314274d90, name=0x7f0314272ca0 "field4", length=6, item_name=0x7f0314272df0 "field4", db_name=0x0, table_name=0x7f0314272c80 "select1", ref=0x7f0314275a08, check_privileges=true, allow_rowid=true, cached_field_index_ptr=0x7f0314272d8c, register_tree_change=true, actual_table=0x7f03682f7e50) at /home/travis/src/sql/sql_base.cc:5793
          #9 0x0000000000731627 in find_field_in_tables (thd=0x7f0314000c00, item=0x7f0314272cb8, first_table=0x7f0314274d90, last_table=0x0, ref=0x7f0314275a08, report_error=IGNORE_EXCEPT_NON_UNIQUE, check_privileges=true, register_tree_change=true) at /home/travis/src/sql/sql_base.cc:6095
          #10 0x0000000000ac2210 in Item_field::fix_fields (this=0x7f0314272cb8, thd=0x7f0314000c00, reference=0x7f0314275a08) at /home/travis/src/sql/item.cc:6074
          #11 0x00000000008c2c73 in create_view_field (thd=0x7f0314000c00, view=0x7f03140ef100, field_ref=0x7f0314275a08, name=0x7f0314275a10) at /home/travis/src/sql/table.cc:5923
          #12 0x00000000008c2b31 in Field_iterator_view::create_item (this=0x7f03682f8360, thd=0x7f0314000c00) at /home/travis/src/sql/table.cc:5898
          #13 0x000000000072fad8 in find_field_in_view (thd=0x7f0314000c00, table_list=0x7f03140ef100, name=0x7f03140ef8c8 "field4", length=6, item_name=0x7f03140ef8c8 "field4", ref=0x7f03140efa70, register_tree_change=true) at /home/travis/src/sql/sql_base.cc:5439
          #14 0x00000000007309f4 in find_field_in_table_ref (thd=0x7f0314000c00, table_list=0x7f03140ef100, name=0x7f03140ef8c8 "field4", length=6, item_name=0x7f03140ef8c8 "field4", db_name=0x0, table_name=0x0, ref=0x7f03140efa70, check_privileges=true, allow_rowid=true, cached_field_index_ptr=0x7f03140ef9a4, register_tree_change=true, actual_table=0x7f03682f8570) at /home/travis/src/sql/sql_base.cc:5786
          #15 0x00000000007312f3 in find_field_in_tables (thd=0x7f0314000c00, item=0x7f03140ef8d0, first_table=0x7f03140eea70, last_table=0x7f03140ef100, ref=0x7f03140efa70, report_error=IGNORE_EXCEPT_NON_UNIQUE, check_privileges=true, register_tree_change=true) at /home/travis/src/sql/sql_base.cc:6024
          #16 0x0000000000ac2210 in Item_field::fix_fields (this=0x7f03140ef8d0, thd=0x7f0314000c00, reference=0x7f03140efa70) at /home/travis/src/sql/item.cc:6074
          #17 0x0000000000b16b14 in Item_func::fix_fields (this=0x7f03140ef9d8, thd=0x7f0314000c00, ref=0x7f0314014130) at /home/travis/src/sql/item_func.cc:361
          #18 0x0000000000ae771d in Item_cond::fix_fields (this=0x7f0314014018, thd=0x7f0314000c00, ref=0x7f03140eeab0) at /home/travis/src/sql/item_cmpfunc.cc:4606
          #19 0x000000000073606e in setup_on_expr (thd=0x7f0314000c00, table=0x7f031426ef10, is_update=false) at /home/travis/src/sql/sql_base.cc:7922
          #20 0x00000000007365c8 in setup_conds (thd=0x7f0314000c00, tables=0x7f031426e8c8, leaves=..., conds=0x7f0314014db8) at /home/travis/src/sql/sql_base.cc:8040
          #21 0x00000000007ec9a6 in setup_without_group (thd=0x7f0314000c00, ref_pointer_array=..., tables=0x7f031426e8c8, leaves=..., fields=..., all_fields=..., conds=0x7f0314014db8, order=0x0, group=0x0, win_specs=..., win_funcs=..., hidden_group_fields=0x7f0314014c97, reserved=0x7f03140f17ac) at /home/travis/src/sql/sql_select.cc:643
          #22 0x00000000007ef296 in JOIN::prepare (this=0x7f03140149b0, tables_init=0x7f031426e8c8, 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=0x7f03140f14d8, unit_arg=0x7f03140f0d80) at /home/travis/src/sql/sql_select.cc:1217
          #23 0x000000000089acee in st_select_lex_unit::prepare_join (this=0x7f03140f0d80, thd_arg=0x7f0314000c00, sl=0x7f03140f14d8, tmp_result=0x7f03140148c8, additional_options=0, is_union_select=false) at /home/travis/src/sql/sql_union.cc:675
          #24 0x000000000089c018 in st_select_lex_unit::prepare (this=0x7f03140f0d80, thd_arg=0x7f0314000c00, sel_result=0x7f03140148c8, additional_options=0) at /home/travis/src/sql/sql_union.cc:947
          #25 0x000000000076e270 in mysql_derived_prepare (thd=0x7f0314000c00, lex=0x7f03140ecbe8, derived=0x7f03140eea70) at /home/travis/src/sql/sql_derived.cc:755
          #26 0x000000000076d027 in mysql_handle_single_derived (lex=0x7f03140ecbe8, derived=0x7f03140eea70, phases=2) at /home/travis/src/sql/sql_derived.cc:197
          #27 0x00000000008c8469 in TABLE_LIST::handle_derived (this=0x7f03140eea70, lex=0x7f03140ecbe8, phases=2) at /home/travis/src/sql/table.cc:8077
          #28 0x00000000007900d2 in st_select_lex::handle_derived (this=0x7f03140ed408, lex=0x7f03140ecbe8, phases=2) at /home/travis/src/sql/sql_lex.cc:4036
          #29 0x00000000007eebb6 in JOIN::prepare (this=0x7f0314014360, tables_init=0x7f03140eea70, wild_num=0, conds_init=0x7f0314013c88, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f03140ed408, unit_arg=0x7f03140eccb0) at /home/travis/src/sql/sql_select.cc:1106
          #30 0x00000000007f9e6c in mysql_select (thd=0x7f0314000c00, tables=0x7f03140eea70, wild_num=0, fields=..., conds=0x7f0314013c88, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=552171997952, result=0x7f03140f0968, unit=0x7f03140eccb0, select_lex=0x7f03140ed408) at /home/travis/src/sql/sql_select.cc:4228
          #31 0x00000000007ebfc0 in handle_select (thd=0x7f0314000c00, lex=0x7f03140ecbe8, result=0x7f03140f0968, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:379
          #32 0x00000000007b7251 in execute_sqlcom_select (thd=0x7f0314000c00, all_tables=0x7f03140eea70) at /home/travis/src/sql/sql_parse.cc:6524
          #33 0x00000000007ad71d in mysql_execute_command (thd=0x7f0314000c00) at /home/travis/src/sql/sql_parse.cc:3745
          #34 0x00000000007d865f in Prepared_statement::execute (this=0x7f03141c0170, expanded_query=0x7f03682fb260, open_cursor=false) at /home/travis/src/sql/sql_prepare.cc:4675
          #35 0x00000000007d6adf in Prepared_statement::execute_loop (this=0x7f03141c0170, expanded_query=0x7f03682fb260, open_cursor=false, packet=0x0, packet_end=0x0) at /home/travis/src/sql/sql_prepare.cc:4104
          #36 0x00000000007d47d1 in mysql_sql_stmt_execute (thd=0x7f0314000c00) at /home/travis/src/sql/sql_prepare.cc:3211
          #37 0x00000000007ad762 in mysql_execute_command (thd=0x7f0314000c00) at /home/travis/src/sql/sql_parse.cc:3761
          #38 0x00000000007babb5 in mysql_parse (thd=0x7f0314000c00, rawbuf=0x7f0314013a08 "EXECUTE prep_stmt_25590 /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 6006 CON_ID 17 */", length=88, parser_state=0x7f03682fc470, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7981
          #39 0x00000000007a8160 in dispatch_command (command=COM_QUERY, thd=0x7f0314000c00, packet=0x7f031409e6c1 "EXECUTE prep_stmt_25590 /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 6006 CON_ID 17 */ ", packet_length=89, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1826
          #40 0x00000000007a6b87 in do_command (thd=0x7f0314000c00) at /home/travis/src/sql/sql_parse.cc:1370
          #41 0x000000000090c38e in do_handle_one_connection (connect=0x4339190) at /home/travis/src/sql/sql_connect.cc:1401
          #42 0x000000000090c110 in handle_one_connection (arg=0x4339190) at /home/travis/src/sql/sql_connect.cc:1307
          #43 0x00007f036b762e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
          #44 0x00007f036ac7e2ed in clone () from /lib/x86_64-linux-gnu/libc.so.6
          #45 0x0000000000000000 in ?? ()
          {noformat}

          {noformat:title=experimental 638904a88953d7295e50a745df9d351be59d0d9a}
          perl /home/travis/rqg/runall-new.pl --duration=400 --threads=6 --seed=1516365973 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,InlineVirtualColumns,LimitRowsExamined,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/sequences.yy --basedir=/home/travis/server --grammar=conf/optimizer/updateable_views.yy --mysqld=--init-file=$RQG_HOME/conf/optimizer/updateable_views.init --engine=MyISAM --mysqld=--default-storage-engine=MyISAM --vardir=/home/travis/logs/vardir1_3
          {noformat}
          		{code:sql}
          CREATE TABLE t1 (f INT);
          INSERT INTO t1 VALUES (1),(2); # Optional

          CREATE ALGORITHM = MERGE VIEW v1 AS SELECT * FROM t1;
          CREATE ALGORITHM = TEMPTABLE VIEW v2 AS SELECT * FROM t1;

          PREPARE ps FROM 'SELECT * FROM v1 RIGHT JOIN v2 ON v1.f = v2.f';
          EXECUTE ps;
          EXECUTE ps;

          # Cleanup
          DROP VIEW v1, v2;
          DROP TABLE t1;
          {code}

          {noformat:title=10.3 b8c92d752c34}
          mysqld: /data/src/10.3/sql/sql_base.cc:5793: Field* find_field_in_table_ref(THD*, TABLE_LIST*, const char*, uint, const char*, const char*, const char*, Item**, bool, bool, uint*, bool, TABLE_LIST**): Assertion `table_list->table' failed.
          180128 17:47:21 [ERROR] mysqld got signal 6 ;

          #7 0x00007f71d4458ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
          #8 0x0000564496136194 in find_field_in_table_ref (thd=0x7f71bc000b00, table_list=0x7f71bc076960, name=0x7f71bc077128 "f", length=1, item_name=0x7f71bc077128 "f", db_name=0x0, table_name=0x0, ref=0x7f71bc0772d0, check_privileges=true, allow_rowid=true, cached_field_index_ptr=0x7f71bc077204, register_tree_change=true, actual_table=0x7f71ce6c39e8) at /data/src/10.3/sql/sql_base.cc:5793
          #9 0x00005644961369ff in find_field_in_tables (thd=0x7f71bc000b00, item=0x7f71bc077130, first_table=0x7f71bc0762e0, last_table=0x7f71bc076960, ref=0x7f71bc0772d0, report_error=IGNORE_EXCEPT_NON_UNIQUE, check_privileges=true, register_tree_change=true) at /data/src/10.3/sql/sql_base.cc:6024
          #10 0x00005644964c1e0f in Item_field::fix_fields (this=0x7f71bc077130, thd=0x7f71bc000b00, reference=0x7f71bc0772d0) at /data/src/10.3/sql/item.cc:6074
          #11 0x0000564496516597 in Item_func::fix_fields (this=0x7f71bc077238, thd=0x7f71bc000b00, ref=0x7f71bc076320) at /data/src/10.3/sql/item_func.cc:361
          #12 0x000056449613b9ec in setup_on_expr (thd=0x7f71bc000b00, table=0x7f71bc0794b0, is_update=false) at /data/src/10.3/sql/sql_base.cc:7922
          #13 0x000056449613bf32 in setup_conds (thd=0x7f71bc000b00, tables=0x7f71bc0794b0, leaves=..., conds=0x7f71bc0158a8) at /data/src/10.3/sql/sql_base.cc:8040
          #14 0x00005644961f22f8 in setup_without_group (thd=0x7f71bc000b00, ref_pointer_array=..., tables=0x7f71bc0794b0, leaves=..., fields=..., all_fields=..., conds=0x7f71bc0158a8, order=0x0, group=0x0, win_specs=..., win_funcs=..., hidden_group_fields=0x7f71bc015787, reserved=0x7f71bc07868c) at /data/src/10.3/sql/sql_select.cc:643
          #15 0x00005644961f4b8d in JOIN::prepare (this=0x7f71bc0154a0, tables_init=0x7f71bc0794b0, 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=0x7f71bc0783b8, unit_arg=0x7f71bc077c60) at /data/src/10.3/sql/sql_select.cc:1217
          #16 0x00005644962a255b in st_select_lex_unit::prepare_join (this=0x7f71bc077c60, thd_arg=0x7f71bc000b00, sl=0x7f71bc0783b8, tmp_result=0x7f71bc0153b8, additional_options=0, is_union_select=false) at /data/src/10.3/sql/sql_union.cc:675
          #17 0x00005644962a3912 in st_select_lex_unit::prepare (this=0x7f71bc077c60, thd_arg=0x7f71bc000b00, sel_result=0x7f71bc0153b8, additional_options=0) at /data/src/10.3/sql/sql_union.cc:947
          #18 0x0000564496173e87 in mysql_derived_prepare (thd=0x7f71bc000b00, lex=0x7f71bc0749a0, derived=0x7f71bc0762e0) at /data/src/10.3/sql/sql_derived.cc:755
          #19 0x0000564496172c6b in mysql_handle_single_derived (lex=0x7f71bc0749a0, derived=0x7f71bc0762e0, phases=2) at /data/src/10.3/sql/sql_derived.cc:197
          #20 0x00005644962d02e8 in TABLE_LIST::handle_derived (this=0x7f71bc0762e0, lex=0x7f71bc0749a0, phases=2) at /data/src/10.3/sql/table.cc:8077
          #21 0x0000564496195c84 in st_select_lex::handle_derived (this=0x7f71bc0751c0, lex=0x7f71bc0749a0, phases=2) at /data/src/10.3/sql/sql_lex.cc:4036
          #22 0x00005644961f44dd in JOIN::prepare (this=0x7f71bc014e50, tables_init=0x7f71bc0762e0, 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=0x7f71bc0751c0, unit_arg=0x7f71bc074a68) at /data/src/10.3/sql/sql_select.cc:1106
          #23 0x00005644961ff8f9 in mysql_select (thd=0x7f71bc000b00, tables=0x7f71bc0762e0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7f71bc077a88, unit=0x7f71bc074a68, select_lex=0x7f71bc0751c0) at /data/src/10.3/sql/sql_select.cc:4236
          #24 0x00005644961f18fc in handle_select (thd=0x7f71bc000b00, lex=0x7f71bc0749a0, result=0x7f71bc077a88, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:379
          #25 0x00005644961bc6fc in execute_sqlcom_select (thd=0x7f71bc000b00, all_tables=0x7f71bc0762e0) at /data/src/10.3/sql/sql_parse.cc:6530
          #26 0x00005644961b2de6 in mysql_execute_command (thd=0x7f71bc000b00) at /data/src/10.3/sql/sql_parse.cc:3751
          #27 0x00005644961dde0f in Prepared_statement::execute (this=0x7f71bc06f410, expanded_query=0x7f71ce6c6410, open_cursor=false) at /data/src/10.3/sql/sql_prepare.cc:4736
          #28 0x00005644961dc212 in Prepared_statement::execute_loop (this=0x7f71bc06f410, expanded_query=0x7f71ce6c6410, open_cursor=false, packet=0x0, packet_end=0x0) at /data/src/10.3/sql/sql_prepare.cc:4165
          #29 0x00005644961d9e06 in mysql_sql_stmt_execute (thd=0x7f71bc000b00) at /data/src/10.3/sql/sql_prepare.cc:3271
          #30 0x00005644961b2e2b in mysql_execute_command (thd=0x7f71bc000b00) at /data/src/10.3/sql/sql_parse.cc:3767
          #31 0x00005644961c0050 in mysql_parse (thd=0x7f71bc000b00, rawbuf=0x7f71bc014c38 "EXECUTE ps", length=10, parser_state=0x7f71ce6c75f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7987
          #32 0x00005644961ad87f in dispatch_command (command=COM_QUERY, thd=0x7f71bc000b00, packet=0x7f71bc00b141 "EXECUTE ps", packet_length=10, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1826
          #33 0x00005644961ac2b3 in do_command (thd=0x7f71bc000b00) at /data/src/10.3/sql/sql_parse.cc:1370
          #34 0x00005644963137e8 in do_handle_one_connection (connect=0x564498a15e80) at /data/src/10.3/sql/sql_connect.cc:1401
          #35 0x0000564496313575 in handle_one_connection (arg=0x564498a15e80) at /data/src/10.3/sql/sql_connect.cc:1307
          #36 0x00005644967b11b4 in pfs_spawn_thread (arg=0x564498a31660) at /data/src/10.3/storage/perfschema/pfs.cc:1862
          #37 0x00007f71d612f494 in start_thread (arg=0x7f71ce6c8700) at pthread_create.c:333
          #38 0x00007f71d451593f in clone () from /lib/x86_64-linux-gnu/libc.so.6
          {noformat}
          Summary [Draft] Assertion `table_list->table' failed in find_field_in_table_ref Assertion `table_list->table' failed in find_field_in_table_ref
          elenst Elena Stepanova made changes -
          Attachment threads [ 44915 ]
          elenst Elena Stepanova made changes -
          Assignee Elena Stepanova [ elenst ] Oleksandr Byelkin [ sanja ]
          sanja Oleksandr Byelkin made changes -
          Sprint 10.2.13 [ 228 ]
          sanja Oleksandr Byelkin made changes -
          Sprint 10.2.13 [ 228 ]
          sanja Oleksandr Byelkin made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          sanja Oleksandr Byelkin made changes -
          Status In Progress [ 3 ] Stalled [ 10000 ]
          sanja Oleksandr Byelkin added a comment -

          It looks like fixed

          sanja Oleksandr Byelkin added a comment - It looks like fixed
          sanja Oleksandr Byelkin made changes -
          Fix Version/s 10.3.6 [ 23003 ]
          Fix Version/s 10.3 [ 22126 ]
          Resolution Cannot Reproduce [ 5 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 84957 ] MariaDB v4 [ 153601 ]

          People

            sanja Oleksandr Byelkin
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.