summaryrefslogtreecommitdiff
path: root/mysql-test/r/partition_range.result
diff options
context:
space:
mode:
authorunknown <mikael/pappa@dator5.(none)>2006-09-08 03:18:05 -0400
committerunknown <mikael/pappa@dator5.(none)>2006-09-08 03:18:05 -0400
commitd710ccf82c12e8751a16cd7f5a3a01451658c383 (patch)
tree9e8cd806d5b07d30947da99befe0abab9c389be6 /mysql-test/r/partition_range.result
parent8b50dee746acba1e35e32d99f14a2fff029aa1dd (diff)
downloadmariadb-git-d710ccf82c12e8751a16cd7f5a3a01451658c383.tar.gz
Rearranged test cases, move InnoDB test cases to partition_innodb
Diffstat (limited to 'mysql-test/r/partition_range.result')
-rw-r--r--mysql-test/r/partition_range.result10
1 files changed, 0 insertions, 10 deletions
diff --git a/mysql-test/r/partition_range.result b/mysql-test/r/partition_range.result
index be88d9f6639..9812c80040b 100644
--- a/mysql-test/r/partition_range.result
+++ b/mysql-test/r/partition_range.result
@@ -1,14 +1,4 @@
drop table if exists t1;
-create table t1 (a date)
-engine = innodb
-partition by range (year(a))
-(partition p0 values less than (2006),
-partition p1 values less than (2007));
-explain partitions select * from t1
-where a between '2006-01-01' and '2007-06-01';
-id select_type table partitions type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 p1 ALL NULL NULL NULL NULL 2 Using where
-drop table t1;
create table t1 (a int unsigned)
partition by range (a)
(partition pnull values less than (0),