Skip Menu |

This queue is for tickets about the Class-DBI-Sweet CPAN distribution.

Report information
The Basics
Id: 14126
Status: new
Priority: 0/
Queue: Class-DBI-Sweet
People
Owner: Nobody in particular
Requestors: radium [...] gmail.com
Cc:
AdminCc:
Bug Information
Severity: Normal
Broken in: 0.05
Fixed in: (no value)

History Show all quoted text
  Thu Aug 11 22:33:31 2005 Guest - Ticket created
Subject: date bug in t/cdbi-t/10-mysql.t
Class::DBI::Sweet 0.5, perl 8.5.6, Linux 2.6 Some mysql tests fail because the CURDATE() retrieved from mysql takes time zone into consideration, and it seems the date in the script does not (thats my guess anyway). I was able to pass the tests by setting my clock back -6:00 temporarily. Here is the failing lines during the test where you can see the dates differ slightly: t/cdbi-t/10-mysql.....................NOK 11 # Failed test (t/cdbi-t/10-mysql.t at line 32) # got: '2005-08-11' # expected: '2005-08-12' t/cdbi-t/10-mysql.....................NOK 12 # Failed test (t/cdbi-t/10-mysql.t at line 34) # got: '2005-08-11' # expected: '2005-08-12' t/cdbi-t/10-mysql.....................ok 64/64# Looks like you failed 2 tests of 64.
  Fri Sep 09 08:13:05 2005 rt-cpan [...] trout.me.uk - Correspondence added
[guest - Thu Aug 11 22:33:31 2005]: Show quoted text
> Class::DBI::Sweet 0.5, perl 8.5.6, Linux 2.6 > > Some mysql tests fail because the CURDATE() retrieved from mysql takes > time zone into consideration, and it seems the date in the script > does not (thats my guess anyway). I was able to pass the tests by > setting my clock back -6:00 temporarily. > > Here is the failing lines during the test where you can see the dates > differ slightly: > > t/cdbi-t/10-mysql.....................NOK 11 > # Failed test (t/cdbi-t/10-mysql.t at line 32) > # got: '2005-08-11' > # expected: '2005-08-12' > t/cdbi-t/10-mysql.....................NOK 12 > # Failed test (t/cdbi-t/10-mysql.t at line 34) > # got: '2005-08-11' > # expected: '2005-08-12' > t/cdbi-t/10-mysql.....................ok 64/64# Looks like you failed > 2 tests of 64.
I mostly tend to validate via the SQLite tests; if you can provide a patch to fix the test? (I'd be guessing localtime vs. time?) Please bear in mind the t/cdbi-t directory is copied directly from the Class::DBI t/ directory - I didn't write the code therein, I simply use it to give Sweet a decent workout before install. Doesn't mean I don't want to fix it but it does mean your guess is as good as mine ...