cockroachdb / cockroachdb/cockroach
jsonpath: incorrect `type()` result
Open
branch-master
branch-release-25.2
C-bug
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
Found via `pg_regress`.
```sql
-- PG returns "boolean"
-- CRDB returns "null"
select jsonb_path_query('[1, 2, 3]', '($[*].a > 3).type()');
```
Jira issue: CRDB-49880
Contributor guide
Assessment
This issue has not been assessed yet.