Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL)
Description
CREATE TABLE t1 (i INT); |
# For 10.3 the next statement needs to be changed to VALUE(i) |
CREATE TABLE t2 AS SELECT VALUES(i) AS a FROM t1; |
SHOW CREATE TABLE t2; |
 |
# Cleanup
|
DROP TABLE IF EXISTS t1, t2; |
storage_engine=MyISAM |
MariaDB [test]> SHOW CREATE TABLE t2; |
+-------+------------------------------------------------------------------------------------+ |
| Table | Create Table | |
+-------+------------------------------------------------------------------------------------+ |
| t2 | CREATE TABLE `t2` ( |
`a` null DEFAULT NULL |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 | |
+-------+------------------------------------------------------------------------------------+ |
1 row in set (0.00 sec) |
storage_engine=InnoDB |
MariaDB [test]> CREATE TABLE t2 AS SELECT VALUES(i) AS a FROM t1; |
ERROR 1005 (HY000): Can't create table `test`.`t2` (errno: 168 "Unknown (generic) error from engine") |
MariaDB [test]> SHOW WARNINGS;
|
+---------+------+----------------------------------------------------------------------------------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+----------------------------------------------------------------------------------------------------------------------------------------------+
|
| Warning | 1005 | Error creating table 'test/t2' with column 'a'. Please check its column type and try to re-create the table with an appropriate column type. | |
| Error | 1005 | Can't create table `test`.`t2` (errno: 168 "Unknown (generic) error from engine") | |
| Warning | 1030 | Got error 168 "Unknown (generic) error from engine" from storage engine InnoDB | |
+---------+------+----------------------------------------------------------------------------------------------------------------------------------------------+ |
3 rows in set (0.00 sec) |
Reproducible with 5.5-10.3, and also MySQL 5.5; seems to be fixed in 5.6+.
Attachments
Issue Links
- causes
-
MDEV-15319 [SQL Layer] Server crashes in Field::set_null / myrocks::ha_rocksdb::convert_record_from_storage_format
- Closed