Skip to content
This repository has been archived by the owner on Jan 28, 2021. It is now read-only.

Cannot return NULL in a CASE branch #740

Closed
smola opened this issue Jun 3, 2019 · 0 comments · Fixed by #741
Closed

Cannot return NULL in a CASE branch #740

smola opened this issue Jun 3, 2019 · 0 comments · Fixed by #741
Assignees
@erizocosmico
Labels
bug Something isn't working

Comments

@smola
Copy link
Collaborator

smola commented Jun 3, 2019

When using CASE WHEN x THEN "foo" ELSE NULL END, I get the following error: unknown error: expecting all case branches to return values of type TEXT, but found value "<nil>" of type NULL on CASE WHEN ...
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees

@erizocosmico erizocosmico

Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

sql/expression: allow null literals in case branches erizocosmico/go-mysql-server
2 participants
@smola @erizocosmico