GoogleCloudPlatform / GoogleCloudPlatform/spanner-migration-tool

Feature: Support fulltext indexes

Open
#109 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
PLpgSQL
Stars
155
Forks
83
Avg merge
3d 7h
Merged PRs (30d)
6

Description

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

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.