diff options
author | Sergei Golubchik <sergii@pisem.net> | 2010-05-11 16:49:23 +0200 |
---|---|---|
committer | Sergei Golubchik <sergii@pisem.net> | 2010-05-11 16:49:23 +0200 |
commit | a3e8ae12805fb85a0b175b3ccbce36da62f8fdc4 (patch) | |
tree | b72575d93228cb5bf4caa6c25559b3abef8e0d71 /mysql-test/r/partition_example.result | |
parent | 8792d8a3acd58b9417ee991166d76ba17f517836 (diff) | |
download | mariadb-git-a3e8ae12805fb85a0b175b3ccbce36da62f8fdc4.tar.gz |
A temporary solution to make CREATE TABLE attributes
to work when a table is partitioned
Diffstat (limited to 'mysql-test/r/partition_example.result')
-rw-r--r-- | mysql-test/r/partition_example.result | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/mysql-test/r/partition_example.result b/mysql-test/r/partition_example.result new file mode 100644 index 00000000000..2129eea0818 --- /dev/null +++ b/mysql-test/r/partition_example.result @@ -0,0 +1,31 @@ +install plugin example soname 'ha_example.so'; +create table t1 (a int not null) +engine=example +partition by list (a) +(partition p0 values in (1), partition p1 values in (2)); +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL +) ENGINE=EXAMPLE DEFAULT CHARSET=latin1 +/*!50100 PARTITION BY LIST (a) +(PARTITION p0 VALUES IN (1) ENGINE = EXAMPLE, + PARTITION p1 VALUES IN (2) ENGINE = EXAMPLE) */ +drop table t1; +create table t1 (a int not null) +engine=example ull=12340 +partition by list (a) +(partition p0 values in (1), partition p1 values in (2)); +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL +) ENGINE=EXAMPLE DEFAULT CHARSET=latin1 `ull`=12340 +/*!50100 PARTITION BY LIST (a) +(PARTITION p0 VALUES IN (1) ENGINE = EXAMPLE, + PARTITION p1 VALUES IN (2) ENGINE = EXAMPLE) */ +drop table t1; +select 1; +1 +1 +uninstall plugin example; |