summaryrefslogtreecommitdiff
path: root/mysql-test/r/partition.result
diff options
context:
space:
mode:
authorunknown <mikael@dator6.(none)>2008-02-07 16:01:20 +0100
committerunknown <mikael@dator6.(none)>2008-02-07 16:01:20 +0100
commit53a8941b470a770a49aabea1e965cdc01201c898 (patch)
tree3acbeb75e906f9b17846c2b29445503b3542b795 /mysql-test/r/partition.result
parentbb091abb145f89e2332a5b49cbc221793bce3452 (diff)
parent629b355b4a2bc051e538244410edc1e3d0933a65 (diff)
downloadmariadb-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.result28
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;