search

cockroachdb / docs

CockroachDB user documentation
https://cockroachlabs.com/docs
Creative Commons Attribution 4.0 International
187 stars 453 forks source link

sql: document know limitation about inverted indexes on primary key columns #14554

Open jordanlewis opened 2 years ago

jordanlewis commented 2 years ago

Jordan Lewis (jordanlewis) commented:

Starting in 22.2, there will be a datatype in SQL (text) that's indexable both with an ordinary index and with an inverted index (using the gin_trgm_ops trigram inverted index flag). We're adding a known limitation in https://github.com/cockroachdb/cockroach/pull/84412 that prevents inverted indexing a column that's also part of the primary key.

It would be great to document this in general, and especially in the case of trigrams.

Jira Issue: DOC-5022

mgartner commented 2 months ago

There's a workaround described here: https://github.com/cockroachdb/cockroach/issues/84405#issuecomment-2176519252

exalate-issue-sync[bot] commented 2 months ago

Richard Loveland (rmloveland) commented: FYI this limitation just came up in an internal convo