Bug #33623 View test fails since 2008

• Submitted: 2 Jan 2008 12:36
• Modified: 2 Jan 2008 13:10
• Reporter: Norbert Tretkowski
• Status: Duplicate
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.0.51
• OS: Linux
• CPU Architecture: Any
• Tags: testsuite

[2 Jan 2008 12:36] Norbert Tretkowski

Description:
Since 2008, the view test from the testsuite fails with this error:

--- /tmp/buildd/mysql-dfsg-5.0-5.0.51/mysql-test/r/view.result	2007-11-15 17:28:37.000000000 +0300
+++ /tmp/buildd/mysql-dfsg-5.0-5.0.51/mysql-test/var/log/view.reject	2008-01-02 15:36:17.000000000 +0300
@@ -2719,12 +2719,12 @@
 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
+44
+40
 SELECT * FROM v1;
 Age
-43
-39
+44
+40
 DROP VIEW v1;
 DROP TABLE t1;
 CREATE TABLE t1 (id int NOT NULL PRIMARY KEY, a char(6) DEFAULT 'xxx');

mysqltest: Result content mismatch

How to repeat:
Run the view test.

Suggested fix:
Update the results file.

[2 Jan 2008 12:54] Daniel Fischer

This is probably a duplicate of bug#25359, which was fixed in 5.0.52.

[2 Jan 2008 13:10] Valeriy Kravchuk

Duplicate of bug #25359. I can not repeat it with latest 5.0.56-BK.