Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 CREATE TABLE t1(c1 TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
5 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
6 TRUNCATE t1 ;
7 SELECT * FROM t1 ORDER BY c1;
8 INSERT INTO t1 VALUES (null),(null),(null);
9 SELECT * FROM t1 ORDER BY c1;
10 DROP TABLE t1;
11 CREATE TABLE t1(c1 SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
12 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
13 TRUNCATE t1 ;
14 SELECT * FROM t1 ORDER BY c1;
15 INSERT INTO t1 VALUES (null),(null),(null);
16 SELECT * FROM t1 ORDER BY c1;
17 DROP TABLE t1;
18 CREATE TABLE t1(c1 MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
19 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
20 TRUNCATE t1 ;
21 SELECT * FROM t1 ORDER BY c1;
22 INSERT INTO t1 VALUES (null),(null),(null);
23 SELECT * FROM t1 ORDER BY c1;
24 DROP TABLE t1;
25 CREATE TABLE t1(c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
26 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
27 TRUNCATE t1 ;
28 SELECT * FROM t1 ORDER BY c1;
29 INSERT INTO t1 VALUES (null),(null),(null);
30 SELECT * FROM t1 ORDER BY c1;
31 DROP TABLE t1;
32 CREATE TABLE t1(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY);
33 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
34 TRUNCATE t1 ;
35 SELECT * FROM t1 ORDER BY c1;
36 INSERT INTO t1 VALUES (null),(null),(null);
37 SELECT * FROM t1 ORDER BY c1;
38 DROP TABLE t1;
39 CREATE TABLE t1(c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
40 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
41 TRUNCATE t1 ;
42 SELECT * FROM t1 ORDER BY c1;
43 INSERT INTO t1 VALUES (null),(null),(null);
44 SELECT * FROM t1 ORDER BY c1;
45 DROP TABLE t1;
46 CREATE TABLE t1(c1 TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
47 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
48 TRUNCATE TABLE t1 ;
49 SELECT * FROM t1 ORDER BY c1;
50 INSERT INTO t1 VALUES (null),(null),(null);
51 SELECT * FROM t1 ORDER BY c1;
52 DROP TABLE t1;
53 CREATE TABLE t1(c1 SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
54 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
55 TRUNCATE TABLE t1 ;
56 SELECT * FROM t1 ORDER BY c1;
57 INSERT INTO t1 VALUES (null),(null),(null);
58 SELECT * FROM t1 ORDER BY c1;
59 DROP TABLE t1;
60 CREATE TABLE t1(c1 MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
61 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
62 TRUNCATE TABLE t1 ;
63 SELECT * FROM t1 ORDER BY c1;
64 INSERT INTO t1 VALUES (null),(null),(null);
65 SELECT * FROM t1 ORDER BY c1;
66 DROP TABLE t1;
67 CREATE TABLE t1(c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
68 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
69 TRUNCATE TABLE t1 ;
70 SELECT * FROM t1 ORDER BY c1;
71 INSERT INTO t1 VALUES (null),(null),(null);
72 SELECT * FROM t1 ORDER BY c1;
73 DROP TABLE t1;
74 CREATE TABLE t1(c1 INTEGER 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 INSERT INTO t1 VALUES (null),(null),(null);
79 SELECT * FROM t1 ORDER BY c1;
80 DROP TABLE t1;
81 CREATE TABLE t1(c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
82 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
83 TRUNCATE TABLE t1 ;
84 SELECT * FROM t1 ORDER BY c1;
85 INSERT INTO t1 VALUES (null),(null),(null);
86 SELECT * FROM t1 ORDER BY c1;
87 DROP TABLE t1;
88