cockroachdb / cockroachdb/cockroach
sqlsmith: don't generate IN NULL::RECORD clauses
Open
C-bug
E-quick-win
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
```
CREATE TABLE t2 (c2 int);
SELECT c2 FROM t2 WHERE c2 IN NULL::RECORD;
```
PG fails too:
```❯ psql -f ~/sqlsmith.sql
CREATE TABLE
psql:/Users/treilly/sqlsmith.sql:2: ERROR: syntax error at or near "NULL"
LINE 1: SELECT c2 FROM t2 WHERE c2 IN NULL::RECORD;
```
Just need to fix sqlsmith to not generate this.
Jira issue: CRDB-30512
Contributor guide
Assessment
This issue has not been assessed yet.