Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sql/cdc: TestChangefeedRandomExpressions/kafka error: cannot subtract infinite dates #113842

Open
rharding6373 opened this issue Nov 5, 2023 · 1 comment
Labels
A-cdc Change Data Capture C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. T-cdc

Comments

@rharding6373
Copy link
Collaborator

rharding6373 commented Nov 5, 2023

Original error: https://teamcity.cockroachdb.com/viewLog.html?buildId=12496837&buildTypeId=Cockroach_BazelEssentialCi&tab=buildResultsDiv

Here's a reduced repro (no artifacts in the build):

CREATE TABLE seed (_date DATE, _inet INET);
INSERT INTO seed VALUES ('infinity'::DATE, '0.0.0.0'::INET);
CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (set_masklen(seed._inet::INET, (seed._date::DATE - seed._date::DATE)::INT8::INT8)::INET = seed._inet);

-- Note that the following statement without changefeed doesn't error, because the subtraction is optimized out of the plan.
SELECT rowid FROM seed WHERE (set_masklen(seed._inet::INET, (seed._date::DATE - seed._date::DATE)::INT8::INT8)::INET = seed._inet);

I would either expect 1) The subtraction can be removed from the changefeed plan, or 2) The randomized test can tolerate such failures.

Jira issue: CRDB-33219

@rharding6373 rharding6373 added the C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. label Nov 5, 2023
Copy link

blathers-crl bot commented Nov 10, 2023

cc @cockroachdb/cdc

@blathers-crl blathers-crl bot added the A-cdc Change Data Capture label Nov 10, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-cdc Change Data Capture C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. T-cdc
Projects
None yet
Development

No branches or pull requests

4 participants