Length on indexes are ignored

[Stevehans]

For example if an index is defined as INDEX LoginCheck (ip, action(200))

The 200 is ignored and the schema comparison just creates:

/****** Indexes ******/
CREATE INDEX LoginCheck ON sys_audit(ip,action);

[drebrez]

Hi @Stevehans

Thanks for opening this issue.

The action(200) syntax (Prefix Indexes) is a feature specific to MySQL/MariaDB databases, is it correct?

I will look into it and try to provide a new version that supports it.

Best regards

[Stevehans]

Yes, sorry, I completely forgot to add any context!

MySQL in my case, I'll check whether any of the other databases support shortened fields in indexes and update here

[Stevehans]

Not supported in Postgresql or MS-SQL

[drebrez]

Hi @Stevehans,

I've added the support for the index prefix length, I'll soon release a new version.

Best regards