[Bug 201943] [NEW] mysql test suite uses now() in the view tests, which will cause FTBFS on hardy in the future

[Jamie Strandboge]

Public bug reported:

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.

** Affects: mysql-dfsg-5.0 (Ubuntu)
     Importance: Medium
     Assignee: Jamie Strandboge (jamie-strandboge)
         Status: Triaged

** Changed in: mysql-dfsg-5.0 (Ubuntu)
     Assignee: (unassigned) => Jamie Strandboge (jamie-strandboge)
       Status: New => Triaged

** Description changed:

  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 fail the test to fail which will in turn
- cause an FTBFS after hardy is released (late 2008).  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.
+ 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.

** Changed in: mysql-dfsg-5.0 (Ubuntu)
   Importance: Undecided => Medium

-- 
mysql test suite uses now() in the view tests, which will cause FTBFS on hardy in the future
https://bugs.launchpad.net/bugs/201943
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.