Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
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
-
-
- Closed
-
- is caused by
-
MDEV-371 Unique indexes for blobs
-
- Closed
-