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

Assertion `tab->join->order' fails upon vector search with DISTINCT #2

    XMLWordPrintable

Details

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

    Description

      The fix for MDEV-35105 is already in the tree.

      create table t (v vector(1) not null, vector(v));
      insert into t values (0x00000000),(0x00000040);
       
      select distinct vec_distance_euclidean(v,0x00000000) d from t order by d limit 1;
       
      # Cleanup
      drop table t;
      

      bb-11.6-MDEV-32887-vector a919a7de0ef3d7a11a7a529eb9043e51c577b6d6

      mariadbd: /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:24761: int join_read_first(JOIN_TAB*): Assertion `tab->join->order' failed.
      241018  0:22:39 [ERROR] mysqld got signal 6 ;
       
      #9  0x00007fc945e53e32 in __GI___assert_fail (assertion=0x563ec5af6dc0 "tab->join->order", file=0x563ec5ae7880 "/data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc", line=24761, function=0x563ec5af6ca0 "int join_read_first(JOIN_TAB*)") at ./assert/assert.c:101
      #10 0x0000563ec38fd542 in join_read_first (tab=0x62900026c238) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:24761
      #11 0x0000563ec38f50a7 in sub_select (join=0x6290000e7e90, join_tab=0x62900026c238, end_of_records=false) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:23651
      #12 0x0000563ec38f2af7 in do_select (join=0x6290000e7e90, procedure=0x0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:23165
      #13 0x0000563ec3870f7a in JOIN::exec_inner (this=0x6290000e7e90) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:5026
      #14 0x0000563ec386e304 in JOIN::exec (this=0x6290000e7e90) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:4809
      #15 0x0000563ec3872a33 in mysql_select (thd=0x62c0000c0218, tables=0x6290000e6be8, fields=..., conds=0x0, og_num=1, order=0x6290000e7cc8, group=0x0, having=0x0, proc_param=0x0, select_options=2164525825, result=0x6290000e7e60, unit=0x62c0000c4710, select_lex=0x6290000e6348) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:5342
      #16 0x0000563ec3840f6f in handle_select (thd=0x62c0000c0218, lex=0x62c0000c4630, result=0x6290000e7e60, setup_tables_done_option=0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:624
      #17 0x0000563ec3763b25 in execute_sqlcom_select (thd=0x62c0000c0218, all_tables=0x6290000e6be8) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:6151
      #18 0x0000563ec3753750 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
      #19 0x0000563ec376e576 in mysql_parse (thd=0x62c0000c0218, rawbuf=0x6290000e6238 "select distinct vec_distance_euclidean(v,0x00000000) d from t order by d limit 1", length=80, parser_state=0x7fc93ab579f0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:7873
      #20 0x0000563ec3745598 in dispatch_command (command=COM_QUERY, thd=0x62c0000c0218, packet=0x629000253219 "", packet_length=80, blocking=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:1892
      #21 0x0000563ec37422ac 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
      #22 0x0000563ec3c31755 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
      #23 0x0000563ec3c31116 in handle_one_connection (arg=0x608000003438) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_connect.cc:1350
      #24 0x0000563ec48d6c8a in pfs_spawn_thread (arg=0x617000005b98) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/storage/perfschema/pfs.cc:2198
      #25 0x00007fc945ea8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #26 0x00007fc945f2861c 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.