diff options
| author | aivanov@mysql.com <> | 2006-04-21 01:37:31 +0400 |
|---|---|---|
| committer | aivanov@mysql.com <> | 2006-04-21 01:37:31 +0400 |
| commit | 364621abc0d637b1200038ffeaded1d5f58a030c (patch) | |
| tree | 60caded9c2d69d4b0d470daecb2c1c89cfe97225 /mysql-test/t/innodb.test | |
| parent | 25d9a75d122d93b25fef61ed37d6bfa3d2a29c13 (diff) | |
| download | mariadb-git-364621abc0d637b1200038ffeaded1d5f58a030c.tar.gz | |
Restoring changes erroneously removed by applying
the innodb-5.0-ss476 snapshot.
Diffstat (limited to 'mysql-test/t/innodb.test')
| -rw-r--r-- | mysql-test/t/innodb.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/innodb.test b/mysql-test/t/innodb.test index df3b473dcc0..ccd2be5cdba 100644 --- a/mysql-test/t/innodb.test +++ b/mysql-test/t/innodb.test @@ -2128,6 +2128,18 @@ connection default; 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; + # bug 18934, "InnoDB crashes when table uses column names like DB_ROW_ID" --error 1005 CREATE TABLE t1 (DB_ROW_ID int) engine=innodb; |