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.

Sign up for GitHub

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

Jump to bottom

opt: detect contradictions with inequalities against "boundary" values #80402

Open
yuzefovich opened this issue Apr 22, 2022 · 2 comments
Open

opt: detect contradictions with inequalities against "boundary" values #80402

yuzefovich opened this issue Apr 22, 2022 · 2 comments
Labels
C-performance Perf of queries or internals. Solution not expected to change functional behavior. E-quick-win Likely to be a quick win for someone experienced. T-sql-queries SQL Queries Team
Projects
SQL Queries

Comments

@yuzefovich
Copy link
Member

yuzefovich commented Apr 22, 2022 •
edited by cockroach-jira-scripts

Currently, the optimizer is not smart enough to understand that e > 9223372036854775807 filter is a contradiction (where e is INT8 and the number if MaxInt64). We should improve here.

Jira issue: CRDB-15624
@yuzefovich yuzefovich added the C-performance Perf of queries or internals. Solution not expected to change functional behavior. label Apr 22, 2022
@yuzefovich yuzefovich added this to Triage in SQL Queries via automation Apr 22, 2022
@blathers-crl blathers-crl bot added the T-sql-queries SQL Queries Team label Apr 22, 2022
@michae2 michae2 added the E-quick-win Likely to be a quick win for someone experienced. label Apr 26, 2022
@michae2 michae2 moved this from Triage to Backlog in SQL Queries Apr 26, 2022
@michae2
Copy link
Collaborator

michae2 commented Apr 26, 2022

Good first issue?

@jlinder jlinder added sync-me and removed sync-me labels May 20, 2022
@github-actions GitHub Actions
Copy link

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
C-performance Perf of queries or internals. Solution not expected to change functional behavior. E-quick-win Likely to be a quick win for someone experienced. T-sql-queries SQL Queries Team
Projects
SQL Queries
Status: Backlog
SQL Queries
Backlog (DO NOT ADD NEW ISSUES)
Milestone
No milestone
Development

No branches or pull requests
3 participants
@jlinder @yuzefovich @michae2