1 files changed, 5 insertions, 3 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test
index ea429e2a0f0..3c5308a935c 100644
--- a/mysql-test/t/view.test
+++ b/mysql-test/t/view.test
@@ -2544,16 +2544,18 @@ CREATE TABLE t1(
   uID int unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY);
  
 INSERT INTO t1(fName, lName, DOB) VALUES
-  ('Alice', 'Hill', date_sub(curdate(), interval 15271 day)),
-  ('Bob', 'Adams', date_sub(curdate(), interval 33600 day)),
-  ('Carol', 'Simpson', date_sub(curdate(), interval 13700 day));
+  ('Hank', 'Hill', '1964-09-29'),
+  ('Tom', 'Adams', '1908-02-14'),
+  ('Homer', 'Simpson', '1968-03-05');
 
 CREATE VIEW v1 AS
   SELECT (year(now())-year(DOB)) AS Age
     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;