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

Unsuccessful VECTOR index creation leaves a temporary file behind

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • 11.8, 12.3
    • N/A
    • Vector search
    • None
    • Not for Release Notes

    Description

      --source include/have_innodb.inc
       
      CREATE TABLE t (f VARBINARY(512) PRIMARY KEY, v VECTOR(1) NOT NULL) ENGINE=InnoDB;
      --error ER_TOO_LONG_KEY
      ALTER TABLE t ADD VECTOR(v);
       
      --list_files $MARIADB_DATADIR/test/ *sql-alter*
       
      DROP TABLE t;
      

      11.8 b22473cf78eccacc7d7bdad483b670b522d6c08d

      ALTER TABLE t ADD VECTOR(v);
      ERROR 42000: Primary key was too long for vector indexes, max length is 256 bytes
      #sql-alter-3d7d46-4.ibd
      DROP TABLE t;
      ...
       
      --- /11.8/mysql-test/var/tmp/check-mysqld_1.result      2026-03-27 16:25:18.904132673 +0200
      +++ /11.8/mysql-test/var/tmp/check-mysqld_1.reject      2026-03-27 16:25:18.992136513 +0200
      @@ -1139,3 +1139,4 @@
       THREAD_POOL_WAITS      1.0     DISABLED        INFORMATION SCHEMA      110807.0        NULL    NULL    Vladislav Vaintroub     Provides wait counters for threadpool.   GPL     OFF     Stable  1.0
       partition      1.0     DISABLED        STORAGE ENGINE  110807.0        NULL    NULL    Mikael Ronstrom, MySQL AB       Partition Storage Engine Helper  GPL     OFF     Stable  1.0
       VARIABLE_NAME  VARIABLE_VALUE
      +#sql-alter-3d7d46-4.ibd
      

      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.