Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
3 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
4 TRUNCATE t1 ;
5 SELECT * FROM t1 ORDER BY c1;
6 c1
7 DROP TABLE t1;
8 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
9 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
10 TRUNCATE t1 ;
11 SELECT * FROM t1 ORDER BY c1;
12 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 c1
19 DROP TABLE t1;
20 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
21 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
22 TRUNCATE t1 ;
23 SELECT * FROM t1 ORDER BY c1;
24 c1
25 DROP TABLE t1;
26 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
27 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
28 TRUNCATE TABLE t1 ;
29 SELECT * FROM t1 ORDER BY c1;
30 c1
31 DROP TABLE t1;
32 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
33 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
34 TRUNCATE TABLE t1 ;
35 SELECT * FROM t1 ORDER BY c1;
36 c1
37 DROP TABLE t1;
38 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
39 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
40 TRUNCATE TABLE t1 ;
41 SELECT * FROM t1 ORDER BY c1;
42 c1
43 DROP TABLE t1;
44 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
45 INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
46 TRUNCATE TABLE t1 ;
47 SELECT * FROM t1 ORDER BY c1;
48 c1
49 DROP TABLE t1;