Bug #33623 View test fails since 2008

Submitted: 2 Jan 2008 12:36 Modified: 2 Jan 2008 13:10
Reporter: Norbert Tretkowski Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.0.51 OS:Linux
Assigned to: 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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.