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

Vector indexes are allowed for MERGE tables, but do not work

    XMLWordPrintable

Details

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

    Description

      CREATE TABLE t (a INT, v BLOB NOT NULL, VECTOR INDEX(v)) ENGINE=MyISAM;
      CREATE TABLE tm (a INT, v BLOB NOT NULL, VECTOR INDEX(v)) ENGINE=MERGE UNION=(t);
       
      INSERT INTO t VALUES (1,x'00000000');
      UPDATE tm SET a = 2;
       
      # Cleanup
      DROP TABLE tm, t;
      

      bb-11.6-MDEV-32887-vector fe9092a8

      UPDATE tm SET a = 2;
      bug.vec6-1                               [ fail ]
              Test ended at 2024-09-29 23:26:10
       
      CURRENT_TEST: bug.vec6-1
      mysqltest: At line 5: query 'UPDATE tm SET a = 2' failed: ER_KEY_NOT_FOUND (1032): Can't find record in 'tm'
      

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.