Debian Codegraph @

mysql-test/suite/storage_engine/parts/truncate_table.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY HASH(a) PARTITIONS 2;
3 TRUNCATE TABLE t1;
4 INSERT INTO t1 (a,b) VALUES (1,'a'), (2,'b'), (3,'c');
5 TRUNCATE TABLE t1;
6 SELECT a,b FROM t1;
7 a b
8 DROP TABLE t1;
9 CREATE TABLE t1 (a <INT_COLUMN> KEY AUTO_INCREMENT, c <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY HASH(a) PARTITIONS 2;
10 SHOW CREATE TABLE t1;
11 Table Create Table
12 t1 CREATE TABLE `t1` (
13 `a` int(11) NOT NULL AUTO_INCREMENT,
14 `c` char(8) DEFAULT NULL,
15 PRIMARY KEY (`a`)
16 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
17 PARTITION BY HASH (`a`)
18 PARTITIONS 2
19 INSERT INTO t1 (c) VALUES ('a'),('b'),('c');
20 SHOW CREATE TABLE t1;
21 Table Create Table
22 t1 CREATE TABLE `t1` (
23 `a` int(11) NOT NULL AUTO_INCREMENT,
24 `c` char(8) DEFAULT NULL,
25 PRIMARY KEY (`a`)
26 ) ENGINE=<STORAGE_ENGINE> AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
27 PARTITION BY HASH (`a`)
28 PARTITIONS 2
29 TRUNCATE TABLE t1;
30 SHOW CREATE TABLE t1;
31 Table Create Table
32 t1 CREATE TABLE `t1` (
33 `a` int(11) NOT NULL AUTO_INCREMENT,
34 `c` char(8) DEFAULT NULL,
35 PRIMARY KEY (`a`)
36 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1
37 PARTITION BY HASH (`a`)
38 PARTITIONS 2
39 INSERT INTO t1 (c) VALUES ('d');
40 SHOW CREATE TABLE t1;
41 Table Create Table
42 t1 CREATE TABLE `t1` (
43 `a` int(11) NOT NULL AUTO_INCREMENT,
44 `c` char(8) DEFAULT NULL,
45 PRIMARY KEY (`a`)
46 ) ENGINE=<STORAGE_ENGINE> AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
47 PARTITION BY HASH (`a`)
48 PARTITIONS 2
49 SELECT a,c FROM t1;
50 a c
51 1 d
52 DROP TABLE t1;
53 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY HASH(a) PARTITIONS 2;
54 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(2,'d'),(4,'e'),(100,'f'),(101,'g');
55 ALTER TABLE t1 TRUNCATE PARTITION p0;
56 SELECT a,b FROM t1;
57 a b
58 1 a
59 101 g
60 3 c
61 EXPLAIN PARTITIONS SELECT a,b FROM t1;
62 id select_type table partitions type possible_keys key key_len ref rows Extra
63 1 SIMPLE t1 p0,p1 # # # # # #
64 INSERT INTO t1 (a,b) VALUES (1,'a'), (2,'b'), (3,'c');
65 ALTER TABLE t1 TRUNCATE PARTITION ALL;
66 SELECT a,b FROM t1;
67 a b
68 DROP TABLE t1;