Debian Codegraph @

mysql-test/suite/innodb/t/truncate.test

raw
1
2 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
3 CREATE TABLESPACE ts2 ADD DATAFILE 'ts2.ibd';
4
5 CREATE TABLE t1 (
6 a INT NOT NULL,
7 PRIMARY KEY (a)
8 )
9 ENGINE=InnoDB TABLESPACE ts1;
10
11 CREATE TABLE t1p (
12 a INT NOT NULL,
13 PRIMARY KEY (a)
14 )
15 ENGINE=InnoDB
16 PARTITION BY RANGE (a)
17 PARTITIONS 2
18 (PARTITION P1 VALUES LESS THAN (2) TABLESPACE ts1,
19 PARTITION P2 VALUES LESS THAN (4) TABLESPACE ts2);
20
21 TRUNCATE TABLE t1;
22 TRUNCATE TABLE t1p;
23
24 ALTER TABLE t1p TRUNCATE PARTITION P2;
25
26 --replace_result #P #p
27 SELECT t.NAME, ts.NAME
28 FROM information_schema.innodb_tables t
29 LEFT JOIN information_schema.innodb_tablespaces ts
30 ON t.SPACE = ts.SPACE
31 WHERE t.NAME LIKE '%t1%' ORDER BY t.NAME;
32
33 DROP TABLE t1, t1p;
34 DROP TABLESPACE ts1;
35 DROP TABLESPACE ts2;
36
37
38 CREATE TABLE t1 (
39 a INT NOT NULL AUTO_INCREMENT,
40 b INT NOT NULL,
41 PRIMARY KEY (a)
42 )
43 ENGINE=InnoDB
44 PARTITION BY RANGE (a)
45 PARTITIONS 3
46 (PARTITION P1 VALUES LESS THAN (5),
47 PARTITION P2 VALUES LESS THAN (20),
48 PARTITION p3 VALUES LESS THAN MAXVALUE);
49
50 INSERT INTO t1 VALUES(0, 1), (0, 2), (0, 3), (0, 4), (0, 5), (0, 6), (0, 7);
51
52 SELECT max(a) AS `Expect 7` FROM t1;
53
54 ALTER TABLE t1 TRUNCATE PARTITION p2;
55
56 SELECT max(a) AS `Expect 4` FROM t1;
57
58 INSERT INTO t1 VALUES(0, 8);
59
60 SELECT max(a) AS `Expect 8` FROM t1;
61
62 DELETE FROM t1 WHERE a = 8;
63
64 ALTER TABLE t1 TRUNCATE PARTITION p1;
65
66 INSERT INTO t1 VALUES(0, 9);
67
68 SELECT max(a) AS `Expect 9` FROM t1;
69
70 ALTER TABLE t1 TRUNCATE PARTITION ALL;
71
72 INSERT INTO t1 VALUES(0, 9);
73
74 SELECT max(a) AS `Expect 1` FROM t1;
75
76 DROP TABLE t1;