cockroachdb / cockroachdb/cockroach
QA: TSQuery parser cannot parse consecutive ! operators
Open
C-bug
O-qa
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
The TSQuery parser cannot handle consecutive `!` (NOT) operators separated by whitespace, but this works in Postgres:
```sql
SELECT 'fats cats ate fat rats' @@ '! !(cats | bat & rats)'::tsquery;
ERROR: could not parse tsquery: syntax error in TSQuery: ! !(cats | bat & rats)
SQLSTATE: 42601
```
Wrapping the expression in parentheses works:
`SELECT 'fats cats ate fat rats' @@ '!(!(cats | bat & rats))'::tsquery;`
Jira issue: CRDB-25562
Contributor guide
Assessment
This issue has not been assessed yet.