summaryrefslogtreecommitdiff
path: root/mysql-test/main/alter_table_combinations,aria.rdiff
blob: c549f307d1f42c6e03d36f830caf28289ae26f4e (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
--- main/alter_table_combinations.result	2022-05-24 17:16:56.769146869 +0200
+++ main/alter_table_combinations.reject	2022-05-24 17:25:20.847126357 +0200
@@ -173,8 +173,7 @@
 t3	CREATE TABLE `t3` (
   `a` int(11) DEFAULT NULL,
   `b` int(11) DEFAULT NULL,
-  KEY `b` (`b`),
-  CONSTRAINT `t3_ibfk_1` FOREIGN KEY (`b`) REFERENCES `t1` (`bb`)
+  KEY `b` (`b`)
 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=latin1
 ALTER TABLE t1 RENAME COLUMN bb TO b;
 SHOW CREATE TABLE t1;
@@ -190,8 +189,7 @@
 t3	CREATE TABLE `t3` (
   `a` int(11) DEFAULT NULL,
   `c` int(11) DEFAULT NULL,
-  KEY `b` (`c`),
-  CONSTRAINT `t3_ibfk_1` FOREIGN KEY (`c`) REFERENCES `t1` (`b`)
+  KEY `b` (`c`)
 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=latin1
 CREATE TABLE t4(a int);
 ALTER TABLE t4 RENAME COLUMN a TO aa, ALGORITHM = INPLACE;