diff options
author | Mikael Ronstrom <mikael@mysql.com> | 2009-10-21 12:40:21 +0200 |
---|---|---|
committer | Mikael Ronstrom <mikael@mysql.com> | 2009-10-21 12:40:21 +0200 |
commit | bbd922b09c94bafb18e583a00865750164358736 (patch) | |
tree | f8665cdbc5f804477667c1ef89f27f0de619b382 /mysql-test/t/partition_column_prune.test | |
parent | aaa79d9530e64bb092bb994312b7e490d16b9eef (diff) | |
download | mariadb-git-bbd922b09c94bafb18e583a00865750164358736.tar.gz |
Removed column_list and fixed all issues relating to this change
Diffstat (limited to 'mysql-test/t/partition_column_prune.test')
-rw-r--r-- | mysql-test/t/partition_column_prune.test | 34 |
1 files changed, 17 insertions, 17 deletions
diff --git a/mysql-test/t/partition_column_prune.test b/mysql-test/t/partition_column_prune.test index 52267a66b65..ec8ce725b34 100644 --- a/mysql-test/t/partition_column_prune.test +++ b/mysql-test/t/partition_column_prune.test @@ -9,7 +9,7 @@ drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; create table t1 (a char, b char, c char) partition by range column_list(a,b,c) -( partition p0 values less than (column_list('a','b','c'))); +( partition p0 values less than ('a','b','c')); insert into t1 values ('a', NULL, 'd'); explain partitions select * from t1 where a = 'a' AND c = 'd'; select * from t1 where a = 'a' AND c = 'd'; @@ -17,13 +17,13 @@ drop table t1; ## COLUMN_LIST partition pruning tests create table t1 (a int not null) partition by range column_list(a) ( - partition p0 values less than (column_list(10)), - partition p1 values less than (column_list(20)), - partition p2 values less than (column_list(30)), - partition p3 values less than (column_list(40)), - partition p4 values less than (column_list(50)), - partition p5 values less than (column_list(60)), - partition p6 values less than (column_list(70)) + partition p0 values less than (10), + partition p1 values less than (20), + partition p2 values less than (30), + partition p3 values less than (40), + partition p4 values less than (50), + partition p5 values less than (60), + partition p6 values less than (70) ); insert into t1 values (5),(15),(25),(35),(45),(55),(65); insert into t1 values (5),(15),(25),(35),(45),(55),(65); @@ -47,17 +47,17 @@ drop table t1, t2; create table t1 (a int not null, b int not null ) partition by range column_list(a,b) ( - partition p01 values less than (column_list(2,10)), - partition p02 values less than (column_list(2,20)), - partition p03 values less than (column_list(2,30)), + partition p01 values less than (2,10), + partition p02 values less than (2,20), + partition p03 values less than (2,30), - partition p11 values less than (column_list(4,10)), - partition p12 values less than (column_list(4,20)), - partition p13 values less than (column_list(4,30)), + partition p11 values less than (4,10), + partition p12 values less than (4,20), + partition p13 values less than (4,30), - partition p21 values less than (column_list(6,10)), - partition p22 values less than (column_list(6,20)), - partition p23 values less than (column_list(6,30)) + partition p21 values less than (6,10), + partition p22 values less than (6,20), + partition p23 values less than (6,30) ); insert into t1 values (2,5), (2,15), (2,25), |