Skip Menu |

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

Report information
The Basics
Id: 70473
Status: resolved
Priority: 0/
Queue: SQL-Translator
People
Owner: Nobody in particular
Requestors: jonathan [...] leto.net
Cc:
AdminCc:
Bug Information
Severity: Normal
Broken in: 0.11008
Fixed in: 0.11011

History Show all quoted text
  Thu Aug 25 00:18:36 2011 jonathan [...] leto.net - Ticket created
SQL::Translator cannot parse MySQL dumps that contain a BIT column type, such as: `public_status` bit(1) DEFAULT b'0', Converting this to `public_status` bool DEFAULT '0', fixes the issue. An example of what the error looks like is: sqlt -f MySQL -t SQLite ./framework/php/settings/sql/cashmusic_db.sql ERROR (line 5): Invalid statement: Was expecting comment, or use, or set, or drop, or create, or alter, or insert, or delimiter, or empty statement Error: translate: Error with parser 'SQL::Translator::Parser::MySQL': no results at /home/leto/git/cxgn/local-lib/bin/sqlt line 353. The file in question which causes this error is here: https://github.com/cashmusic/DIY/blob/4f25b5876209509c6e87d227568a76ae0c757a29/framework/php/settings/sql/cashmusic_db.sql
  Sat Dec 10 09:45:50 2011 sk [...] computer-leipzig.com - Correspondence added
There is currently a pull request on github fixing this issue. https://github.com/dbsrgits/sql-translator/pull/15 The sql file is aded to the test suite.
  Sat Dec 10 09:45:53 2011 The RT System itself - Status changed from 'new' to 'open'
  Sun Dec 25 11:08:27 2011 ribasushi [...] leporine.io - Correspondence added
As per giftnuss - this issue is now resolved. Thanks for the test!
  Sun Dec 25 11:08:28 2011 ribasushi [...] leporine.io - Status changed from 'open' to 'patched'
  Thu May 10 02:23:48 2012 ribasushi [...] leporine.io - Fixed in 0.11011 added
  Thu May 10 02:23:48 2012 ribasushi [...] leporine.io - Status changed from 'patched' to 'resolved'