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