diff options
Diffstat (limited to 'mysql-test/t/view.test')
| -rw-r--r-- | mysql-test/t/view.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index ea429e2a0f0..b75e690e677 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -2553,7 +2553,9 @@ CREATE VIEW v1 AS FROM t1 HAVING Age < 75; SHOW CREATE VIEW v1; +set timestamp=1136066400; SELECT (year(now())-year(DOB)) AS Age FROM t1 HAVING Age < 75; +set timestamp=1136066400; SELECT * FROM v1; DROP VIEW v1; |