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

Assertion `table_list->table' failed in find_field_in_table_ref and Assertion `table_ref->table || table_ref->view' in Field_iterator_table_ref::set_field_iterator

    XMLWordPrintable

    Details

      Description

      --source include/have_partition.inc
      create table t1 (i int); 
      create table t2 (i int); 
       
      ALTER TABLE t1 PARTITION BY system_time 
          INTERVAL (SELECT i FROM t2) DAY (PARTITION p1 HISTORY, PARTITION pn CURRENT) ;
      

      10.3 592dc59d7a5f9bd80bffdd9d

       
      /10.3/sql/sql_base.cc:5955: Field* find_field_in_table_ref(THD*, TABLE_LIST*, const char*, size_t, const char*, const char*, const char*, Item**, bool, bool, uint*, bool, TABLE_LIST**): Assertion `table_list->table' failed.
       
      linux/raise.c:54(__GI_raise)[0x7f9e7674f428]
      stdlib/abort.c:91(__GI_abort)[0x7f9e7675102a]
      assert/assert.c:92(__assert_fail_base)[0x7f9e76747bd7]
      /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f9e76747c82]
      sql/sql_base.cc:5956(find_field_in_table_ref(THD*, TABLE_LIST*, char const*, unsigned long, char const*, char const*, char const*, Item**, bool, bool, unsigned int*, bool, TABLE_LIST**))[0x564e28719709]
      sql/sql_base.cc:6257(find_field_in_tables(THD*, Item_ident*, TABLE_LIST*, TABLE_LIST*, Item**, find_item_error_report_type, bool, bool))[0x564e2871af41]
      sql/item.cc:6053(Item_field::fix_fields(THD*, Item**))[0x564e28fa49ab]
      sql/item.h:825(Item::fix_fields_if_needed(THD*, Item**))[0x564e2862d15b]
      sql/item.h:828(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x564e2862d189]
      sql/sql_base.cc:7463(setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, enum_column_usage, List<Item>*, List<Item>*, bool))[0x564e2872146e]
      sql/sql_select.cc:1102(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x564e288e6e26]
      sql/item_subselect.cc:3676(subselect_single_select_engine::prepare(THD*))[0x564e2913d628]
      sql/item_subselect.cc:276(Item_subselect::fix_fields(THD*, Item**))[0x564e2911d633]
      sql/item.h:825(Item::fix_fields_if_needed(THD*, Item**))[0x564e2862d15b]
      sql/item.h:828(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x564e2862d189]
      sql/partition_info.h:404(partition_info::vers_set_interval(THD*, Item*, interval_type, long))[0x564e28de3599]
      sql/sql_yacc.yy:6067(MYSQLparse(THD*))[0x564e28d77cb5]
      sql/sql_parse.cc:10093(parse_sql(THD*, Parser_state*, Object_creation_ctx*, bool))[0x564e2887bc40]
      sql/sql_parse.cc:8051(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x564e2886f99c]
      sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x564e2884a90e]
      sql/sql_parse.cc:1404(do_command(THD*))[0x564e28847a72]
      sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x564e28b9db16]
      sql/sql_connect.cc:1309(handle_one_connection)[0x564e28b9d4f3]
      perfschema/pfs.cc:1864(pfs_spawn_thread)[0x564e29ec536d]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f9e7738c6ba]
      x86_64/clone.S:111(clone)[0x7f9e7682141d]
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x62b000000288): ALTER TABLE t1 PARTITION BY system_time  INTERVAL (SELECT i FROM t2) DAY (PARTITION p1 HISTORY, PARTITION pn CURRENT)
      
      

      non-debug build fails with sig 11

      201002 16:04:18 [ERROR] mysqld got signal 11 ;
       
      Server version: 10.5.5-MariaDB
       
      sql/sql_base.cc:5933(find_field_in_table(THD*, TABLE*, char const*, unsigned long, bool, unsigned int*))[0x5578c6e3d4ec]
      sql/sql_base.cc:6091(find_field_in_table_ref(THD*, TABLE_LIST*, char const*, unsigned long, char const*, char const*, char const*, Item**, bool, bool, unsigned int*, bool, TABLE_LIST**))[0x5578c6e3d90c]
      sql/sql_base.cc:6394(find_field_in_tables(THD*, Item_ident*, TABLE_LIST*, TABLE_LIST*, Item**, find_item_error_report_type, bool, bool))[0x5578c70c8ca7]
      sql/item.cc:5817(Item_field::fix_fields(THD*, Item**))[0x5578c6e3e099]
      sql/item.h:986(setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, enum_column_usage, List<Item>*, List<Item>*, bool))[0x5578c6ee6eea]
      sql/sql_select.cc:1250(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x5578c715b788]
      sql/item_subselect.cc:3775(subselect_single_select_engine::prepare(THD*))[0x5578c715aa95]
      sql/item_subselect.cc:285(Item_subselect::fix_fields(THD*, Item**))[0x5578c6f7bd98]
      sql/item.h:986(partition_info::vers_set_interval(THD*, Item*, interval_type, Item*, char const*))[0x5578c702a9b2]
      sql/sql_yacc.yy:5341(MYSQLparse(THD*))[0x5578c6ea530d]
      sql/sql_parse.cc:10352(parse_sql(THD*, Parser_state*, Object_creation_ctx*, bool))[0x5578c6ea5576]
      sql/sql_parse.cc:7949(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5578c6ea76d2]
      sql/sql_parse.cc:1927(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5578c6ea8b5b]
      sql/sql_parse.cc:1353(do_command(THD*))[0x5578c6f90b92]
      sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x5578c6f90e44]
      sql/sql_connect.cc:1318(handle_one_connection)[0x5578c730e02d]
      nptl/pthread_create.c:487(start_thread)[0x7f50bbc1afa3]
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f50bb7f44cf]
       
      Query (0x7f505c011c30): ALTER TABLE t1 PARTITION BY system_time      INTERVAL (SELECT i FROM t2) DAY (PARTITION p1 HISTORY, PARTITION pn CURRENT)
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              holyfoot Alexey Botchkov
              Reporter:
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.