Description:
variables [ pass ] 1852
view [ fail ]
Errors are (from /builddir/build/BUILD/mysql-5.0.45/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 Wed Jul 4 16:49:09 2007
--- r/view.reject Tue Mar 18 08:46:32 2008
***************
*** 2711,2722 ****
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select (year(now()) - year(`t1`.`DOB`)) AS `Age` from `t1` having (`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');
--- 2711,2722 ----
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select (year(now()) - year(`t1`.`DOB`)) AS `Age` from `t1` having (`Age` < 75)
SELECT (year(now())-year(DOB)) AS Age FROM t1 HAVING Age < 75;
Age
! 44
! 40
SELECT * FROM v1;
Age
! 44
! 40
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://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Result from queries before failure can be found in r/view.log
Aborting: view failed in default mode. To continue, re-run with '--force'.
Stopping All Servers
make: *** [test-ns] Error 1
error: Bad exit status from /var/tmp/rpm-tmp.83862 (%build)
How to repeat:
./mysql-test-run
Suggested fix:
it is similar to bug#25585 for 5.0.33
