We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
Interestingly, we got a `not(others) or others` which equals true. We could use another rule to simplify this condition.
Originally posted by @chenzl25 in #14127 (comment)
The text was updated successfully, but these errors were encountered:
Both of the following examples can be simplified into true.
StreamFilter { predicate: (Not((t1.ts > '2023-12-18 00:00:00+00:00':Timestamptz)) OR (t1.ts > '2023-12-18 00:00:00+00:00':Timestamptz)) }
StreamFilter { predicate: (((Not((t1.ts > '2023-12-18 00:00:00+00:00':Timestamptz)) AND Not(IsNull(t1.ts))) OR (t1.ts > '2023-12-18 00:00:00+00:00':Timestamptz)) OR IsNull(t1.ts)) }
Sorry, something went wrong.
Both of the following examples can be simplified into true. StreamFilter { predicate: (Not((t1.ts > '2023-12-18 00:00:00+00:00':Timestamptz)) OR (t1.ts > '2023-12-18 00:00:00+00:00':Timestamptz)) }
This predicate can be simplified to IsNotNull(t1.ts) rather than true. Right?
IsNotNull(t1.ts)
true
https://www.postgresql.org/docs/current/functions-logical.html
related: #12931
For batch plan, something like below could also be optimized, e.g.,
chenzl25
xzhseh
Successfully merging a pull request may close this issue.
Originally posted by @chenzl25 in #14127 (comment)
The text was updated successfully, but these errors were encountered: