Bug #112660 Got error -1 - 'Unknown error -1' from storage engine

• Submitted: 9 Oct 2023 2:21
• Modified: 9 Oct 2023 8:51
• Reporter: Fuzz CS
• Status: Verified
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• Version: 8.1.0, 8.0.34
• OS: Linux
• CPU Architecture: Any

[9 Oct 2023 2:21] Fuzz CS

Description:
mysql> CREATE  TABLE table22 ( v0 FLOAT  DEFAULT 2031962.984951307  PRIMARY KEY, v1 LONGBLOB NOT  NULL  , v2 MEDIUMBLOB NOT  NULL  , v3 INT NOT  NULL DEFAULT 185659406 , v4 BOOL NOT  NULL DEFAULT FALSE , v5 DATE  DEFAULT '1510-12-12 13:55:01.953044' , v6 TINYTEXT NOT  NULL  , v7 MEDIUMBLOB NOT  NULL  , v8 DATE NOT  NULL DEFAULT '1607-05-30 00:06:10.403383'   ) ENGINE = INNODB CHARACTER SET=cp1257 COLLATE=cp1257_general_ci;

mysql> ALTER TABLE table22 ENGINE = ARCHIVE;

ERROR 1030 (HY000): Got error -1 - 'Unknown error -1' from storage engine

How to repeat:
CREATE  TABLE table22 ( v0 FLOAT  DEFAULT 2031962.984951307  PRIMARY KEY, v1 LONGBLOB NOT  NULL  , v2 MEDIUMBLOB NOT  NULL  , v3 INT NOT  NULL DEFAULT 185659406 , v4 BOOL NOT  NULL DEFAULT FALSE , v5 DATE  DEFAULT '1510-12-12 13:55:01.953044' , v6 TINYTEXT NOT  NULL  , v7 MEDIUMBLOB NOT  NULL  , v8 DATE NOT  NULL DEFAULT '1607-05-30 00:06:10.403383'   ) ENGINE = INNODB CHARACTER SET=cp1257 COLLATE=cp1257_general_ci;

ALTER TABLE table22 ENGINE = ARCHIVE;

[9 Oct 2023 8:51] MySQL Verification Team

Hello ying ying,

Thank you for the report and test case.

regards,
Umesh