diff options
| author | unknown <holyfoot@mysql.com> | 2006-05-03 16:42:39 +0500 |
|---|---|---|
| committer | unknown <holyfoot@mysql.com> | 2006-05-03 16:42:39 +0500 |
| commit | 83c8e2c910a9f07c473aaa2d254f0571d574aa89 (patch) | |
| tree | c59d637e1d3d7b81ff0e680ba83046ad4f19773e /mysql-test/t/innodb.test | |
| parent | 0a9c02f106239afcdb6da40d9ddfb3cec1d42049 (diff) | |
| parent | f01b0ac2212a8e8c4192842ddba123198353c591 (diff) | |
| download | mariadb-git-83c8e2c910a9f07c473aaa2d254f0571d574aa89.tar.gz | |
merging
sql/handler.h:
Auto merged
sql/sql_table.cc:
Auto merged
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 3ba5ca5b4a2..703e3b311b9 100644 --- a/mysql-test/t/innodb.test +++ b/mysql-test/t/innodb.test @@ -2190,3 +2190,15 @@ SELECT DISTINCT p0.a FROM t2 p0 WHERE BINARY p0.b = 'customer_over'; SELECT p0.a FROM t2 p0 WHERE BINARY p0.b = 'customer_over'; drop table t2, t1; +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 #15680 (SPATIAL key in innodb) +# +--error ER_TABLE_CANT_HANDLE_SPKEYS +create table t1 (g geometry not null, spatial gk(g)) engine=innodb; |