Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2(EOL), 10.3(EOL), 10.4(EOL)
Description
DROP TABLE IF EXISTS t1,t2; |
CREATE TABLE t1 (a INT COMMENT 'test1'); |
CREATE TABLE t2 (a INT COMMENT 'test2') AS SELECT * FROM t1; |
SHOW CREATE TABLE t1; |
SHOW CREATE TABLE t2; |
+-------+-------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+-------------------------------------------------------------------------------------------------------+
|
| t2 | CREATE TABLE `t2` (
|
`a` int(11) DEFAULT NULL COMMENT 'test1'
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+-------------------------------------------------------------------------------------------------------+
|
The comment for t2.a looks wrong. It should be 'test2'.
Attachments
Issue Links
- relates to
-
MDEV-12828 CREATE TABLE t1 (<defs>) SELECT... does not preserve new SRID
- Open
-
MDEV-12830 CREATE TABLE t1 (<defs>) SELECT... does not preserve new geometry type
- Open
-
MDEV-12831 CREATE TABLE t1 (<defs>) SELECT... does not preserve new CHECK constraint
- Open