Skip Menu |

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

Report information
The Basics
Id: 47967
Status: rejected
Priority: 0/
Queue: SQL-Translator
People
Owner: kclark [...] cpan.org
Requestors: voodoo81people [...] gmail.com
Cc:
AdminCc:
Bug Information
Severity: Important
Broken in: 0.09001
Fixed in: (no value)

History Show all quoted text
  Fri Jul 17 03:54:55 2009 http://bytestrike.blogspot.com/ - Ticket created
Subject: wrong default value for timestamp CURRENT_TIMESTAMP value
sqlt-tool produces an invalid default value for fields of type "timestamp" (it uses 'CURRENT_TIMESTAMP' with single quotes instead of the same value without quotes). Code: ctime timestamp on update CURRENT_TIMESTAMP NOT NULL DEFAULT 'CURRENT_TIMESTAMP'.
  Tue Aug 11 17:38:29 2009 kclark [...] cpan.org - Taken
  Tue Aug 11 17:39:52 2009 kclark [...] cpan.org - Correspondence added
Can you be more specific as to what output you wish corrected (e.g., "fix SQL::Translator::Producer::SQLite") or under what circumstances this happens (e.g., "sqlt -f SQLite -t MySQL file.sql"). Perhaps include the source file and desired output, patches to code/tests, etc.?
  Tue Aug 11 17:39:53 2009 The RT System itself - Status changed from 'new' to 'open'
  Thu Dec 02 06:29:13 2010 ribasushi [...] leporine.io - Correspondence added
On Fri Jul 17 03:54:55 2009, http://bytestrike.blogspot.com/ wrote: Show quoted text
> sqlt-tool produces an invalid default value for fields of type > "timestamp" (it uses 'CURRENT_TIMESTAMP' with single quotes instead of > the same value without quotes). > Code: > > ctime timestamp on update CURRENT_TIMESTAMP NOT NULL DEFAULT > 'CURRENT_TIMESTAMP'. >
Rejecting ticket without more info from submitter. If the problem persists in latest versions - please do reopen the ticket with more information.
  Thu Dec 02 06:29:14 2010 ribasushi [...] leporine.io - Status changed from 'open' to 'rejected'