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

LP:806071 - Assertion `table_list->table' failed in find_field_in_table_ref in maria-5.3 with views / WL#106

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      Not reproducible before WL#106. Not influenced by derived_merge and derived_with_keys flag. EXPLAIN also crashes.

      assertion:

      mysqld: sql_base.cc:6201: Field* find_field_in_table_ref(THD*, TABLE_LIST*, const char*, uint, const char*, const char*, const char*, Item**, bool, bool, uint

      #6 0x00000033b58296e6 in __assert_fail () from /lib64/libc.so.6
      #7 0x00000000006fd7bb in find_field_in_table_ref (thd=0x1cbc7068, table_list=0x1cc83e20, name=0x1cc82d50 "f1", length=2, item_name=0x1cc82d50 "f1",
      db_name=0x0, table_name=0x1cc82d40 "v1", ref=0x1cc84308, check_privileges=true, allow_rowid=true, cached_field_index_ptr=0x1cc842b4,
      register_tree_change=true, actual_table=0x41c63c48) at sql_base.cc:6201
      #8 0x00000000006fe141 in find_field_in_tables (thd=0x1cbc7068, item=0x1cc841f8, first_table=0x1cc83e20, last_table=0x0, ref=0x1cc84308,
      report_error=IGNORE_EXCEPT_NON_UNIQUE, check_privileges=true, register_tree_change=true) at sql_base.cc:6491
      #9 0x00000000005a6ac8 in Item_field::fix_fields (this=0x1cc841f8, thd=0x1cbc7068, reference=0x1cc84308) at item.cc:4558
      #10 0x00000000007284fc in find_order_in_list (thd=0x1cbc7068, ref_pointer_array=0x1cc86040, tables=0x1cc80dd0, order=0x1cc842f8, fields=..., all_fields=...,
      is_group_field=false) at sql_select.cc:18549
      #11 0x0000000000728c42 in setup_order (thd=0x1cbc7068, ref_pointer_array=0x1cc86040, tables=0x1cc80dd0, fields=..., all_fields=..., order=0x1cc842f8)
      at sql_select.cc:18645
      #12 0x0000000000757dda in setup_without_group (thd=0x1cbc7068, ref_pointer_array=0x1cc86040, tables=0x1cc80dd0, leaves=..., fields=..., all_fields=...,
      conds=0x1ccdf4f8, order=0x1cc4ec10, group=0x0, hidden_group_fields=0x1ccdf3ef) at sql_select.cc:458
      #13 0x000000000074d779 in JOIN::prepare (this=0x1ccd9440, rref_pointer_array=0x1cc4e038, tables_init=0x1cc80dd0, wild_num=0, conds_init=0x0, og_num=1,
      order_init=0x1cc4ec10, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x1cc4de18, unit_arg=0x1cc4d930) at sql_select.cc:572
      #14 0x000000000089d4fc in st_select_lex_unit::prepare (this=0x1cc4d930, thd_arg=0x1cbc7068, sel_result=0x1cc85f18, additional_options=0) at sql_union.cc:316
      #15 0x000000000089f053 in mysql_derived_prepare (thd=0x1cbc7068, lex=0x1cbc9470, derived=0x1cc4cec0) at sql_derived.cc:638
      #16 0x000000000089fc7c in mysql_handle_single_derived (lex=0x1cbc9470, derived=0x1cc4cec0, phases=2) at sql_derived.cc:171
      #17 0x000000000070ce2d in TABLE_LIST::handle_derived (this=0x1cc4cec0, lex=0x1cbc9470, phases=2) at table.cc:5766
      #18 0x000000000057a36f in st_select_lex::handle_derived (this=0x1cbc99f8, lex=0x1cbc9470, phases=2) at sql_lex.cc:3209
      #19 0x000000000074d35f in JOIN::prepare (this=0x1cc87d20, rref_pointer_array=0x1cbc9c18, tables_init=0x1cc4cec0, wild_num=1, conds_init=0x0, og_num=2,
      order_init=0x1cc4ec10, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x1cbc99f8, unit_arg=0x1cbc9510) at sql_select.cc:510
      #20 0x000000000074e7a0 in mysql_select (thd=0x1cbc7068, rref_pointer_array=0x1cbc9c18, tables=0x1cc4cec0, wild_num=1, fields=..., conds=0x0, og_num=2,
      order=0x1cc4ec10, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0x1cc84be0, unit=0x1cbc9510, select_lex=0x1cbc99f8)
      at sql_select.cc:2867
      #21 0x0000000000754c04 in handle_select (thd=0x1cbc7068, lex=0x1cbc9470, result=0x1cc84be0, setup_tables_done_option=0) at sql_select.cc:283
      #22 0x00000000006a19e0 in execute_sqlcom_select (thd=0x1cbc7068, all_tables=0x1cc4cec0) at sql_parse.cc:5087
      #23 0x00000000006a36be in mysql_execute_command (thd=0x1cbc7068) at sql_parse.cc:2231
      #24 0x00000000006ac457 in mysql_parse (thd=0x1cbc7068, rawbuf=0x1cc4ccb0 "SELECT * FROM v4 AS a1, v4 AS a2", length=33, found_semicolon=0x41c65f08)
      at sql_parse.cc:6088
      #25 0x00000000006ad2ef in dispatch_command (command=COM_QUERY, thd=0x1cbc7068, packet=0x1cc43939 "SELECT * FROM v4 AS a1, v4 AS a2", packet_length=33)
      at sql_parse.cc:1208
      #26 0x00000000006ae8fd in do_command (thd=0x1cbc7068) at sql_parse.cc:906
      #27 0x0000000000699373 in handle_one_connection (arg=0x1cbc7068) at sql_connect.cc:1178
      #28 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0
      #29 0x00000033b58d40cd in clone () from /lib64/libc.so.6

      optimizer switch:

      index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=off,loosescan=off,materialization=off,in_to_exists=on,semijoin=off,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=on,mrr_cost_based=off,mrr_sort_keys=on,outer_join_with_cache=off,semijoin_with_cache=off,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on

      test case:

      CREATE TABLE t1 (f1 int);
      INSERT INTO t1 VALUES (1),(1);

      CREATE ALGORITHM=TEMPTABLE VIEW v1 AS SELECT f1 FROM t1;
      CREATE ALGORITHM=MERGE VIEW v2 AS SELECT f1 FROM v1 ORDER BY f1;

      SELECT * FROM v2 AS a1, v2 AS a2;

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 806071

            Show
            ratzpo Rasmus Johansson added a comment - Launchpad bug id: 806071

              People

              • Assignee:
                sanja Oleksandr Byelkin
                Reporter:
                philipstoev Philip Stoev
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: