Errors are (from /usr/local/mysql/mysql-test/var/log/mysqltest-time) :
mysqltest: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/view.result 2006-10-21 03:36:44.000000000 +0300
--- r/view.reject 2007-05-22 04:51:33.000000000 +0300
***************
*** 2686,2697 ****
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFIN ER VIEW `v1` AS select (year(now()) - year(`t1`.`DOB`)) AS `Age` from `t1` havin g (`Age` < 75)
SELECT (year(now())-year(DOB)) AS Age FROM t1 HAVING Age < 75;
Age
! 42
! 38
SELECT * FROM v1;
Age
! 42
! 38
DROP VIEW v1;
DROP TABLE t1;
CREATE TABLE t1 (id int NOT NULL PRIMARY KEY, a char(6) DEFAULT 'xxx');
--- 2686,2697 ----
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFIN ER VIEW `v1` AS select (year(now()) - year(`t1`.`DOB`)) AS `Age` from `t1` havin g (`Age` < 75)
SELECT (year(now())-year(DOB)) AS Age FROM t1 HAVING Age < 75;
Age
! 43
! 39
SELECT * FROM v1;
Age
! 43
! 39
DROP VIEW v1;
DROP TABLE t1;
CREATE TABLE t1 (id int NOT NULL PRIMARY KEY, a char(6) DEFAULT 'xxx');
-------------------------------------------------------
Please follow the instructions outlined at http://dev.mysql.com/doc/mysql/en/reporting-mysqltest-bugs.html
to find the reason to this problem and how to report this.
mysql-test-run in default mode: *** Failing the test(s): trigger view