summaryrefslogtreecommitdiff
path: root/mysql-test/t/partition_column_prune.test
diff options
context:
space:
mode:
authorMikael Ronstrom <mikael@mysql.com>2009-10-21 12:40:21 +0200
committerMikael Ronstrom <mikael@mysql.com>2009-10-21 12:40:21 +0200
commitbbd922b09c94bafb18e583a00865750164358736 (patch)
treef8665cdbc5f804477667c1ef89f27f0de619b382 /mysql-test/t/partition_column_prune.test
parentaaa79d9530e64bb092bb994312b7e490d16b9eef (diff)
downloadmariadb-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.test34
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),