cockroachdb / cockroachdb/cockroach

sql: casts from integers to "char" do not match Postgres

Open
#102,485 0 comments 0 reactions 0 assignees View on GitHub
C-bug T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

Some examples in Postgres:

```
marcus=# SELECT 12345::INT2::"char";
char
------
1
(1 row)

marcus=# SELECT 12345::INT4::"char";
ERROR: 22003: "char" out of range
LOCATION: i4tochar, char.c:169

marcus=# SELECT 12345::INT8::"char";
char
------
1
(1 row)
```

In CRDB v22.2.6:

```
defaultdb> SELECT 12345::INT2::"char";
ERROR: "char" out of range
SQLSTATE: 22003

defaultdb> SELECT 12345::INT4::"char";
ERROR: "char" out of range
SQLSTATE: 22003

defaultdb> SELECT 12345::INT8::"char";
ERROR: "char" out of range
SQLSTATE: 22003
```

Jira issue: CRDB-27480

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.