Skip Menu |

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

Report information
The Basics
Id: 46448
Status: resolved
Worked: 4 hours (240 min)
Priority: 0/
Queue: SQL-Translator

People
Owner: kclark [...] cpan.org
Requestors: damien [...] grassart.com
Cc:
AdminCc:

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



Subject: sqlt-graph errors out on MySQL DDL with btree keys
A line such as this in a create table statement: KEY `D_Answer_F_Survey_Activity` USING BTREE (`answer_key`,`consumer_key`) Produces these errors: ERROR (line 642): Invalid constraint: Was expecting primary key def, or unique key def, or foreign key def ERROR (line 642): Invalid index: Was expecting normal index, or fulltext index, or spatial index ERROR (line 642): Invalid field: Was expecting data type but found "`D_Answer_F_Survey_Activity` USING BTREE (`answer_key`,`consumer_key`)" instead ERROR (line 642): Invalid create definition: Was expecting constraint, or index, or field, or comment ERROR (line 613): Invalid statement: Was expecting comment, or use, or set, or drop, or create, or alter, or insert, or delimiter, or empty statement When I remove the "USING BTREE" part, the errors go away. Thanks, -Damien
Finally added parsing of 'using (btree|rtree|hash)'.