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

Incorrect information in file: './test/#sql-alter-......frm' on ALTER TABLE ... ADD UNIQUE ... USING HASH

    XMLWordPrintable

Details

    Description

      CREATE TABLE t (a INT AUTO_INCREMENT KEY,b FLOAT(5,3),c BLOB (1),d CHAR(1),e TEXT) ENGINE=InnoDB;
      		 
      ALTER TABLE t ADD UNIQUE id USING HASH (a);

      Leads to:

      10.9.0 5be92887c2caacb45af87b1131db952ce627e83a (Debug)

      		 
      2022-04-04 20:22:30 0 [Note] /test/MD160322-mariadb-10.9.0-linux-x86_64-dbg/bin/mysqld: ready for connections.
      		 
      Version: '10.9.0-MariaDB-debug'  socket: '/test/MD160322-mariadb-10.9.0-linux-x86_64-dbg/socket.sock'  port: 10908  MariaDB Server
      		 
      2022-04-04 20:22:39 5 [ERROR] mysqld: Incorrect information in file: './test/#sql-alter-4a98e-5.frm'

      10.9.0 5be92887c2caacb45af87b1131db952ce627e83a (Optimized)

      		 
      2022-04-04 20:16:37 0 [Note] /test/MD160322-mariadb-10.9.0-linux-x86_64-opt/bin/mysqld: ready for connections.
      		 
      Version: '10.9.0-MariaDB'  socket: '/test/MD160322-mariadb-10.9.0-linux-x86_64-opt/socket.sock'  port: 10640  MariaDB Server
      		 
      2022-04-04 20:16:40 4 [ERROR] mysqld: Incorrect information in file: './test/#sql-alter-30b37-4.frm'

      Bug confirmed present in:
      MariaDB: 10.4.25 (dbg), 10.4.25 (opt), 10.5.16 (dbg), 10.5.16 (opt), 10.6.8 (dbg), 10.6.8 (opt), 10.7.4 (dbg), 10.7.4 (opt), 10.8.3 (dbg), 10.8.3 (opt), 10.9.0 (dbg), 10.9.0 (opt)

      Bug (or feature/syntax) confirmed not present in:
      MariaDB: 10.2.44 (dbg), 10.2.44 (opt), 10.3.35 (dbg), 10.3.35 (opt)
      MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.37 (dbg), 5.7.37 (opt), 8.0.28 (dbg), 8.0.28 (opt)

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29203 Incorrect information in file: ... #sql-alter ... .frm on ALTER when adding unique hash index, ERROR 1901

          • Major - Major loss of function.
          • Confirmed
          is caused by

          Task - A task that needs to be done. MDEV-371 Unique indexes for blobs

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

          Activity

            People

              Unassigned Unassigned
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.