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

VEC_DISTANCE does not work in INSERT DELAYED .. RETURNING

Details

    Description

      Given that INSERT DELAYED .. RETURNING in general doesn't work "by design" (it doesn't normally fail, just doesn't return the result set it would have returned without DELAYED), it isn't a meaningful scenario, but I'll file it for the record anyway.

      create table t (v vector(1) not null, vector(v)) engine=MyISAM;
      		 
      insert delayed into t values (0x31313131),(0x32323232) returning vec_distance(v,0x30303030);
      		 
      drop table t;

      bb-11.8-MDEV-35450-vec_distance b4c96d33bd38a9008e903aaff12d29c6e904eeed

      		 
      mysqltest: At line 2: query 'insert delayed into t values (0x31313131),(0x32323232) returning vec_distance(v,0x30303030)' failed: ER_VEC_DISTANCE_TYPE (4206): Cannot determine distance type for VEC_DISTANCE, index is not found

      Attachments

        Issue Links

          is caused by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-35450 VEC_DISTANCE() function to autouse the available index type

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            serg Sergei Golubchik made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Status In Progress [ 3 ] In Testing [ 10301 ]
            serg Sergei Golubchik added a comment -

            apparently fixed by MDEV-35752 fix

            serg Sergei Golubchik added a comment - apparently fixed by MDEV-35752 fix
            serg Sergei Golubchik made changes -
            Fix Version/s 11.8.1 [ 29961 ]
            Fix Version/s 11.8 [ 29921 ]
            Resolution Fixed [ 1 ]
            Status In Testing [ 10301 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Fix Version/s N/A [ 14700 ]
            Fix Version/s 11.8.1 [ 29961 ]

            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.