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

PARTITION BY LIST COLUMNS with default partition: Assertion `part_info->num_list_values' failed in get_part_iter_for_interval_cols_via_map

    XMLWordPrintable

Details

    Description

      CREATE TABLE t1 (f int) PARTITION BY LIST COLUMNS (f) (PARTITION pdef DEFAULT);
      insert into t1 values (1),(2);
      select * from t1 where f = 1;
      

      10.2 143d512a2202dbd320ec9b9e37dafc36fc2b36d8

      mysqld: /data/src/10.2/sql/sql_partition.cc:7709: int get_part_iter_for_interval_cols_via_map(partition_info*, bool, uint32*, uchar*, u
      char*, uint, uint, uint, PARTITION_ITERATOR*): Assertion `part_info->num_list_values' failed.
      161228 19:29:49 [ERROR] mysqld got signal 6 ;
       
      #5  0x00007f9fd95c3448 in __GI_abort () at abort.c:89
      #6  0x00007f9fd95bb266 in __assert_fail_base (fmt=0x7f9fd96f4238 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x7f9fdc17cc6a "part_info->num_list_values", file=file@entry=0x7f9fdc17bd40 "/data/src/10.2/sql/sql_partition.cc", line=line@entry=7709, function=function@entry=0x7f9fdc17dac0 <get_part_iter_for_interval_cols_via_map(partition_info*, bool, unsigned int*, unsigned char*, unsigned char*, unsigned int, unsigned int, unsigned int, st_partition_iter*)::__PRETTY_FUNCTION__> "int get_part_iter_for_interval_cols_via_map(partition_info*, bool, uint32*, uchar*, uchar*, uint, uint, uint, PARTITION_ITERATOR*)") at assert.c:92
      #7  0x00007f9fd95bb312 in __GI___assert_fail (assertion=0x7f9fdc17cc6a "part_info->num_list_values", file=0x7f9fdc17bd40 "/data/src/10.2/sql/sql_partition.cc", line=7709, function=0x7f9fdc17dac0 <get_part_iter_for_interval_cols_via_map(partition_info*, bool, unsigned int*, unsigned char*, unsigned char*, unsigned int, unsigned int, unsigned int, st_partition_iter*)::__PRETTY_FUNCTION__> "int get_part_iter_for_interval_cols_via_map(partition_info*, bool, uint32*, uchar*, uchar*, uint, uint, uint, PARTITION_ITERATOR*)") at assert.c:101
      #8  0x00007f9fdbaaf78b in get_part_iter_for_interval_cols_via_map (part_info=0x7f9fd060c088, is_subpart=<optimized out>, store_length_array=0x7f9fdc760f60, min_value=0x7f9fd05880c0 "", max_value=0x7f9fd05880c8 "", min_len=5, max_len=5, flags=0, part_iter=0x7f9fdc761548) at /data/src/10.2/sql/sql_partition.cc:7709
      #9  0x00007f9fdba5d6f4 in find_used_partitions (ppar=ppar@entry=0x7f9fdc761180, key_tree=0x7f9fd0588158) at /data/src/10.2/sql/opt_range.cc:4006
      #10 0x00007f9fdba5e715 in prune_partitions (thd=0x7f9fd0416070, table=table@entry=0x7f9fd04d5870, pprune_cond=0x7f9fd04653b0) at /data/src/10.2/sql/opt_range.cc:3514
      #11 0x00007f9fdb7ba478 in JOIN::optimize_inner (this=this@entry=0x7f9fd0464c88) at /data/src/10.2/sql/sql_select.cc:1369
      #12 0x00007f9fdb7bd6d3 in JOIN::optimize (this=this@entry=0x7f9fd0464c88) at /data/src/10.2/sql/sql_select.cc:1076
      #13 0x00007f9fdb7be079 in mysql_select (thd=thd@entry=0x7f9fd0416070, tables=0x7f9fd0464278, wild_num=1, fields=..., conds=0x7f9fd0464a30, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f9fd0464c68, unit=0x7f9fd0419b48, select_lex=0x7f9fd041a278) at /data/src/10.2/sql/sql_select.cc:3570
      #14 0x00007f9fdb7be331 in handle_select (thd=thd@entry=0x7f9fd0416070, lex=lex@entry=0x7f9fd0419a80, result=result@entry=0x7f9fd0464c68, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.2/sql/sql_select.cc:373
      #15 0x00007f9fdb74eb5d in execute_sqlcom_select (thd=thd@entry=0x7f9fd0416070, all_tables=0x7f9fd0464278) at /data/src/10.2/sql/sql_parse.cc:6399
      #16 0x00007f9fdb757a0e in mysql_execute_command (thd=thd@entry=0x7f9fd0416070) at /data/src/10.2/sql/sql_parse.cc:3423
      #17 0x00007f9fdb761776 in mysql_parse (thd=thd@entry=0x7f9fd0416070, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f9fdc7638e0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:7842
      #18 0x00007f9fdb7639ff in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f9fd0416070, packet=packet@entry=0x7f9fd0458071 "select * from t1 where f = 1", packet_length=packet_length@entry=28, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:1799
      #19 0x00007f9fdb766531 in do_command (thd=0x7f9fd0416070) at /data/src/10.2/sql/sql_parse.cc:1359
      #20 0x00007f9fdb854480 in do_handle_one_connection (connect=connect@entry=0x7f9fd8871410) at /data/src/10.2/sql/sql_connect.cc:1354
      #21 0x00007f9fdb854669 in handle_one_connection (arg=arg@entry=0x7f9fd8871410) at /data/src/10.2/sql/sql_connect.cc:1260
      #22 0x00007f9fdbb02943 in pfs_spawn_thread (arg=0x7f9fd880f9f0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
      #23 0x00007f9fdae550a4 in start_thread (arg=0x7f9fdc765300) at pthread_create.c:309
      #24 0x00007f9fd967587d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      Attachments

        Issue Links

          Activity

            People

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