Skip Menu |

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

Report information
The Basics
Id: 50468
Status: resolved
Priority: 0/
Queue: SQL-Translator
People
Owner: Nobody in particular
Requestors: GWS [...] cpan.org
Cc: gisbert.selke [...] wido.bv.aok.de
AdminCc:
Bug Information
Severity: Normal
Broken in: 0.11003
Fixed in: 0.11005

History Show all quoted text
  Tue Oct 13 19:21:44 2009 GWS [...] cpan.org - Ticket created
CC: gisbert.selke [...] wido.bv.aok.de
Subject: Bug parsing MySQL "primary key (...) using btree"
The following valid MySQL table definition (as output by mysqldump) CREATE TABLE t (a int NOT NULL, PRIMARY KEY (a) USING BTREE); will trigger an 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
  Sun Feb 14 05:07:04 2010 ribasushi [...] leporine.io - Correspondence added
On Tue Oct 13 19:21:44 2009, GWS wrote: Show quoted text
> The following valid MySQL table definition (as output by mysqldump) > CREATE TABLE t (a int NOT NULL, PRIMARY KEY (a) USING BTREE); > will trigger an 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
Please checkout and try current trunk: https://sqlfairy.svn.sourceforge.net/svnroot/sqlfairy/trunk/sqlfairy
  Sun Feb 14 05:07:11 2010 The RT System itself - Status changed from 'new' to 'open'
  Sun Feb 14 05:07:12 2010 ribasushi [...] leporine.io - Status changed from 'open' to 'patched'
  Thu Feb 18 09:53:11 2010 sk [...] computer-leipzig.com - Correspondence added
It still does not work with a line like: UNIQUE KEY IDX_SAMPLE (entry_id,category_id) USING BTREE,
  Thu Feb 18 09:53:15 2010 The RT System itself - Status changed from 'patched' to 'open'
  Tue Feb 23 07:31:20 2010 ribasushi [...] leporine.io - Correspondence added
On Thu Feb 18 09:53:11 2010, SKNPP wrote: Show quoted text
> It still does not work with a line like: > > UNIQUE KEY IDX_SAMPLE (entry_id,category_id) USING BTREE,
Try latest trunk again please.
  Fri Feb 26 18:38:04 2010 ribasushi [...] leporine.io - Correspondence added
On Thu Feb 18 09:53:11 2010, SKNPP wrote: Show quoted text
> It still does not work with a line like: > > UNIQUE KEY IDX_SAMPLE (entry_id,category_id) USING BTREE,
In fact try SQL::Translator 0.11005
  Wed Mar 03 18:21:56 2010 ribasushi [...] leporine.io - Fixed in 0.11005 added
  Wed Mar 03 18:21:57 2010 ribasushi [...] leporine.io - Correspondence added
Assuming fixed. Feel free to reopen ticket if problem persists.
  Wed Mar 03 18:22:01 2010 ribasushi [...] leporine.io - Status changed from 'open' to 'resolved'