Debian Codegraph @

mysql-test/suite/innodb/r/truncate.result

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