Debian Codegraph @

mysql-test/suite/ndb_ddl/partition_tablespace_distribution.test

raw
1 --source connect.inc
2
3 CREATE LOGFILE GROUP lg1
4 ADD UNDOFILE 'undofile.dat'
5 INITIAL_SIZE 16M
6 UNDO_BUFFER_SIZE = 1M
7 ENGINE NDB;
8
9 CREATE TABLESPACE ts1
10 ADD DATAFILE 'ts1_datafile.dat'
11 USE LOGFILE GROUP lg1
12 INITIAL_SIZE 64M
13 ENGINE NDB;
14
15 CREATE TABLESPACE ts2
16 ADD DATAFILE 'ts2_datafile.dat'
17 USE LOGFILE GROUP lg1
18 INITIAL_SIZE 64M
19 ENGINE NDB;
20
21 CREATE TABLE t1 (
22 a INT PRIMARY KEY
23 )
24 ENGINE NDB
25 PARTITION BY RANGE (a)
26 PARTITIONS 2 (
27 PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
28 PARTITION p2 VALUES LESS THAN MAXVALUE TABLESPACE ts2);
29
30 SHOW CREATE TABLE t1;
31
32 INSERT INTO t1 VALUES (1),(10);
33
34 --connection mysqld2
35 --sorted_result
36 SELECT * FROM t1;
37
38 SHOW CREATE TABLE t1;
39
40 --connection mysqld5
41 SHOW CREATE TABLE t1;
42
43 --connection mysqld1
44 DROP TABLE t1;
45 ALTER TABLESPACE ts1
46 DROP DATAFILE 'ts1_datafile.dat';
47 DROP TABLESPACE ts1;
48 ALTER TABLESPACE ts2
49 DROP DATAFILE 'ts2_datafile.dat';
50 DROP TABLESPACE ts2;
51 DROP LOGFILE GROUP lg1
52 ENGINE NDB;