diff options
author | Mikael Ronstrom <mikael@mysql.com> | 2009-11-05 15:42:03 +0100 |
---|---|---|
committer | Mikael Ronstrom <mikael@mysql.com> | 2009-11-05 15:42:03 +0100 |
commit | 09580562a2f5e34583fb4d4448c908c1c0802882 (patch) | |
tree | 2d7883b6f6ed985beb703f0fd5c5e8207e7fce20 /mysql-test/r/partition_innodb.result | |
parent | 06bfaf21f2965539ab76fed3338b3cb0089adc57 (diff) | |
download | mariadb-git-09580562a2f5e34583fb4d4448c908c1c0802882.tar.gz |
BUG#48447, BUG#48161, fixed a regression from fix of BUG#6045, where binary collations can use indexes/partition pruning for cases using equality conditions, however it cannot be used for any other condition like <, >, <=, >=, <>, also added test case for verification of BUG#47774 in this patch
Diffstat (limited to 'mysql-test/r/partition_innodb.result')
-rw-r--r-- | mysql-test/r/partition_innodb.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/partition_innodb.result b/mysql-test/r/partition_innodb.result index 53e0d88f3f8..d95e7dc43fd 100644 --- a/mysql-test/r/partition_innodb.result +++ b/mysql-test/r/partition_innodb.result @@ -1,4 +1,15 @@ drop table if exists t1; +create table t1 (a varchar(5), b int signed, c varchar(10), d datetime) +partition by range columns(b,c) +subpartition by hash(to_seconds(d)) +( partition p0 values less than (2, 'b'), +partition p1 values less than (4, 'd'), +partition p2 values less than (10, 'za')); +insert into t1 values ('a', 3, 'w', '2001-10-27 04:34:00'); +insert into t1 values ('r', 7, 'w', '2001-10-27 05:34:00'); +insert into t1 values ('g', 10, 'w', '2001-10-27 06:34:00'); +update t1 set a = 'c' where a > 'f'; +drop table t1; create table t1 (a varchar(5)) engine=memory partition by range columns(a) |