Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.10
-
None
Description
mysql 10.0.10-MariaDB (root) [test]> show create table t1\G
|
*************************** 1. row ***************************
|
Table: t1
|
Create Table: CREATE TABLE `t1` (
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
`c1` char(32) DEFAULT NULL,
|
`c2` char(32) DEFAULT NULL,
|
`c3` char(32) DEFAULT NULL,
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
|
1 row in set (0.00 sec)
|
|
mysql 10.0.10-MariaDB (root) [test]> select * from t1;
|
+----+------+------+------+
|
| id | c1 | c2 | c3 |
|
+----+------+------+------+
|
| 1 | a | NULL | c |
|
+----+------+------+------+
|
1 row in set (0.00 sec)
|
|
mysql 10.0.10-MariaDB (root) [test]> create table t1_pivot engine=connect table_type=pivot tabname=t1;
|
ERROR 1939 (HY000): Engine CONNECT failed to discover table `test`.`t1_pivot` with 'CREATE TABLE whatever (`id` INT(10) NOT NULL,`c1` CHAR(32) NOT NULL,`` CHAR(32) NOT NULL FLAG=1) TABLE_TYPE='pivot' TABNAME='t1''
|
This should work differently, or it should be documented and should give a better error message.