diff options
| author | unknown <gluh@mysql.com/eagle.(none)> | 2007-12-13 21:34:05 +0400 |
|---|---|---|
| committer | unknown <gluh@mysql.com/eagle.(none)> | 2007-12-13 21:34:05 +0400 |
| commit | f61f5f72f55b44d33ff77de00432649134eab25c (patch) | |
| tree | b85a358a96a337162681474715a2b47fdfb830f7 /mysql-test/r/partition_range.result | |
| parent | 0cc269da52f939ffc6a6272370d113aac9ab5369 (diff) | |
| download | mariadb-git-f61f5f72f55b44d33ff77de00432649134eab25c.tar.gz | |
additional after merge fix
mysql-test/r/partition_range.result:
removed fix for bug#30573
mysql-test/suite/parts/r/rpl_partition.result:
updated result file
mysql-test/t/partition_range.test:
removed test case for bug#30573
sql/ha_partition.cc:
removed fix for bug#30573
Diffstat (limited to 'mysql-test/r/partition_range.result')
| -rw-r--r-- | mysql-test/r/partition_range.result | 20 |
1 files changed, 0 insertions, 20 deletions
diff --git a/mysql-test/r/partition_range.result b/mysql-test/r/partition_range.result index f75cbbf5470..4da79704ec3 100644 --- a/mysql-test/r/partition_range.result +++ b/mysql-test/r/partition_range.result @@ -709,23 +709,3 @@ WHERE (a >= '2004-07-01' AND a <= '2004-09-30') OR id select_type table partitions type possible_keys key key_len ref rows Extra 1 SIMPLE t1 p407,p408,p409,p507,p508,p509 ALL NULL NULL NULL NULL 18 Using where DROP TABLE t1; -create table t1 (a int); -insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); -CREATE TABLE t2 ( -defid int(10) unsigned NOT NULL, -day int(10) unsigned NOT NULL, -count int(10) unsigned NOT NULL, -filler char(200), -KEY (defid,day) -) -PARTITION BY RANGE (day) ( -PARTITION p7 VALUES LESS THAN (20070401) , -PARTITION p8 VALUES LESS THAN (20070501)); -insert into t2 select 20, 20070311, 1, 'filler' from t1 A, t1 B; -insert into t2 select 20, 20070411, 1, 'filler' from t1 A, t1 B; -insert into t2 values(52, 20070321, 123, 'filler') ; -insert into t2 values(52, 20070322, 456, 'filler') ; -select sum(count) from t2 ch where ch.defid in (50,52) and ch.day between 20070320 and 20070401 group by defid; -sum(count) -579 -drop table t1, t2; |