Skip to content

cdc: disallow stable casts in cdc expressions #90354

@HonoreDB

Description

@HonoreDB
root@localhost:26257/defaultdb> create changefeed with schema_change_policy='stop' as select d::timestamptz from hasdates;
{"key":"[806776683378376705]","table":"hasdates","value":"{\"d\": \"2022-10-20T00:00:00Z\"}"}

Stable casts like other stable functions should be disallowed by default in cdc expressions as they depend on session data that isn't available when evaluating.

Jira issue: CRDB-20727

Epic CRDB-17161

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-cdcChange Data CaptureA-cdc-expressionsFeatures related to changefeed projections and filtersC-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.T-cdc

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions