summaryrefslogtreecommitdiff
path: root/mysql-test/t/partition_range.test
diff options
context:
space:
mode:
authorunknown <mikael/pappa@dator5.(none)>2006-10-02 15:52:29 -0400
committerunknown <mikael/pappa@dator5.(none)>2006-10-02 15:52:29 -0400
commit93f4daf1b45f425057138b575caed00d489d002b (patch)
tree4bca4ca32b026e15672d4d0284b012a03a358a81 /mysql-test/t/partition_range.test
parentd8e3aebedec0281c8d8fe14820b7c06663b35ed1 (diff)
downloadmariadb-git-93f4daf1b45f425057138b575caed00d489d002b.tar.gz
BUG#18198: Partition function handling
Fixes of after review fixes mysql-test/r/partition_hash.result: Fixed test cases mysql-test/r/partition_range.result: Fixed test cases mysql-test/t/partition_range.test: Fixed test cases sql/ha_ndbcluster.cc: Fixed error printout to avoid complex character set code in print_error sql/ha_partition.cc: Fixed error printout to avoid complex character set code in print_error sql/partition_info.cc: Fixed error printout to avoid complex character set code in print_error sql/partition_info.h: Fixed error printout to avoid complex character set code in print_error sql/sql_partition.cc: indendentation fix
Diffstat (limited to 'mysql-test/t/partition_range.test')
-rw-r--r--mysql-test/t/partition_range.test12
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/t/partition_range.test b/mysql-test/t/partition_range.test
index ead971c189e..84f67febe8b 100644
--- a/mysql-test/t/partition_range.test
+++ b/mysql-test/t/partition_range.test
@@ -14,41 +14,41 @@ 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));
+(partition p0 values less than (2), partition p1 values less than (400));
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));
+(partition p0 values less than (2), partition p1 values less than (400));
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));
+(partition p0 values less than (2), partition p1 values less than (400));
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));
+(partition p0 values less than (2), partition p1 values less than (400));
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));
+(partition p0 values less than (2), partition p1 values less than (400));
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));
+(partition p0 values less than (2), partition p1 values less than (400));
insert into t1 values ('a ', 'b ', 2),('a','b', 3);
drop table t1;