diff options
| author | unknown <gkodinov@dl145s.mysql.com> | 2006-09-18 12:14:27 +0200 |
|---|---|---|
| committer | unknown <gkodinov@dl145s.mysql.com> | 2006-09-18 12:14:27 +0200 |
| commit | 4c8e0e192b315d8730e5dab9c757b9409ba7bdfb (patch) | |
| tree | 126c4144a479c5aeb28b5a9761bc525e05fd9dc6 /mysql-test/t/view.test | |
| parent | 7a0f9c8d4c02826d7fec0d3027dcac7bd1be7bc7 (diff) | |
| download | mariadb-git-4c8e0e192b315d8730e5dab9c757b9409ba7bdfb.tar.gz | |
merge fixes
Diffstat (limited to 'mysql-test/t/view.test')
| -rw-r--r-- | mysql-test/t/view.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index e299b86c4e6..4745804e847 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -2449,8 +2449,8 @@ INSERT INTO t1 VALUES CREATE VIEW v1 AS SELECT * FROM t1; -SELECT * FROM t1 WHERE td BETWEEN '2005.01.02' AND '2005.01.04'; -SELECT * FROM v1 WHERE td BETWEEN '2005.01.02' AND '2005.01.04'; +SELECT * FROM t1 WHERE td BETWEEN CAST('2005.01.02' AS DATE) AND CAST('2005.01.04' AS DATE); +SELECT * FROM v1 WHERE td BETWEEN CAST('2005.01.02' AS DATE) AND CAST('2005.01.04' AS DATE); DROP VIEW v1; DROP TABLE t1; |