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)



Subject: wrong default value for timestamp CURRENT_TIMESTAMP value
MIME-Version: 1.0
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Type: text/plain
Charset: utf8
Content-Disposition: inline
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 256
Download (untitled) / with headers
text/plain 256b
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'.
MIME-Version: 1.0
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
Charset: utf8
Content-Type: text/plain
Message-ID: <rt-3.6.HEAD-26882-1250026792-745.47967-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 276
Download (untitled) / with headers
text/plain 276b
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.?
MIME-Version: 1.0
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-19313-1291289353-886.47967-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 488
Download (untitled) / with headers
text/plain 488b
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.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.