Debian Codegraph @

mysql-test/suite/innodb/r/alter_candidate_key.result

raw
1 CREATE TABLE t1 (f1 INT NOT NULL, f2 INT NOT NULL,
2 UNIQUE KEY uidx2(f1,f2),
3 UNIQUE KEY uidx1(f2)) ENGINE=InnoDB;
4 INSERT INTO t1 VALUES(1, 1);
5 SHOW CREATE TABLE t1;
6 Table Create Table
7 t1 CREATE TABLE `t1` (
8 `f1` int(11) NOT NULL,
9 `f2` int(11) NOT NULL,
10 UNIQUE KEY `uidx2` (`f1`,`f2`),
11 UNIQUE KEY `uidx1` (`f2`)
12 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
13 SET DEBUG_SYNC = 'innodb_inplace_alter_table_enter
14 SIGNAL conc_dml WAIT_FOR go_ahead';
15 ALTER TABLE t1 CHANGE COLUMN f1 f11 INT, ALGORITHM=INPLACE;
16 connect con1,localhost,root,,;
17 SET DEBUG_SYNC = 'now WAIT_FOR conc_dml';
18 DELETE FROM t1;
19 SET DEBUG_SYNC = 'now SIGNAL go_ahead';
20 connection default;
21 SHOW CREATE TABLE t1;
22 Table Create Table
23 t1 CREATE TABLE `t1` (
24 `f11` int(11) DEFAULT NULL,
25 `f2` int(11) NOT NULL,
26 UNIQUE KEY `uidx1` (`f2`),
27 UNIQUE KEY `uidx2` (`f11`,`f2`)
28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
29 CHECK TABLE t1;
30 Table Op Msg_type Msg_text
31 test.t1 check status OK
32 DROP TABLE t1;
33 CREATE TABLE t1(f1 INT, f2 INT,
34 PRIMARY KEY(f1, f2),
35 UNIQUE INDEX uidx2 (f1, f2),
36 UNIQUE INDEX uidx1 (f2))ENGINE=InnoDB;
37 INSERT INTO t1 VALUES(2, 2);
38 ALTER TABLE t1 DROP PRIMARY KEY;
39 SHOW CREATE TABLE t1;
40 Table Create Table
41 t1 CREATE TABLE `t1` (
42 `f1` int(11) NOT NULL,
43 `f2` int(11) NOT NULL,
44 UNIQUE KEY `uidx2` (`f1`,`f2`),
45 UNIQUE KEY `uidx1` (`f2`)
46 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
47 SET DEBUG_SYNC = 'innodb_inplace_alter_table_enter
48 SIGNAL conc_dml WAIT_FOR go_ahead';
49 ALTER TABLE t1 CHANGE COLUMN f1 f11 INT, ALGORITHM=INPLACE;
50 connection con1;
51 SET DEBUG_SYNC = 'now WAIT_FOR conc_dml';
52 INSERT INTO t1 VALUES(1, 1), (1, 1);
53 ERROR 23000: Duplicate entry '1-1' for key 'uidx2'
54 SET DEBUG_SYNC = 'now SIGNAL go_ahead';
55 connection default;
56 SHOW CREATE TABLE t1;
57 Table Create Table
58 t1 CREATE TABLE `t1` (
59 `f11` int(11) DEFAULT NULL,
60 `f2` int(11) NOT NULL,
61 UNIQUE KEY `uidx1` (`f2`),
62 UNIQUE KEY `uidx2` (`f11`,`f2`)
63 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
64 CHECK TABLE t1;
65 Table Op Msg_type Msg_text
66 test.t1 check status OK
67 DROP TABLE t1;
68 SET SQL_MODE= strict_trans_tables;
69 CREATE TABLE t1(a INT UNIQUE) ENGINE=InnoDB;
70 INSERT INTO t1 VALUES(1);
71 SET DEBUG_SYNC='row_log_table_apply1_before SIGNAL dml WAIT_FOR dml_done';
72 ALTER TABLE t1 MODIFY COLUMN a INT NOT NULL;
73 connection con1;
74 SET DEBUG_SYNC='now WAIT_FOR dml';
75 BEGIN;
76 INSERT INTO t1 SET a=NULL;
77 COMMIT;
78 set DEBUG_SYNC='now SIGNAL dml_done';
79 connection default;
80 ERROR 22004: Invalid use of NULL value
81 DROP TABLE t1;
82 disconnect con1;
83 SET DEBUG_SYNC="RESET";
84 SET SQL_MODE=DEFAULT;
85 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL, PRIMARY KEY(f1, f2),
86 UNIQUE KEY(f2))ENGINE=InnoDB;
87 ALTER TABLE t1 DROP PRIMARY KEY;
88 SHOW CREATE TABLE t1;
89 Table Create Table
90 t1 CREATE TABLE `t1` (
91 `f1` int(11) NOT NULL,
92 `f2` int(11) NOT NULL,
93 UNIQUE KEY `f2` (`f2`)
94 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
95 DROP TABLE t1;
96 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL,
97 UNIQUE KEY(f2), UNIQUE KEY(f2))ENGINE=InnoDB;
98 Warnings:
99 Note 1831 Duplicate index `f2_2`. This is deprecated and will be disallowed in a future release
100 SHOW CREATE TABLE t1;
101 Table Create Table
102 t1 CREATE TABLE `t1` (
103 `f1` int(11) NOT NULL,
104 `f2` int(11) NOT NULL,
105 UNIQUE KEY `f2` (`f2`),
106 UNIQUE KEY `f2_2` (`f2`)
107 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
108 ALTER TABLE t1 DROP INDEX f2, ALGORITHM=INPLACE;
109 SHOW CREATE TABLE t1;
110 Table Create Table
111 t1 CREATE TABLE `t1` (
112 `f1` int(11) NOT NULL,
113 `f2` int(11) NOT NULL,
114 UNIQUE KEY `f2_2` (`f2`)
115 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
116 DROP TABLE t1;