diff options
| author | unknown <serg@serg.mylan> | 2003-08-06 15:37:22 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2003-08-06 15:37:22 +0200 |
| commit | e50930d36c33c4457d9ba6d68e5f6b2c6e622f11 (patch) | |
| tree | 2d013e3cc70fc8c4d39eb14f3473bc2f81edd305 /mysql-test | |
| parent | 8edc3dedf91111fec2676addf981d9fa3c33edbb (diff) | |
| download | mariadb-git-e50930d36c33c4457d9ba6d68e5f6b2c6e622f11.tar.gz | |
Bug #792 combination of date-interval and between with mixed constant and non-constant
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/type_date.result | 2 | ||||
| -rw-r--r-- | mysql-test/t/type_date.test | 1 |
2 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/type_date.result b/mysql-test/r/type_date.result index 214328eab47..8dfe14bc1a2 100644 --- a/mysql-test/r/type_date.result +++ b/mysql-test/r/type_date.result @@ -32,6 +32,8 @@ datum 2000-01-02 2000-01-03 2000-01-04 +SELECT * FROM t1 WHERE datum BETWEEN "2000-1-2" AND datum - INTERVAL 100 DAY; +datum DROP TABLE t1; CREATE TABLE t1 ( user_id char(10), diff --git a/mysql-test/t/type_date.test b/mysql-test/t/type_date.test index 68c2d55aac9..bd6d8c49c22 100644 --- a/mysql-test/t/type_date.test +++ b/mysql-test/t/type_date.test @@ -34,6 +34,7 @@ INSERT INTO t1 VALUES ( "2000-1-3" ); INSERT INTO t1 VALUES ( "2000-1-4" ); INSERT INTO t1 VALUES ( "2000-1-5" ); SELECT * FROM t1 WHERE datum BETWEEN "2000-1-2" AND "2000-1-4"; +SELECT * FROM t1 WHERE datum BETWEEN "2000-1-2" AND datum - INTERVAL 100 DAY; DROP TABLE t1; # |