CODEWITHSUNDEEP
mysqlliquibase
Stepan Yakovenko
Stepan Yakovenko

Reputation: 9206

Liquibase is not capable with partial keys?

I execute sql generated by liquibase and I get:

CREATE INDEX `messageId_IDX` ON `messagedetails`(`messageId`);

ERROR 1170 (42000) at line 275: BLOB/TEXT column 'messageId' used in key specification without a key length

My original sql was: 

CREATE INDEX messageId_IDX ON MessageDetails(MessageID(128))

is it a bug in liquibase? Or am I missing something?

Upvotes: 1

Views: 736

Answers (1)

Geert
Geert

Reputation: 3767

Currently Liquibase doesn't support setting an index length. See this unresolved feature request for it, as well as this mailing list thread

Upvotes: 2

Related Questions