Skip to content

cdc: apparent inconsistent behavior when using % in cdc expressions #90421

@HonoreDB

Description

@HonoreDB

Random testing saw a different set of results (both nonempty) when running SELECT rowid FROM seed WHERE (_string::STRING % _string::STRING)::BOOL as a regular select vs cdc expression. More details to come, hopefully. Might be an issue with my test harness.

Edit: Okay, the context here is that string mod string is a trigram operation that depends on session data, so should be disallowed (or we need a methodical approach, same question as in #90354).

Jira issue: CRDB-20759

Epic CRDB-17161

Metadata

Metadata

Assignees

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