cockroachdb / cockroachdb/cockroach
QA: TSVector/TSQuery support deprecated operator @@@
Open
C-bug
O-qa
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
From [TSVector and TSQuery QA](https://gist.github.com/msirek/2c4aef2a3c2038f6b9f3a6fa443ad6da),
The following test case uses operator `@@@`, which is a deprecated form of `@@` in Postgres, and errors out in CRDB:
```sql
SELECT 'fat:2,4 cat:3 rat:5A'::tsvector @@@ '(fat & rat) | cat'::tsquery;
```
For full Postgres compatibility, CRDB should support the deprecated operator.
Jira issue: CRDB-38352
Contributor guide
Assessment
This issue has not been assessed yet.