search

gimenete / dbdiff

Compares two postgresql or mysql databases and prints SQL commands to modify the first one in order to match the second one
MIT License
131 stars 36 forks source link

Inform: not handle case Error : BLOB/TEXT column {{columnname}} used in key specification without a key length #13

Open baszealot13 opened 7 years ago

baszealot13 commented 7 years ago

for ex: this command below is solution after diff. ALTER TABLE table_name ADD INDEX matchID USING BTREE (column_text); but i get error "BLOB/TEXT column {{columnname}} used in key specification without a key length" because that column defined "TEXT" type.

must be like command below ALTER TABLE table_name ADD INDEX matchID USING BTREE (column_text(20));

How should I do?, please suggest.

Thanks