Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

CockroachDB Gin String Indexes #5000

Open
FxEasy opened this issue Sep 18, 2024 · 0 comments
Open

CockroachDB Gin String Indexes #5000

FxEasy opened this issue Sep 18, 2024 · 0 comments

Comments

@FxEasy
Copy link

FxEasy commented Sep 18, 2024

CockroachDb allows for gin indexes on string types using the gin_trgm_ops function which comes with it.

https://github.com/prisma/prisma-engines/blob/main/psl/parser-database/src/types.rs#L417-L440

In the provided github link we check if the value is a certain type to allow the GIN operator.

There should either be extra handling for psql and cockroachdb to support this gin_trgm_ops function on top of the Gin index to allow for string types to be indexed properly using a Gin Trigram; or a workaround to not error when it's used in the schema itself.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant