cockroachdb / cockroachdb/cockroach
sql: support large numeric literals
Open
A-sql-pgcompat
C-bug
O-pg-regress
P-3
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
The following numeric literal is valid in postgres, but not crdb:
```
SELECT -0x8000000000000001;
-- postgres: -9223372036854775809
-- crdb: ERROR: could not evaluate -0x8000000000000001 as Datum type DDecimal from string "0x8000000000000001": could not parse "0x8000000000000001" as type decimal: parse mantissa: 0x8000000000000001
```
Found in pg_regress numerology
Jira issue: CRDB-33911
Contributor guide
Assessment
This issue has not been assessed yet.