-
Notifications
You must be signed in to change notification settings - Fork 4.1k
cdc: cdceval type resolution has trouble with nullable columns #90455
Copy link
Copy link
Closed
Labels
A-cdcChange Data CaptureChange Data CaptureA-cdc-expressionsFeatures related to changefeed projections and filtersFeatures related to changefeed projections and filtersC-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.T-cdc
Description
root@localhost:26257/defaultdb> select s, s || s from manystrings limit 3;
s | ?column?
--------+-------------
|
NULL | NULL
hello | hellohello
(3 rows)
Time: 1ms total (execution 1ms / network 0ms)
root@localhost:26257/defaultdb> create changefeed with schema_change_policy='stop' as select s || s from manystrings;
{"key":"[807033528558616577]","table":"manystrings","value":"{\"column_1\": \"\"}"}
(error encountered after some results were delivered)
ERROR: while evaluating projection: SELECT s || s FROM [122 AS manystrings]: ambiguous binary operator: <unknown> || <unknown>
Jira issue: CRDB-20778
Epic CRDB-17161
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-cdcChange Data CaptureChange Data CaptureA-cdc-expressionsFeatures related to changefeed projections and filtersFeatures related to changefeed projections and filtersC-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.T-cdc