Bug #83898 ERROR 1030 (HY000): Got error -1 from storage engine
Submitted: 21 Nov 2016 6:44 Modified: 21 Nov 2016 7:15
Reporter: Roel Van de Paar Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:5.6.34 OS:Any
Assigned to: CPU Architecture:Any

[21 Nov 2016 6:44] Roel Van de Paar 
Description:
mysql> CREATE TEMPORARY TABLE t1 (c1 DATE  KEY,c2 VARCHAR(1) CHARACTER SET "utf8" COLLATE "utf8_bin",c3 VARCHAR(1) BINARY) ENGINE=ARCHIVE;
ERROR 1030 (HY000): Got error -1 from storage engine

How to repeat:
# mysqld options required for replay: --sql_mode=
DROP DATABASE transforms;CREATE DATABASE transforms;DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TEMPORARY TABLE t1 (c1 DATE  KEY,c2 VARCHAR(1) CHARACTER SET "utf8" COLLATE "utf8_bin",c3 VARCHAR(1) BINARY) ENGINE=ARCHIVE;
[21 Nov 2016 6:45] Roel Van de Paar 
Another one

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t2(c1 DATE,c2 CHAR BINARY CHARACTER SET "utf8" COLLATE "utf8_bin",c3 INT,PRIMARY KEY(c1)) ENGINE=ARCHIVE;
[21 Nov 2016 7:15] MySQL Verification Team 
Hello Roel,

Thank you for the report and test case.
Observed this with 5.6.34/5.7.16 builds.

Thanks,
Umesh