diff options
author | unknown <igor@rurik.mysql.com> | 2006-04-12 18:15:39 -0700 |
---|---|---|
committer | unknown <igor@rurik.mysql.com> | 2006-04-12 18:15:39 -0700 |
commit | b974b7768e16b49d8185ac41f5da3312d85f8822 (patch) | |
tree | bb72deb119cd6201301cd602780278b17cdfaa7e /mysql-test/t/innodb.test | |
parent | a00a3bb9eb719ad45cca33c7c14e317f2a432788 (diff) | |
download | mariadb-git-b974b7768e16b49d8185ac41f5da3312d85f8822.tar.gz |
Fixes after manual merge.
Diffstat (limited to 'mysql-test/t/innodb.test')
-rw-r--r-- | mysql-test/t/innodb.test | 23 |
1 files changed, 12 insertions, 11 deletions
diff --git a/mysql-test/t/innodb.test b/mysql-test/t/innodb.test index 9c8c54f2b55..83b167def73 100644 --- a/mysql-test/t/innodb.test +++ b/mysql-test/t/innodb.test @@ -2086,6 +2086,18 @@ disconnect a; disconnect b; # +# Bug #14360: problem with intervals +# + +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; +drop table t1, t2; + +# # Test that cascading updates leading to duplicate keys give the correct # error message (bug #9680) # @@ -2137,14 +2149,3 @@ alter table t1 drop foreign key c2_fk; show create table t1; # drop table t1, t2; - -# Bug #14360: problem with intervals -# - -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; -drop table t1, t2; |