diff options
| author | unknown <mikael@c-0409e253.1238-1-64736c10.cust.bredbandsbolaget.se> | 2006-06-13 22:46:38 -0400 |
|---|---|---|
| committer | unknown <mikael@c-0409e253.1238-1-64736c10.cust.bredbandsbolaget.se> | 2006-06-13 22:46:38 -0400 |
| commit | cb0f1641fe4f746508e7715fa9417c6afa19e9cc (patch) | |
| tree | 33c9c4231ce76399f9bd76b20aff2f100dffb361 /mysql-test/r/partition_error.result | |
| parent | b19c1896adea1166adb8e80552ac3abfa7642205 (diff) | |
| download | mariadb-git-cb0f1641fe4f746508e7715fa9417c6afa19e9cc.tar.gz | |
BUG#20397: Crash at ALTER TABLE t1 engine = x; for partitioned table
mysql-test/r/partition_error.result:
New test cases
mysql-test/t/partition_error.test:
New test cases
sql/sql_table.cc:
ALTER TABLE t1 engine = x;
will behave exactly like
ALTER TABLE t1;
See no reason why one should change handler to something not specified in query when
there is already something one is attached to.
Diffstat (limited to 'mysql-test/r/partition_error.result')
| -rw-r--r-- | mysql-test/r/partition_error.result | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/partition_error.result b/mysql-test/r/partition_error.result index a7ca3d9b2fa..a4866209ee6 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, |