Debian Codegraph @

mysql-test/suite/ndb/r/ndb_restore_compat_partitioning.result

raw
1 use test;
2 show create table standard;
3 Table Create Table
4 standard CREATE TABLE `standard` (
5 `a` int NOT NULL,
6 `b` int DEFAULT NULL,
7 PRIMARY KEY (`a`)
8 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
9 show create table maxrows_low;
10 Table Create Table
11 maxrows_low CREATE TABLE `maxrows_low` (
12 `a` int NOT NULL,
13 `b` int DEFAULT NULL,
14 PRIMARY KEY (`a`)
15 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 MAX_ROWS=10000000
16 show create table maxrows_high;
17 Table Create Table
18 maxrows_high CREATE TABLE `maxrows_high` (
19 `a` int NOT NULL,
20 `b` int DEFAULT NULL,
21 PRIMARY KEY (`a`)
22 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 MAX_ROWS=1000000000
23 show create table bykeycount;
24 Table Create Table
25 bykeycount CREATE TABLE `bykeycount` (
26 `a` int NOT NULL,
27 `b` int DEFAULT NULL,
28 PRIMARY KEY (`a`)
29 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
30 /*!50100 PARTITION BY KEY (a)
31 PARTITIONS 8 */
32 show create table bykeycount_big;
33 Table Create Table
34 bykeycount_big CREATE TABLE `bykeycount_big` (
35 `a` int NOT NULL,
36 `b` int DEFAULT NULL,
37 PRIMARY KEY (`a`)
38 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
39 /*!50100 PARTITION BY KEY (a)
40 PARTITIONS 32 */
41 show create table another;
42 Table Create Table
43 another CREATE TABLE `another` (
44 `a` int NOT NULL,
45 `b` int DEFAULT NULL,
46 PRIMARY KEY (`a`)
47 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
48 /*!50100 PARTITION BY LINEAR KEY (a) */
49 show tables;
50 Tables_in_test
51 another
52 bykeycount
53 bykeycount_big
54 maxrows_high
55 maxrows_low
56 standard
57 drop table standard;
58 drop table maxrows_low;
59 drop table maxrows_high;
60 drop table bykeycount;
61 drop table bykeycount_big;
62 drop table another;