diff options
author | unknown <mikael@dator6.(none)> | 2008-02-07 16:01:20 +0100 |
---|---|---|
committer | unknown <mikael@dator6.(none)> | 2008-02-07 16:01:20 +0100 |
commit | 53a8941b470a770a49aabea1e965cdc01201c898 (patch) | |
tree | 3acbeb75e906f9b17846c2b29445503b3542b795 /mysql-test/r/partition.result | |
parent | bb091abb145f89e2332a5b49cbc221793bce3452 (diff) | |
parent | 629b355b4a2bc051e538244410edc1e3d0933a65 (diff) | |
download | mariadb-git-53a8941b470a770a49aabea1e965cdc01201c898.tar.gz |
Merge dator6.(none):/home/mikael/mysql_clones/bug33182
into dator6.(none):/home/mikael/mysql_clones/mysql-5.1-engines
mysql-test/r/partition.result:
Auto merged
mysql-test/t/partition.test:
Auto merged
Diffstat (limited to 'mysql-test/r/partition.result')
-rw-r--r-- | mysql-test/r/partition.result | 28 |
1 files changed, 0 insertions, 28 deletions
diff --git a/mysql-test/r/partition.result b/mysql-test/r/partition.result index d3275cec922..a571708dea8 100644 --- a/mysql-test/r/partition.result +++ b/mysql-test/r/partition.result @@ -47,15 +47,6 @@ partition by key(a) partitions 1e+300; ERROR 42000: Only integers allowed as number here near '1e+300' at line 3 create table t1 (a int) -partition by key (a) -(partition p0 DATA DIRECTORY 'part-data' INDEX DIRECTORY 'part-data'); -ERROR 42000: Incorrect table name 'part-data' -create table t1 (a int) -partition by key (a) -(partition p0, -partition p1 DATA DIRECTORY 'part-data' INDEX DIRECTORY 'part-data'); -ERROR 42000: Incorrect table name 'part-data' -create table t1 (a int) partition by list (a) (partition p0 values in (1)); create procedure pz() @@ -1210,25 +1201,6 @@ SELECT t2.id FROM t2 WHERE t2.id IN (SELECT id FROM t1 WHERE status = 'Verified' id 22589 drop table t1, t2; -set @org_mode=@@sql_mode; -set @@sql_mode='NO_DIR_IN_CREATE'; -select @@sql_mode; -@@sql_mode -NO_DIR_IN_CREATE -create table t1 (i int ) -partition by range (i) -( -partition p01 values less than (1000) -data directory='/not/existing' - index directory='/not/existing' -); -show create table t2; -Table Create Table -t2 CREATE TABLE `t2` ( - `i` int(11) DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (i) (PARTITION p01 VALUES LESS THAN (1000) ENGINE = MyISAM) */ -DROP TABLE t1, t2; -set @@sql_mode=@org_mode; create table t1 (c1 varchar(255),c2 tinyint,primary key(c1)) partition by key (c1) partitions 10 ; insert into t1 values ('aaa','1') on duplicate key update c2 = c2 + 1; |