diff options
| author | unknown <ramil@mysql.com> | 2006-04-11 16:13:57 +0500 |
|---|---|---|
| committer | unknown <ramil@mysql.com> | 2006-04-11 16:13:57 +0500 |
| commit | 1ef739636a275f1c0e7bb56f891160b77d4cf43b (patch) | |
| tree | e8e9706751cb77c52dd4b07cc0a78de3393e3863 /mysql-test/r/innodb.result | |
| parent | 3b1a0c8738f3772a4898548bfb0e90165eb9a913 (diff) | |
| download | mariadb-git-1ef739636a275f1c0e7bb56f891160b77d4cf43b.tar.gz | |
Fix for bug #14360: Date Between Interval Broken.
mysql-test/r/innodb.result:
Fix for bug #14360: Date Between Interval Broken.
- test case.
mysql-test/t/innodb.test:
Fix for bug #14360: Date Between Interval Broken.
- test case.
sql/item_timefunc.cc:
Fix for bug #14360: Date Between Interval Broken.
- Item_date_add_interval::eq() introduced.
sql/item_timefunc.h:
Fix for bug #14360: Date Between Interval Broken.
- Item_date_add_interval::eq() introduced.
Diffstat (limited to 'mysql-test/r/innodb.result')
| -rw-r--r-- | mysql-test/r/innodb.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/innodb.result b/mysql-test/r/innodb.result index c5658d22eb6..9a190557211 100644 --- a/mysql-test/r/innodb.result +++ b/mysql-test/r/innodb.result @@ -3232,3 +3232,12 @@ drop trigger t2t; drop trigger t3t; drop trigger t4t; drop table t1, t2, t3, t4, t5; +create table t1(a date) engine=innodb; +create table t2(a date, key(a)) engine=innodb; +insert into t1 values('2005-10-01'); +insert into t2 values('2005-10-01'); +select * from t1, t2 +where t2.a between t1.a - interval 2 day and t1.a + interval 2 day; +a a +2005-10-01 2005-10-01 +drop table t1, t2; |