Debian Codegraph @

mysql-test/suite/ndb_ddl/partition_tablespace_distribution.result

raw
1 CREATE LOGFILE GROUP lg1
2 ADD UNDOFILE 'undofile.dat'
3 INITIAL_SIZE 16M
4 UNDO_BUFFER_SIZE = 1M
5 ENGINE NDB;
6 CREATE TABLESPACE ts1
7 ADD DATAFILE 'ts1_datafile.dat'
8 USE LOGFILE GROUP lg1
9 INITIAL_SIZE 64M
10 ENGINE NDB;
11 CREATE TABLESPACE ts2
12 ADD DATAFILE 'ts2_datafile.dat'
13 USE LOGFILE GROUP lg1
14 INITIAL_SIZE 64M
15 ENGINE NDB;
16 CREATE TABLE t1 (
17 a INT PRIMARY KEY
18 )
19 ENGINE NDB
20 PARTITION BY RANGE (a)
21 PARTITIONS 2 (
22 PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
23 PARTITION p2 VALUES LESS THAN MAXVALUE TABLESPACE ts2);
24 SHOW CREATE TABLE t1;
25 Table Create Table
26 t1 CREATE TABLE `t1` (
27 `a` int NOT NULL,
28 PRIMARY KEY (`a`)
29 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
30 /*!50100 PARTITION BY RANGE (`a`)
31 (PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = ndbcluster,
32 PARTITION p2 VALUES LESS THAN MAXVALUE TABLESPACE = `ts2` ENGINE = ndbcluster) */
33 INSERT INTO t1 VALUES (1),(10);
34 SELECT * FROM t1;
35 a
36 1
37 10
38 SHOW CREATE TABLE t1;
39 Table Create Table
40 t1 CREATE TABLE `t1` (
41 `a` int NOT NULL,
42 PRIMARY KEY (`a`)
43 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
44 /*!50100 PARTITION BY RANGE (`a`)
45 (PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = ndbcluster,
46 PARTITION p2 VALUES LESS THAN MAXVALUE TABLESPACE = `ts2` ENGINE = ndbcluster) */
47 SHOW CREATE TABLE t1;
48 Table Create Table
49 t1 CREATE TABLE `t1` (
50 `a` int NOT NULL,
51 PRIMARY KEY (`a`)
52 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
53 /*!50100 PARTITION BY RANGE (`a`)
54 (PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = ndbcluster,
55 PARTITION p2 VALUES LESS THAN MAXVALUE TABLESPACE = `ts2` ENGINE = ndbcluster) */
56 DROP TABLE t1;
57 ALTER TABLESPACE ts1
58 DROP DATAFILE 'ts1_datafile.dat';
59 DROP TABLESPACE ts1;
60 ALTER TABLESPACE ts2
61 DROP DATAFILE 'ts2_datafile.dat';
62 DROP TABLESPACE ts2;
63 DROP LOGFILE GROUP lg1
64 ENGINE NDB;