Bug #20750 for SQL-Translator: MySQL parser doesn't parse enumerated values correctly

Fri Jul 28 22:40:16 2006 dan.horne [...] redbone.co.nz - Ticket created

Subject:	MySQL parser doesn't parse enumerated values correctly
Date:	Sat, 29 Jul 2006 14:39:55 +1200
To:	<bug-SQL-Translator [...] rt.cpan.org>
From:	"Dan Horne" <dan.horne [...] redbone.co.nz>

Hi The MySQL parser interprets enumerated data types incorrectly. For instance, the original table DDL: Create table zoo ( zoo_id Int NOT NULL AUTO_INCREMENT, animal Enum('tiger','elephant','gazelle') DEFAULT 'tiger', Index AI_zoo_id (zoo_id), Primary Key (zoo_id)) ENGINE = InnoDB; The parser produces CREATE TABLE zoo ( zoo_id integer(11) NOT NULL auto_increment, animal enum() DEFAULT 'tiger', INDEX AI_zoo_id (zoo_id), PRIMARY KEY (zoo_id) ) Type=InnoDB; Regards Dan Horne

Fri Jul 28 23:17:41 2006 dan.horne [...] redbone.co.nz - Correspondence added

Subject:	RE: [rt.cpan.org #20750] AutoReply: MySQL parser doesn't parse enumerated values correctly
Date:	Sat, 29 Jul 2006 15:17:24 +1200
To:	<bug-SQL-Translator [...] rt.cpan.org>
From:	"Dan Horne" <dan.horne [...] redbone.co.nz>

Hi I forgot to mention - this is via a DBI connection, not a MySQL file: sqlt -f DBI --dsn dbi:mysql:<db> --db-user <user> -t MySQL > ..\model\dbs\mysql.sql Dan

Sun Aug 06 07:29:35 2006 cpan [...] desert-island.me.uk - Correspondence added

From:

JROBINSON [...] cpan.org

On Fri Jul 28 23:17:41 2006, dan.horne@redbone.co.nz wrote: Show quoted text

> Hi > > I forgot to mention - this is via a DBI connection, not a MySQL file: > > sqlt -f DBI --dsn dbi:mysql:<db> --db-user <user> -t MySQL > > ..\model\dbs\mysql.sql > > Dan >

Using the recently released 0.08_01, I what looks like correct output to me, so I'm closing this one: -- Table: zoo -- CREATE TABLE zoo ( zoo_id integer(11) NOT NULL auto_increment, animal enum('tiger', 'elephant', 'gazelle') DEFAULT 'tiger', INDEX AI_zoo_id (zoo_id), PRIMARY KEY (zoo_id) ) ENGINE=InnoDB CHARACTER SET=utf8;

Sun Aug 06 07:29:36 2006 The RT System itself - Status changed from 'new' to 'open'

Sun Aug 06 07:29:57 2006 cpan [...] desert-island.me.uk - Status changed from 'open' to 'resolved'

Sun Aug 06 07:29:59 2006 cpan [...] desert-island.me.uk - Fixed in 0.08_01 added