Debian Codegraph @

mysql-test/suite/engines/funcs/t/in_multicolumn_string_unique_constraint_ignore.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 CREATE TABLE t1(c1 CHAR(10) NULL, c2 CHAR(10) NULL, c3 CHAR(10) NULL, UNIQUE(c1,c2,c3));
5 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
6 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
7 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
8 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
9 INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
10 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
11 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
12 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
13 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
14 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','def','def');
15 --sorted_result
16 SELECT * FROM t1;
17 DROP TABLE t1;
18 CREATE TABLE t1(c1 VARCHAR(10) NULL, c2 VARCHAR(10) NULL, c3 VARCHAR(10) NULL, UNIQUE(c1,c2,c3));
19 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
20 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
21 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
22 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
23 INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
24 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
25 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
26 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
27 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
28 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','def','def');
29 --sorted_result
30 SELECT * FROM t1;
31 DROP TABLE t1;
32 CREATE TABLE t1(c1 BINARY(10) NULL, c2 BINARY(10) NULL, c3 BINARY(10) NULL, UNIQUE(c1,c2,c3));
33 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
34 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
35 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
36 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
37 INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
38 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
39 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
40 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
41 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
42 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','def','def');
43 --replace_regex /[^[:print:]]/#/
44 --sorted_result
45 SELECT * FROM t1;
46 DROP TABLE t1;
47 CREATE TABLE t1(c1 VARBINARY(10) NULL, c2 VARBINARY(10) NULL, c3 VARBINARY(10) NULL, UNIQUE(c1,c2,c3));
48 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
49 INSERT INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
50 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','abc');
51 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','abc');
52 INSERT INTO t1 (c1,c2,c3) VALUES('def','def','abc');
53 INSERT INTO t1 (c1,c2,c3) VALUES('def','abc','def');
54 INSERT INTO t1 (c1,c2,c3) VALUES('abc','def','def');
55 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','abc','abc');
56 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','abc','def');
57 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES('abc','def','def');
58 --sorted_result
59 SELECT * FROM t1;
60 DROP TABLE t1;
61