Skip Menu |
 

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

Report information
The Basics
Id: 29685
Status: new
Priority: 0/
Queue: SQL-Translator

People
Owner: Nobody in particular
Requestors: chris+rt [...] chrisdolan.net
Cc:
AdminCc:

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



Subject: enum failure in sqlt-diff
Download (untitled) / with headers
text/plain 802b
[Not sure if this is MySQL specific, or if it's a general bug.] Create a before and after SQL schema file as follows and run sqlt-diff on them. The enum values are lost and replaced with what appears to be their maximum length. I confirmed this bug in 0.08 and 0.08001. ---- before.sql ---- create table foo ( id int ); ---- after.sql ---- create table foo ( id int, some_boolean enum('false','true') ); Actual results: % sqlt-diff before.sql=MySQL after.sql=MySQL -- Convert schema 'before.sql' to 'after.sql': ALTER TABLE foo ADD some_boolean enum(5); Expected results: % sqlt-diff before.sql=MySQL after.sql=MySQL -- Convert schema 'before.sql' to 'after.sql': ALTER TABLE foo ADD some_boolean enum('false', 'true');


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.