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

          Activity

            Transition Time In Source Status Execution Times
            Sergei Golubchik made transition -
            Open In Progress
            19h 48m 1
            Sergei Golubchik made transition -
            In Progress In Testing
            3s 1
            Sergei Golubchik made transition -
            In Testing Closed
            2d 22h 20m 1

            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.