Skip Menu |

This queue is for tickets about the DateTime-Format-DBI CPAN distribution.

Report information
The Basics
Id: 26201
Status: resolved
Worked: 30 min
Priority: 0/
Queue: DateTime-Format-DBI
People
Owner: CFAERBER [...] cpan.org
Requestors: andreas.marienborg [...] gmail.com
Cc:
AdminCc:
Bug Information
Severity: Wishlist
Broken in:
  • 0.031
  • 0.01
  • 0.02
  • 0.03
  • 0.03a
Fixed in: 0.032_20080913

History Show all quoted text
  Mon Apr 09 14:15:43 2007 andreas.marienborg [...] gmail.com - Ticket created
Subject: No SQLite driver support
Attached patch makes it use MySQL for SQLite, which works afaik
Subject: datetime-format-dbi.01.patch
Only in DateTime-Format-DBI-0.031.fixed: Makefile Only in DateTime-Format-DBI-0.031.fixed: blib diff -ur DateTime-Format-DBI-0.031/lib/DateTime/Format/DBI.pm DateTime-Format-DBI-0.031.fixed/lib/DateTime/Format/DBI.pm --- DateTime-Format-DBI-0.031/lib/DateTime/Format/DBI.pm 2003-11-03 00:17:38.000000000 +0100 +++ DateTime-Format-DBI-0.031.fixed/lib/DateTime/Format/DBI.pm 2007-04-09 20:12:40.000000000 +0200 @@ -14,6 +14,7 @@ # lowercase for case-insensitivity! 'mysql' => 'DateTime::Format::MySQL', 'pg' => 'DateTime::Format::Pg', + 'sqlite' => 'DateTime::Format::MySQL', ); sub new { Only in DateTime-Format-DBI-0.031.fixed: pm_to_blib
  Tue Apr 17 16:17:37 2007 CFAERBER [...] cpan.org - Correspondence added 30 min
On Mo. 09. Apr. 2007, 14:15:43, ANDREMAR wrote: Show quoted text
> Attached patch makes it use MySQL for SQLite, which works afaik
SQLite assumes UTC for date calculations, whereas MySQL assumes local time. Further, SQLite happily stores and returns any date format the database creator chose. It would be better to write DateTime::Format::SQLite first.
  Tue Apr 17 16:17:38 2007 The RT System itself - Status changed from 'new' to 'open'
  Tue Apr 17 16:17:38 2007 CFAERBER [...] cpan.org - Status changed from 'open' to 'stalled'
  Sat Sep 13 12:59:01 2008 CFAERBER [...] cpan.org - Taken
  Sun Sep 14 04:54:28 2008 CFAERBER [...] cpan.org - Severity Wishlist added
  Sun Sep 14 04:54:28 2008 CFAERBER [...] cpan.org - Broken in 0.01 added
  Sun Sep 14 04:54:28 2008 CFAERBER [...] cpan.org - Broken in 0.02 added
  Sun Sep 14 04:54:28 2008 CFAERBER [...] cpan.org - Broken in 0.03 added
  Sun Sep 14 04:54:28 2008 CFAERBER [...] cpan.org - Broken in 0.03a added
  Sun Sep 21 16:37:00 2008 CFAERBER [...] cpan.org - Status changed from 'stalled' to 'resolved'
  Sun Sep 21 16:37:05 2008 CFAERBER [...] cpan.org - Fixed in 0.032_20080913 added