Debian Codegraph @

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