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

Assertion `templ->mysql_col_len == len' failed in row_sel_field_store_in_mysql_format_func

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11
    • 10.5, 10.6, 10.11
    • None

    Description

      --source include/have_innodb.inc
       
       CREATE TABLE t1 ( 
      	id int, 
      	dt1 date, 
      	i1 int,
      	v_i1 int GENERATED ALWAYS AS (i1), 
      	PRIMARY KEY (id,i1),
      	KEY i1 (i1),
      	KEY v_i1 (v_i1)
      ) ENGINE=InnoDB;
       
      INSERT INTO t1(dt1, i1, id) VALUES  
      ('1994-04-27',3,1),('1939-03-07',8,2),('2035-04-15',195,3),('1936-02-07',8,4),('1912-08-14',9,5);
       
      SELECT dt1 FROM t1 WHERE i1 IN (1,2,3) AND (i1 NOT IN (0)) AND (v_i1 <= 0);
      

      10.5 e0d61cb41c809169b58843765ba1

      Version: '10.5.10-MariaDB-debug-log' 
      mariadbd: /10.5/storage/innobase/row/row0sel.cc:2846: void row_sel_field_store_in_mysql_format_func(byte*, const mysql_row_templ_t*, const dict_index_t*, ulint, const byte*, ulint): Assertion `templ->mysql_col_len == len' failed.
      210505 12:57:05 [ERROR] mysqld got signal 6 ;
       
      linux/raise.c:51(__GI_raise)[0x7f7ea79f87bb]
      stdlib/abort.c:81(__GI_abort)[0x7f7ea79e3535]
      intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f7ea79e340f]
      ??:0(__assert_fail)[0x7f7ea79f1102]
      row/row0sel.cc:2848(row_sel_field_store_in_mysql_format_func(unsigned char*, mysql_row_templ_t const*, dict_index_t const*, unsigned long, unsigned char const*, unsigned long))[0x5654c1ab8538]
      row/row0sel.cc:3001(row_sel_store_mysql_field(unsigned char*, row_prebuilt_t*, unsigned char const*, dict_index_t const*, unsigned short const*, unsigned long, mysql_row_templ_t const*))[0x5654c1ab98a8]
      row/row0sel.cc:3965(row_search_idx_cond_check(unsigned char*, row_prebuilt_t*, unsigned char const*, unsigned short const*))[0x5654c1abf0be]
      row/row0sel.cc:5281(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long))[0x5654c1ac8678]
      handler/ha_innodb.cc:8854(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function))[0x5654c16a12fe]
      sql/handler.h:3809(handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x5654c0bd6001]
      sql/handler.cc:3123(handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x5654c0ba6bf5]
      sql/handler.cc:6200(handler::read_range_first(st_key_range const*, st_key_range const*, bool, bool))[0x5654c0bc1454]
      sql/multi_range_read.cc:516(handler::multi_range_read_next(void**))[0x5654c08a9484]
      sql/multi_range_read.cc:553(Mrr_simple_index_reader::get_next(void**))[0x5654c08a9858]
      sql/multi_range_read.cc:1653(DsMrr_impl::dsmrr_next(void**))[0x5654c08b3237]
      handler/ha_innodb.cc:20409(ha_innobase::multi_range_read_next(void**))[0x5654c16d370c]
      sql/opt_range.cc:12647(QUICK_RANGE_SELECT::get_next())[0x5654c0fb3f8d]
      sql/records.cc:403(rr_quick(READ_RECORD*))[0x5654c0fe8107]
      sql/records.h:80(READ_RECORD::read_record())[0x5654c01fbf5a]
      sql/sql_select.cc:21766(join_init_read_record(st_join_table*))[0x5654c04ff80f]
      sql/sql_select.cc:20818(sub_select(JOIN*, st_join_table*, bool))[0x5654c04f8af7]
      sql/sql_select.cc:20355(do_select(JOIN*, Procedure*))[0x5654c04f6e52]
      sql/sql_select.cc:4503(JOIN::exec_inner())[0x5654c04843ae]
      sql/sql_select.cc:4284(JOIN::exec())[0x5654c04819fc]
      sql/sql_select.cc:4761(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5654c0485c9d]
      sql/sql_select.cc:443(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5654c0457ae3]
      sql/sql_parse.cc:6313(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5654c03c45d6]
      sql/sql_parse.cc:4009(mysql_execute_command(THD*))[0x5654c03b3585]
      sql/sql_parse.cc:8099(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5654c03cf460]
      sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5654c03a58d9]
      sql/sql_parse.cc:1370(do_command(THD*))[0x5654c03a21e5]
      sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x5654c07d4b66]
      sql/sql_connect.cc:1314(handle_one_connection)[0x5654c07d44c3]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5654c14a2e46]
      nptl/pthread_create.c:487(start_thread)[0x7f7ea7eb1fa3]
      x86_64/clone.S:97(clone)[0x7f7ea7aba4cf]
       
      Query (0x62b0000a12a8): SELECT dt1 FROM t1 WHERE i1 IN (1,2,3) AND (i1 NOT IN (0)) AND (v_i1 <= 0)
      

      no visible effect on non-debug build

      Attachments

        Issue Links

          Activity

            People

              nikitamalyavin Nikita Malyavin
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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