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

Assertion failure in Create_tmp_table::finalize upon DISTINCT with vector type

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • N/A
    • 11.7.1
    • Vector search
    • None

    Description

      CREATE TABLE t (v VECTOR(1));
      INSERT INTO t VALUES (0x00000000),(0x00000040);
      SELECT DISTINCT v FROM t;
       
      # Cleanup
      DROP TABLE t;
      

      bb-11.6-MDEV-32887-vector 27ae9cbb91489e93fe30b02360a843f974e5e1fc

      mariadbd: /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:21877: bool Create_tmp_table::finalize(THD*, TABLE*, TMP_TABLE_PARAM*, bool, bool): Assertion `m_using_unique_constraint || m_group_buff <= param->group_buff + param->group_length' failed.
      241017 14:25:54 [ERROR] mysqld got signal 6 ;
       
      #9  0x00007f9dfaa53e32 in __GI___assert_fail (assertion=0x5648dba16ec0 "m_using_unique_constraint || m_group_buff <= param->group_buff + param->group_length", file=0x5648dba09880 "/data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc", line=21877, function=0x5648dba16ce0 "bool Create_tmp_table::finalize(THD*, TABLE*, TMP_TABLE_PARAM*, bool, bool)") at ./assert/assert.c:101
      #10 0x00005648d98088b0 in Create_tmp_table::finalize (this=0x7f9def76b550, thd=0x62c0000c0218, table=0x6200000140b8, param=0x629000267458, do_not_open=true, keep_row_order=false) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:21877
      #11 0x00005648d980c053 in create_tmp_table (thd=0x62c0000c0218, param=0x629000267458, fields=..., group=0x6290000ea150, distinct=false, save_sum_fields=false, select_options=2164525825, rows_limit=18446744073709551615, table_alias=0x5648dd08c300 <empty_clex_str>, do_not_open=true, keep_row_order=false) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:22116
      #12 0x00005648d978ab73 in JOIN::create_postjoin_aggr_table (this=0x6290000e7a08, tab=0x6290000e9618, table_fields=0x6290000e7db0, table_group=0x6290000ea150, save_sum_fields=false, distinct=false, keep_row_order=false) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:4305
      #13 0x00005648d978611d in JOIN::make_aggr_tables_info (this=0x6290000e7a08) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:3865
      #14 0x00005648d978161f in JOIN::optimize_stage2 (this=0x6290000e7a08) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:3482
      #15 0x00005648d9779774 in JOIN::optimize_inner (this=0x6290000e7a08) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:2713
      #16 0x00005648d9771eb1 in JOIN::optimize (this=0x6290000e7a08) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:1985
      #17 0x00005648d9794842 in mysql_select (thd=0x62c0000c0218, tables=0x6290000e6960, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2164525825, result=0x6290000e79d8, unit=0x62c0000c4710, select_lex=0x6290000e62d8) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:5328
      #18 0x00005648d9762f6f in handle_select (thd=0x62c0000c0218, lex=0x62c0000c4630, result=0x6290000e79d8, setup_tables_done_option=0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:624
      #19 0x00005648d9685b25 in execute_sqlcom_select (thd=0x62c0000c0218, all_tables=0x6290000e6960) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:6151
      #20 0x00005648d9675750 in mysql_execute_command (thd=0x62c0000c0218, is_called_from_prepared_stmt=false) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:3953
      #21 0x00005648d9690576 in mysql_parse (thd=0x62c0000c0218, rawbuf=0x6290000e6238 "SELECT DISTINCT v FROM t", length=24, parser_state=0x7f9def76d9f0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:7873
      #22 0x00005648d9667598 in dispatch_command (command=COM_QUERY, thd=0x62c0000c0218, packet=0x629000253219 "SELECT DISTINCT v FROM t", packet_length=24, blocking=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:1892
      #23 0x00005648d96642ac in do_command (thd=0x62c0000c0218, blocking=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:1405
      #24 0x00005648d9b53879 in do_handle_one_connection (connect=0x6080000034b8, put_in_cache=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_connect.cc:1448
      #25 0x00005648d9b5323a in handle_one_connection (arg=0x608000003438) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_connect.cc:1350
      #26 0x00005648da7f8ee8 in pfs_spawn_thread (arg=0x617000005b98) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/storage/perfschema/pfs.cc:2198
      #27 0x00007f9dfaaa8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #28 0x00007f9dfab2861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              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.