Ubuntu
mysql-dfsg-5.0 package

mysql test suite uses now() in the view tests, which will cause FTBFS on hardy in the future

Bug #201943 reported by Jamie Strandboge
2
Affects Status Importance Assigned to Milestone
mysql-dfsg-5.0 (Ubuntu)
Invalid
Medium
Jamie Strandboge

Bug Description

mysql-dfsg-5.0 in hardy now uses the mysql-test suite as part of the build. mysql-test/t/view.test uses the following:

SELECT (year(now())-year(DOB)) AS Age
SELECT (year(now())-year(DOB)) AS Age FROM t1 HAVING Age < 75;

These statements will cause the test to fail which will in turn cause an FTBFS after hardy is released. This was discovered when using the mysql-test suite for security updates. I will provide a patch to fix this, that has been pushed to -security for previous releases already.

See original description
Jamie Strandboge (jdstrand)
Changed in mysql-dfsg-5.0:
assignee: nobody → jamie-strandboge
status: New → Triaged
description: updated
Changed in mysql-dfsg-5.0:
importance: Undecided → Medium
Revision history for this message
Jamie Strandboge (jdstrand) wrote :

This was actually fixed by patch 55_testsuite-2008.dpatch that is included from the debian merge,

Changed in mysql-dfsg-5.0:
status: Triaged → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.