Debian Codegraph @

mysql-test/suite/engines/funcs/r/de_autoinc.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
3 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
4 DELETE FROM t1 WHERE c1 >= 3;
5 SELECT * FROM t1 ORDER BY c1;
6 c1
7 1
8 2
9 INSERT INTO t1 VALUES (null),(null),(null);
10 SELECT * FROM t1 ORDER BY c1;
11 c1
12 1
13 2
14 7
15 8
16 9
17 DELETE FROM t1 ;
18 SELECT * FROM t1 ORDER BY c1;
19 c1
20 INSERT INTO t1 VALUES (null),(null),(null);
21 SELECT * FROM t1 ORDER BY c1;
22 c1
23 10
24 11
25 12
26 DROP TABLE t1;
27 CREATE TABLE t1(c1 SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
28 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
29 DELETE FROM t1 WHERE c1 >= 3;
30 SELECT * FROM t1 ORDER BY c1;
31 c1
32 1
33 2
34 INSERT INTO t1 VALUES (null),(null),(null);
35 SELECT * FROM t1 ORDER BY c1;
36 c1
37 1
38 2
39 7
40 8
41 9
42 DELETE FROM t1 ;
43 SELECT * FROM t1 ORDER BY c1;
44 c1
45 INSERT INTO t1 VALUES (null),(null),(null);
46 SELECT * FROM t1 ORDER BY c1;
47 c1
48 10
49 11
50 12
51 DROP TABLE t1;
52 CREATE TABLE t1(c1 MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
53 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
54 DELETE FROM t1 WHERE c1 >= 3;
55 SELECT * FROM t1 ORDER BY c1;
56 c1
57 1
58 2
59 INSERT INTO t1 VALUES (null),(null),(null);
60 SELECT * FROM t1 ORDER BY c1;
61 c1
62 1
63 2
64 7
65 8
66 9
67 DELETE FROM t1 ;
68 SELECT * FROM t1 ORDER BY c1;
69 c1
70 INSERT INTO t1 VALUES (null),(null),(null);
71 SELECT * FROM t1 ORDER BY c1;
72 c1
73 10
74 11
75 12
76 DROP TABLE t1;
77 CREATE TABLE t1(c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
78 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
79 DELETE FROM t1 WHERE c1 >= 3;
80 SELECT * FROM t1 ORDER BY c1;
81 c1
82 1
83 2
84 INSERT INTO t1 VALUES (null),(null),(null);
85 SELECT * FROM t1 ORDER BY c1;
86 c1
87 1
88 2
89 7
90 8
91 9
92 DELETE FROM t1 ;
93 SELECT * FROM t1 ORDER BY c1;
94 c1
95 INSERT INTO t1 VALUES (null),(null),(null);
96 SELECT * FROM t1 ORDER BY c1;
97 c1
98 10
99 11
100 12
101 DROP TABLE t1;
102 CREATE TABLE t1(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY);
103 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
104 DELETE FROM t1 WHERE c1 >= 3;
105 SELECT * FROM t1 ORDER BY c1;
106 c1
107 1
108 2
109 INSERT INTO t1 VALUES (null),(null),(null);
110 SELECT * FROM t1 ORDER BY c1;
111 c1
112 1
113 2
114 7
115 8
116 9
117 DELETE FROM t1 ;
118 SELECT * FROM t1 ORDER BY c1;
119 c1
120 INSERT INTO t1 VALUES (null),(null),(null);
121 SELECT * FROM t1 ORDER BY c1;
122 c1
123 10
124 11
125 12
126 DROP TABLE t1;
127 CREATE TABLE t1(c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
128 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
129 DELETE FROM t1 WHERE c1 >= 3;
130 SELECT * FROM t1 ORDER BY c1;
131 c1
132 1
133 2
134 INSERT INTO t1 VALUES (null),(null),(null);
135 SELECT * FROM t1 ORDER BY c1;
136 c1
137 1
138 2
139 7
140 8
141 9
142 DELETE FROM t1 ;
143 SELECT * FROM t1 ORDER BY c1;
144 c1
145 INSERT INTO t1 VALUES (null),(null),(null);
146 SELECT * FROM t1 ORDER BY c1;
147 c1
148 10
149 11
150 12
151 DROP TABLE t1;