Debian Codegraph @

mysql-test/suite/storage_engine/insert_with_keys.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>, <CUSTOM_INDEX>(b)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
3 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e');
4 INSERT INTO t1 (a,b) VALUES (100,'a'), (6,'f');
5 INSERT INTO t1 (a,b) VALUES (30,'m'),(29,'n');
6 INSERT INTO t1 (a,b) VALUES (1,'a'),(12345,'z');
7 INSERT INTO t1 (a,b) VALUES (3,'a'),(0,'');
8 SELECT a,b FROM t1;
9 a b
10 0
11 1 a
12 1 a
13 100 a
14 12345 z
15 2 b
16 29 n
17 3 a
18 3 c
19 30 m
20 4 d
21 5 e
22 6 f
23 DROP TABLE t1;
24 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>, UNIQUE INDEX(a)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
25 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e');
26 INSERT INTO t1 (a,b) VALUES (100,'a'), (6,'f');
27 INSERT INTO t1 (a,b) VALUES (30,'m'),(29,'n');
28 INSERT INTO t1 (a,b) VALUES (1,'a'),(12345,'z');
29 ERROR 23000: Duplicate entry '1' for key 'a'
30 # Statement ended with one of expected results (ER_DUP_ENTRY,ER_DUP_KEY).
31 # If you got a difference in error message, just add it to rdiff file
32 INSERT INTO t1 (a,b) VALUES (3,'a'),(0,'');
33 ERROR 23000: Duplicate entry '3' for key 'a'
34 # Statement ended with one of expected results (ER_DUP_ENTRY,ER_DUP_KEY).
35 # If you got a difference in error message, just add it to rdiff file
36 INSERT INTO t1 (a,b) VALUES (0,'');
37 SELECT a,b FROM t1;
38 a b
39 0
40 1 a
41 100 a
42 2 b
43 29 n
44 3 c
45 30 m
46 4 d
47 5 e
48 6 f
49 INSERT IGNORE INTO t1 (a,b) VALUES (1,'a'),(12345,'z');
50 Warnings:
51 Warning 1062 Duplicate entry '1' for key 'a'
52 INSERT INTO t1 (a,b) VALUES (3,'a'),(4,'d') ON DUPLICATE KEY UPDATE a = a+10;
53 SELECT a,b FROM t1;
54 a b
55 0
56 1 a
57 100 a
58 12345 z
59 13 c
60 14 d
61 2 b
62 29 n
63 30 m
64 5 e
65 6 f
66 DROP TABLE t1;
67 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>, UNIQUE INDEX(a,b)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
68 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e');
69 INSERT INTO t1 (a,b) VALUES (100,'a'), (6,'f');
70 INSERT INTO t1 (a,b) VALUES (30,'m'),(29,'n');
71 INSERT INTO t1 (a,b) VALUES (100,'b'), (2,'c');
72 INSERT INTO t1 (a,b) VALUES (1,'a'),(12345,'z');
73 ERROR 23000: Duplicate entry '1-a' for key 'a'
74 # Statement ended with one of expected results (ER_DUP_ENTRY,ER_DUP_KEY).
75 # If you got a difference in error message, just add it to rdiff file
76 SELECT a,b FROM t1;
77 a b
78 1 a
79 100 a
80 100 b
81 2 b
82 2 c
83 29 n
84 3 c
85 30 m
86 4 d
87 5 e
88 6 f
89 INSERT IGNORE INTO t1 (a,b) VALUES (1,'a'),(12345,'z');
90 Warnings:
91 Warning 1062 Duplicate entry '1-a' for key 'a'
92 INSERT INTO t1 (a,b) VALUES (1,'a'),(12345,'z') ON DUPLICATE KEY UPDATE a = a+VALUES(a);
93 SELECT a,b FROM t1;
94 a b
95 100 a
96 100 b
97 2 a
98 2 b
99 2 c
100 24690 z
101 29 n
102 3 c
103 30 m
104 4 d
105 5 e
106 6 f
107 INSERT INTO t1 (a,b) VALUES (101,'x'),(101,'x');
108 ERROR 23000: Duplicate entry '101-x' for key 'a'
109 # Statement ended with one of expected results (ER_DUP_ENTRY,ER_DUP_KEY).
110 # If you got a difference in error message, just add it to rdiff file
111 DROP TABLE t1;
112 CREATE TABLE t1 (a <INT_COLUMN> PRIMARY KEY, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
113 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e');
114 INSERT INTO t1 (a,b) VALUES (100,'a'), (6,'f');
115 INSERT INTO t1 (a,b) VALUES (30,'m'),(29,'n');
116 INSERT INTO t1 (a,b) VALUES (1,'a'),(12345,'z');
117 ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
118 # Statement ended with one of expected results (ER_DUP_ENTRY,ER_DUP_KEY).
119 # If you got a difference in error message, just add it to rdiff file
120 INSERT INTO t1 (a,b) VALUES (3,'a'),(0,'');
121 ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
122 # Statement ended with one of expected results (ER_DUP_ENTRY,ER_DUP_KEY).
123 # If you got a difference in error message, just add it to rdiff file
124 INSERT INTO t1 (a,b) VALUES (0,'');
125 SELECT a,b FROM t1;
126 a b
127 0
128 1 a
129 100 a
130 2 b
131 29 n
132 3 c
133 30 m
134 4 d
135 5 e
136 6 f
137 INSERT IGNORE INTO t1 (a,b) VALUES (1,'a'),(12345,'z');
138 Warnings:
139 Warning 1062 Duplicate entry '1' for key 'PRIMARY'
140 INSERT INTO t1 (a,b) VALUES (1,'a'),(12345,'z') ON DUPLICATE KEY UPDATE b = CONCAT(b,b);
141 SELECT a,b FROM t1;
142 a b
143 0
144 1 aa
145 100 a
146 12345 zz
147 2 b
148 29 n
149 3 c
150 30 m
151 4 d
152 5 e
153 6 f
154 DROP TABLE t1;
155 CREATE TABLE t1 (a <INT_COLUMN> UNIQUE KEY, b <INT_COLUMN> UNIQUE KEY, c <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
156 INSERT INTO t1 VALUES(1,1,0);
157 INSERT INTO t1 VALUES(2,3,0);
158 INSERT INTO t1 VALUES(3,2,0);
159 INSERT INTO t1 VALUES(1,1,0) ON DUPLICATE KEY UPDATE c=c+1;
160 INSERT INTO t1 VALUES(2,3,0) ON DUPLICATE KEY UPDATE c=c+1;
161 INSERT INTO t1 VALUES(3,2,0) ON DUPLICATE KEY UPDATE c=c+1;
162 INSERT INTO t1 VALUES(2,5,0) ON DUPLICATE KEY UPDATE c=c+1;
163 INSERT INTO t1 VALUES(3,5,0) ON DUPLICATE KEY UPDATE c=c+1;
164 INSERT INTO t1 VALUES(5,3,0) ON DUPLICATE KEY UPDATE c=c+1;
165 INSERT INTO t1 VALUES(6,2,0) ON DUPLICATE KEY UPDATE c=c+1;
166 INSERT INTO t1 VALUES(1,3,0) ON DUPLICATE KEY UPDATE c=c+1;
167 INSERT INTO t1 VALUES(2,2,0) ON DUPLICATE KEY UPDATE c=c+1;
168 SELECT * FROM t1;
169 a b c
170 1 1 2
171 2 3 4
172 3 2 3
173 DROP TABLE t1;