Skip Menu |

This queue is for tickets about the SQL-Translator CPAN distribution.

Report information
The Basics
Id: 17638
Status: resolved
Priority: 0/
Queue: SQL-Translator

People
Owner: Nobody in particular
Requestors: nigel.metheringham [...] Dev.intechnology.co.uk
Cc:
AdminCc:

Bug Information
Severity: Normal
Broken in: 0.07
Fixed in: (no value)



Subject: SQLite producer making assumptions for timstamps
If the SQLite producer sees a column of type timestamp it adds a trigger to update it on insert. This is a bad assumption, and should at best be made selectable, and preferably removed. Strongly related to bug #6959
From: JROBINSON [...] cpan.org
On Tue Feb 14 07:00:14 2006, guest wrote: Show quoted text
> If the SQLite producer sees a column of type timestamp it adds a
trigger Show quoted text
> to update it on insert. > > This is a bad assumption, and should at best be made selectable, and > preferably removed. > > Strongly related to bug #6959
The point of this was to emulate mysql timestamps in the producers, which was a bit backwards. I've removed it in 0.08_01. Jess