diff options
| author | Mattias Jonsson <mattias.jonsson@sun.com> | 2009-12-21 11:38:31 +0100 |
|---|---|---|
| committer | Mattias Jonsson <mattias.jonsson@sun.com> | 2009-12-21 11:38:31 +0100 |
| commit | 287dfc146949af0bd28e202b0086e93ceeb1d77a (patch) | |
| tree | 43091cab7f019c2defa4d9bcf1d8e8515da10afc /mysql-test/t/partition_column.test | |
| parent | c736665e43995327cae3ea417c8abc815ea925fc (diff) | |
| download | mariadb-git-287dfc146949af0bd28e202b0086e93ceeb1d77a.tar.gz | |
Bug#48737: Partitions: search fails with ucs2
Recommit of patch:
http://lists.mysql.com/commits/91400
Test case only (code part was pushes as bug-49028)
mysql-test/r/partition_column.result:
Bug#48737: Partitions: search fails with ucs2
added test case
mysql-test/t/partition_column.test:
Bug#48737: Partitions: search fails with ucs2
Added result
Diffstat (limited to 'mysql-test/t/partition_column.test')
| -rw-r--r-- | mysql-test/t/partition_column.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/partition_column.test b/mysql-test/t/partition_column.test index 9e47b94b036..a0e944ceb09 100644 --- a/mysql-test/t/partition_column.test +++ b/mysql-test/t/partition_column.test @@ -24,6 +24,23 @@ partition by range columns (a,b,c) partition p1 values less than (1, maxvalue, maxvalue)); # +# BUG#48737, Search fails with ucs2 +# +create table t1 (a varchar(5) character set ucs2 collate ucs2_bin) +partition by range columns (a) +(partition p0 values less than (0x0041)); +insert into t1 values (0x00410000); +select hex(a) from t1 where a like 'A_'; +explain partitions select hex(a) from t1 where a like 'A_'; +alter table t1 remove partitioning; +select hex(a) from t1 where a like 'A_'; +create index a on t1 (a); +select hex(a) from t1 where a like 'A_'; +insert into t1 values ('A_'); +select hex(a) from t1; +drop table t1; + +# # BUG#48161, Delivering too few records using collate syntax with partitions # # Test case from BUG#48447 with some extension |