Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
5 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
6 TRUNCATE t1 ;
7 SELECT * FROM t1 ORDER BY c1;
8 DROP TABLE t1;
9 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
10 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
11 TRUNCATE t1 ;
12 SELECT * FROM t1 ORDER BY c1;
13 DROP TABLE t1;
14 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
15 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
16 TRUNCATE t1 ;
17 SELECT * FROM t1 ORDER BY c1;
18 DROP TABLE t1;
19 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
20 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
21 TRUNCATE t1 ;
22 SELECT * FROM t1 ORDER BY c1;
23 DROP TABLE t1;
24 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
25 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
26 TRUNCATE TABLE t1 ;
27 SELECT * FROM t1 ORDER BY c1;
28 DROP TABLE t1;
29 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
30 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
31 TRUNCATE TABLE t1 ;
32 SELECT * FROM t1 ORDER BY c1;
33 DROP TABLE t1;
34 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
35 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
36 TRUNCATE TABLE t1 ;
37 SELECT * FROM t1 ORDER BY c1;
38 DROP TABLE t1;
39 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
40 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
41 TRUNCATE TABLE t1 ;
42 SELECT * FROM t1 ORDER BY c1;
43 DROP TABLE t1;
44