summaryrefslogtreecommitdiff
path: root/mysql-test/r/partition_range.result
diff options
context:
space:
mode:
authorMikael Ronstrom <mikael@mysql.com>2009-10-16 16:16:06 +0200
committerMikael Ronstrom <mikael@mysql.com>2009-10-16 16:16:06 +0200
commitc90669c4d423ba46f09aadde5ff6662e8a63a1c0 (patch)
treedf5230b4e7781d295ef1eb1cedbd289ee413a075 /mysql-test/r/partition_range.result
parent576dd76aa81787f71e038efd9e00713b7a44b3c5 (diff)
downloadmariadb-git-c90669c4d423ba46f09aadde5ff6662e8a63a1c0.tar.gz
Fixed removal of column_list keyword for VALUES part, retained for PARTITION BY RANGE/LIST COLUMN_LIST, not entirely working yet
Diffstat (limited to 'mysql-test/r/partition_range.result')
-rw-r--r--mysql-test/r/partition_range.result10
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/r/partition_range.result b/mysql-test/r/partition_range.result
index fc15665d698..00ada13ed13 100644
--- a/mysql-test/r/partition_range.result
+++ b/mysql-test/r/partition_range.result
@@ -78,12 +78,12 @@ partition by range column_list(a,b)
ERROR 42000: Inconsistency in usage of column lists for partitioning near '))' at line 3
create table t1 (a int, b char(20))
partition by range(a)
-(partition p0 values less than (column_list(1,"b")));
-ERROR HY000: Inconsistency in usage of column lists for partitioning
+(partition p0 values less than (1,"b"));
+ERROR HY000: Cannot have more than one value for this type of RANGE partitioning
create table t1 (a int, b char(20))
partition by range(a)
-(partition p0 values less than (column_list(1,"b")));
-ERROR HY000: Inconsistency in usage of column lists for partitioning
+(partition p0 values less than (1,"b"));
+ERROR HY000: Cannot have more than one value for this type of RANGE partitioning
create table t1 (a int, b char(20));
create global index inx on t1 (a,b)
partition by range (a)
@@ -91,7 +91,7 @@ partition by range (a)
drop table t1;
create table t1 (a int, b char(20))
partition by range column_list(b)
-(partition p0 values less than (column_list("b")));
+(partition p0 values less than ("b"));
drop table t1;
create table t1 (a int)
partition by range (a)