Diff support for tables using fulltext index WITH PARSER

skeema / tengo

Go La Tengo: a MySQL automation library

Apache License 2.0

27 stars 19 forks source link

Diff support for tables using fulltext index WITH PARSER #13

Closed patdz closed 4 years ago

patdz commented 4 years ago

 FULLTEXT KEY `title_index` (`title`) /*!50100 WITH PARSER `ngram` */

evanelias commented 4 years ago

Thank you for the issue report. I don't think MySQL exposes the parser name anywhere in information_schema, so this will require parsing SHOW CREATE TABLE output. Converting this issue into a feature request accordingly.

evanelias commented 4 years ago

This is now implemented in master, and will be included in the next release (v0.9.3) within the next couple weeks.

evanelias commented 4 years ago

Happy to announce that this change has been included in today's release of Skeema CLI v1.4.3. Additionally, the SaaS Skeema.io CI service now supports use of the ngram parser in MySQL 5.7+ and Percona Server 5.7+, as these database versions ship with that parser pre-installed.