| Subject: | Bit column bug in sqlt |
| Date: | Wed, 5 Oct 2011 14:33:14 +0200 |
| To: | bug-SQL-Translator [...] rt.cpan.org |
| From: | Mariusz Pańszczyk <mariusz.panszczyk [...] nasza-klasa.pl> |
Hi.
To reproduce bug try to compare:
sqlt-diff user.sql=MySQL user.sql=MySQL
user.sql:
CREATE TABLE `application_user` (
`user_id` int(11) NOT NULL,
`version` int(11) NOT NULL,
`activity_hidden` bit(1) NOT NULL DEFAULT b'0',
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Problem is with bit column 'activity_hidden'.
Received error:
ERROR (line 1): Invalid statement: Was expecting comment, or use, or
set, or drop, or create, or alter, or insert, or
delimiter, or empty statement
Died at /usr/bin/sqlt-diff line 198.
# uname -a
Linux squeeze 2.6.32-5-amd64 #1 SMP Thu Apr 7 15:25:10 CEST 2011 x86_64
GNU/Linux
# sqlt --version
SQL::Translator v0.11009
# perl -V
Summary of my perl5 (revision 5 version 10 subversion 1)
Best regards.
--
*Mariusz Pańszczyk*
Programista
e-mail: mariusz.panszczyk@nasza-klasa.pl
telefon: 601263042
Nasza Klasa sp. z o.o.
ul. Gen. J. Bema 2, 50-265 Wrocław
---------------------------------------------------------------------------------------------------------
Sąd Rejonowy dla Wrocławia - Fabrycznej we Wrocławiu
VI Wydział Gospodarczy Krajowego Rejestru Sądowego
KRS: 0000289629, NIP: 898-21-22-104 REGON: 020586020
Kapitał zakładowy: 67 850,00 PLN