From 417c38db9cf5d94409cbc50f4e2b87345a915e58 Mon Sep 17 00:00:00 2001 From: unknown Date: Sat, 30 Sep 2006 17:38:15 -0400 Subject: BUG#18198: Partition function handling Review fixes mysql-test/r/partition_range.result: New test cases mysql-test/t/partition_hash.test: New test cases mysql-test/t/partition_range.test: New test cases sql/item.h: Review fixes sql/partition_info.cc: Review fixes sql/sql_partition.cc: Review fixes --- mysql-test/r/partition_range.result | 34 ++++++++++++++++++++++++++++++++++ 1 file changed, 34 insertions(+) (limited to 'mysql-test/r/partition_range.result') diff --git a/mysql-test/r/partition_range.result b/mysql-test/r/partition_range.result index 2fa40b44815..c8380446f44 100644 --- a/mysql-test/r/partition_range.result +++ b/mysql-test/r/partition_range.result @@ -1,4 +1,38 @@ drop table if exists t1; +create table t1 (a varchar(10) charset latin1 collate latin1_bin, b int) +partition by range (length(a) * b) +(partition p0 values less than (2), partition p1 values less than (10)); +insert into t1 values ('a ', 2),('a',3); +drop table t1; +create table t1 (a varchar(10) charset latin1 collate latin1_bin, b int) +partition by range (b* length(a) * b) +(partition p0 values less than (2), partition p1 values less than (10)); +insert into t1 values ('a ', 2),('a',3); +drop table t1; +create table t1 (a varchar(10) charset latin1 collate latin1_bin, +b varchar(10) charset latin1 collate latin1_bin) +partition by range (length(b) * length(a)) +(partition p0 values less than (2), partition p1 values less than (10)); +insert into t1 values ('a ', 'b '),('a','b'); +drop table t1; +create table t1 (a varchar(10) charset latin1 collate latin1_bin, +b varchar(10) charset latin1 collate latin1_bin) +partition by range (length(a) * length(b)) +(partition p0 values less than (2), partition p1 values less than (10)); +insert into t1 values ('a ', 'b '),('a','b'); +drop table t1; +create table t1 (a varchar(10) charset latin1 collate latin1_bin, +b varchar(10) charset latin1 collate latin1_bin, c int) +partition by range (length(a) * c) +(partition p0 values less than (2), partition p1 values less than (10)); +insert into t1 values ('a ', 'b ', 2),('a','b', 3); +drop table t1; +create table t1 (a varchar(10) charset latin1 collate latin1_bin, +b varchar(10) charset latin1 collate latin1_bin, c int) +partition by range (c * length(a)) +(partition p0 values less than (2), partition p1 values less than (10)); +insert into t1 values ('a ', 'b ', 2),('a','b', 3); +drop table t1; create table t1 (a int unsigned) partition by range (a) (partition pnull values less than (0), -- cgit v1.2.1