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

✨ rewrite CASE WHEN x IS NULL THEN y ELSE x as IFNULL(x, y) #2293

Closed
joocer opened this issue Jan 23, 2025 · 0 comments · Fixed by #2353
Closed

✨ rewrite CASE WHEN x IS NULL THEN y ELSE x as IFNULL(x, y) #2293

joocer opened this issue Jan 23, 2025 · 0 comments · Fixed by #2353

Comments

@joocer
Copy link
Contributor

joocer commented Jan 23, 2025

IFNULL is faster than executing CASE.
joocer added a commit that referenced this issue Feb 4, 2025
@joocer
✨ rewrite CASE WHEN x IS NULL THEN y ELSE x as IFNULL(x, y) #2293
da06c6f
@joocer joocer mentioned this issue Feb 4, 2025
Merged
4 tasks
joocer added a commit that referenced this issue Feb 4, 2025
@joocer
Merge branch 'main' into #2293
6a68b51
joocer added a commit that referenced this issue Feb 4, 2025
@joocer
Merge pull request #2353 from mabel-dev/#2293
4df9c50 
✨ rewrite `CASE WHEN x IS NULL THEN y ELSE x` as `IFNULL(x, y)` #2293
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

✨ rewrite CASE WHEN x IS NULL THEN y ELSE x as IFNULL(x, y) #2293 mabel-dev/opteryx
1 participant
@joocer