Debian Codegraph @

mysql-test/suite/engines/funcs/t/de_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 DELETE FROM t1 WHERE c1 >= 3;
7 SELECT * FROM t1 ORDER BY c1;
8 INSERT INTO t1 VALUES (null),(null),(null);
9 SELECT * FROM t1 ORDER BY c1;
10 DELETE FROM t1 ;
11 SELECT * FROM t1 ORDER BY c1;
12 INSERT INTO t1 VALUES (null),(null),(null);
13 SELECT * FROM t1 ORDER BY c1;
14 DROP TABLE t1;
15 CREATE TABLE t1(c1 SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
16 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
17 DELETE FROM t1 WHERE c1 >= 3;
18 SELECT * FROM t1 ORDER BY c1;
19 INSERT INTO t1 VALUES (null),(null),(null);
20 SELECT * FROM t1 ORDER BY c1;
21 DELETE FROM t1 ;
22 SELECT * FROM t1 ORDER BY c1;
23 INSERT INTO t1 VALUES (null),(null),(null);
24 SELECT * FROM t1 ORDER BY c1;
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 DELETE FROM t1 WHERE c1 >= 3;
29 SELECT * FROM t1 ORDER BY c1;
30 INSERT INTO t1 VALUES (null),(null),(null);
31 SELECT * FROM t1 ORDER BY c1;
32 DELETE FROM t1 ;
33 SELECT * FROM t1 ORDER BY c1;
34 INSERT INTO t1 VALUES (null),(null),(null);
35 SELECT * FROM t1 ORDER BY c1;
36 DROP TABLE t1;
37 CREATE TABLE t1(c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
38 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
39 DELETE FROM t1 WHERE c1 >= 3;
40 SELECT * FROM t1 ORDER BY c1;
41 INSERT INTO t1 VALUES (null),(null),(null);
42 SELECT * FROM t1 ORDER BY c1;
43 DELETE FROM t1 ;
44 SELECT * FROM t1 ORDER BY c1;
45 INSERT INTO t1 VALUES (null),(null),(null);
46 SELECT * FROM t1 ORDER BY c1;
47 DROP TABLE t1;
48 CREATE TABLE t1(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY);
49 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
50 DELETE FROM t1 WHERE c1 >= 3;
51 SELECT * FROM t1 ORDER BY c1;
52 INSERT INTO t1 VALUES (null),(null),(null);
53 SELECT * FROM t1 ORDER BY c1;
54 DELETE FROM t1 ;
55 SELECT * FROM t1 ORDER BY c1;
56 INSERT INTO t1 VALUES (null),(null),(null);
57 SELECT * FROM t1 ORDER BY c1;
58 DROP TABLE t1;
59 CREATE TABLE t1(c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
60 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
61 DELETE FROM t1 WHERE c1 >= 3;
62 SELECT * FROM t1 ORDER BY c1;
63 INSERT INTO t1 VALUES (null),(null),(null);
64 SELECT * FROM t1 ORDER BY c1;
65 DELETE FROM t1 ;
66 SELECT * FROM t1 ORDER BY c1;
67 INSERT INTO t1 VALUES (null),(null),(null);
68 SELECT * FROM t1 ORDER BY c1;
69 DROP TABLE t1;
70