Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
5.5, 10.0, 10.1, 10.2
-
None
Description
create table t1 (i int); |
create table t2 SELECT (SELECT i FROM t1) FROM t1; |
show create table t2; |
on 5.5-10.2
MariaDB [test]> show create table t2;
|
+-------+------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+------------------------------------------------------------------------------------------------------------+
|
| t2 | CREATE TABLE `t2` (
|
`(SELECT i FROM t1)` bigint(11) DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.01 sec)
|
on 10.3-10.5
+-------+---------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+---------------------------------------------------------------------------------------------------------+
|
| t2 | CREATE TABLE `t2` (
|
`(SELECT i FROM t1)` int(11) DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+---------------------------------------------------------------------------------------------------------+
|
1 row in set (0.009 sec)
|
Then if I use row replication between versions e.g. 10.2 and 10.3, it stops with an error:
Last_SQL_Errno: 1677
|
Last_SQL_Error: Column 0 of table 'test.t2' cannot be converted from type 'bigint' to type 'int(11)'
|