Skip to content

[SQL] SAFE_CAST(ROW(v1 VARCHAR NULL), ROW(i1 INT)) produces a runtime panic #5389

@rivudhk

Description

@rivudhk

Following SQL:

CREATE TABLE tbl(roww ROW(v1 VARCHAR NULL) NULL);

CREATE MATERIALIZED VIEW v AS SELECT
SAFE_CAST(roww AS ROW(i1 INT)) AS to_row
FROM tbl;

Given example input:
"roww": {"v1": "cat"}

Panics with the following error message:

DBSP error: runtime error: One or more worker threads terminated unexpectedly
foreground worker thread 7 panicked
panic message: line 5 column 1: Error converting 'cat' to INTEGER: invalid digit found in string

Metadata

Metadata

Assignees

Labels

SQL compilerRelated to the SQL compiler

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions