Debian Codegraph @

mysql-test/suite/parts/special_tests/r/partition_windows.result

raw
1 # Get available drive letters on this host (must be at least two).
2 # Bring the names into variables by sourcing the generated script.
3 # The tmp script is not needed anymore, delete it.
4 # Create build paths.
5 # Create the target directories. This will fail e.g.
6 # if the directories exist already.
7 # restart: --innodb-directories=PATH_1;PATH_2;PATH_3
8 CREATE TABLE t1 (
9 c1 int unsigned NOT NULL AUTO_INCREMENT,
10 c2 varchar(30) NOT NULL,
11 c3 smallint unsigned DEFAULT NULL,
12 PRIMARY KEY (c1)
13 )
14 PARTITION BY HASH(c1)(
15 PARTITION p0
16 DATA DIRECTORY = 'PATH_1',
17 PARTITION p1,
18 PARTITION p2
19 DATA DIRECTORY = 'PATH_2'
20 );
21 INSERT INTO t1 VALUES (NULL, "first", 1);
22 INSERT INTO t1 VALUES (NULL, "second", 2);
23 INSERT INTO t1 VALUES (NULL, "third", 3);
24 SHOW CREATE TABLE t1;
25 Table Create Table
26 t1 CREATE TABLE `t1` (
27 `c1` int unsigned NOT NULL AUTO_INCREMENT,
28 `c2` varchar(30) NOT NULL,
29 `c3` smallint unsigned DEFAULT NULL,
30 PRIMARY KEY (`c1`)
31 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
32 /*!50100 PARTITION BY HASH (`c1`)
33 (PARTITION p0 DATA DIRECTORY = 'PATH_1/' ENGINE = InnoDB,
34 PARTITION p1 ENGINE = InnoDB,
35 PARTITION p2 DATA DIRECTORY = 'PATH_2/' ENGINE = InnoDB) */
36 ALTER TABLE t1 ADD PARTITION (PARTITION p3 DATA DIRECTORY = 'PATH_3');
37 INSERT INTO t1 VALUES (NULL, "last", 4);
38 SHOW CREATE TABLE t1;
39 Table Create Table
40 t1 CREATE TABLE `t1` (
41 `c1` int unsigned NOT NULL AUTO_INCREMENT,
42 `c2` varchar(30) NOT NULL,
43 `c3` smallint unsigned DEFAULT NULL,
44 PRIMARY KEY (`c1`)
45 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
46 /*!50100 PARTITION BY HASH (`c1`)
47 (PARTITION p0 DATA DIRECTORY = 'PATH_1/' ENGINE = InnoDB,
48 PARTITION p1 ENGINE = InnoDB,
49 PARTITION p2 DATA DIRECTORY = 'PATH_2/' ENGINE = InnoDB,
50 PARTITION p3 DATA DIRECTORY = 'PATH_3' ENGINE = InnoDB) */
51 DROP TABLE t1;
52 # Clean up: Delete target directories.
53 # restart: