diff options
| author | mikael@c-0409e253.1238-1-64736c10.cust.bredbandsbolaget.se <> | 2006-06-15 16:00:54 -0400 |
|---|---|---|
| committer | mikael@c-0409e253.1238-1-64736c10.cust.bredbandsbolaget.se <> | 2006-06-15 16:00:54 -0400 |
| commit | c8da9ebda34cd00e2a16dda6a80ce3f0c87671ee (patch) | |
| tree | fbc9333153633d7302f904e7c59cb89c9ae0935d /mysql-test | |
| parent | 32c45f92099bae2980904eb4498ed351e9a5654d (diff) | |
| parent | b631659c6ced0637446f12458a1df0939581ff2b (diff) | |
| download | mariadb-git-c8da9ebda34cd00e2a16dda6a80ce3f0c87671ee.tar.gz | |
Merge c-0409e253.1238-1-64736c10.cust.bredbandsbolaget.se:/home/pappa/clean-mysql-5.1
into c-0409e253.1238-1-64736c10.cust.bredbandsbolaget.se:/home/pappa/bug20397
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/partition_error.result | 24 | ||||
| -rw-r--r-- | mysql-test/t/partition_error.test | 20 |
2 files changed, 44 insertions, 0 deletions
diff --git a/mysql-test/r/partition_error.result b/mysql-test/r/partition_error.result index 0ab65f669ac..39f0cf9ca55 100644 --- a/mysql-test/r/partition_error.result +++ b/mysql-test/r/partition_error.result @@ -1,4 +1,28 @@ drop table if exists t1; +create table t1 (a int) +engine = x +partition by key (a); +Warnings: +Error 1286 Unknown table engine 'x' +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 PARTITION BY KEY (a) +drop table t1; +create table t1 (a int) +engine = innodb +partition by list (a) +(partition p0 values in (0)); +alter table t1 engine = x; +Warnings: +Error 1286 Unknown table engine 'x' +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=latin1 PARTITION BY LIST (a) (PARTITION p0 VALUES IN (0) ENGINE = InnoDB) +drop table t1; partition by list (a) partitions 3 (partition x1 values in (1,2,9,4) tablespace ts1, diff --git a/mysql-test/t/partition_error.test b/mysql-test/t/partition_error.test index 19e43372670..076c5c5773b 100644 --- a/mysql-test/t/partition_error.test +++ b/mysql-test/t/partition_error.test @@ -9,6 +9,24 @@ drop table if exists t1; --enable_warnings # +# Bug 20397: Partitions: Crash when using non-existing engine +# +create table t1 (a int) +engine = x +partition by key (a); +show create table t1; +drop table t1; + +create table t1 (a int) +engine = innodb +partition by list (a) +(partition p0 values in (0)); + +alter table t1 engine = x; +show create table t1; +drop table t1; + +# # Partition by key stand-alone error # --error 1064 @@ -779,3 +797,5 @@ partition by range (a + (select count(*) from t1)) -- error ER_PARTITION_FUNC_NOT_ALLOWED_ERROR create table t1 (a char(10)) partition by hash (extractvalue(a,'a')); + + |