spanner-migration-tool icon indicating copy to clipboard operation
spanner-migration-tool copied to clipboard

Feature: Support fulltext indexes

Open nevinheintze opened this issue 4 years ago • 0 comments

HarbourBridge's current treatment of fulltext indexes (mysql) and equivalent functionality in postgres (GIN and GiST indexes) is partial and inconsistent.

With the mysql driver, fulltext indexes are mapped to regular Spanner indexes.

With the mysqldump driver, fulltext indexes are silently ignored/dropped.

We should:

  • figure out how we want to handle fulltext indexes (only realistic options at present are (a) drop them and document this in the report, or (b) map them to regular indexes, which probably isn't useful)
  • implement this consistently across dump and direct drivers (and for both mysql and postgres)
  • update this treatment as new features are available on Spanner

nevinheintze avatar Jan 31 '21 03:01 nevinheintze