cockroachdb / cockroachdb/cockroach
sql: support numeric literals
Open
A-sql-pgcompat
C-bug
E-quick-win
O-pg-regress
P-3
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
postgres supports the following syntax for numeric literals, which results in a lexical error in crdb:
```
SELECT 0b100101;
-- 37
SELECT 0o273;
-- 187
SELECT .000_005;
-- 0.000005
```
Found in pg_regress numerology.
Jira issue: CRDB-33910
Contributor guide
Assessment
This issue has not been assessed yet.