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

Error on CASE statements when result is not bool #787

Closed
ajnavarro opened this issue Jul 9, 2019 · 0 comments · Fixed by #788
Closed

Error on CASE statements when result is not bool #787

ajnavarro opened this issue Jul 9, 2019 · 0 comments · Fixed by #788
Assignees
@erizocosmico
Labels
bug Something isn't working

Comments

@ajnavarro
Copy link
Contributor

This query:

select CASE WHEN NULL THEN "yes" ELSE "no" END AS test

Is throwing the following error:

ERROR 1105 (HY000): unknown error: unable to cast nil to bool

But it should return no
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: correctly evaluate conditions in CASE erizocosmico/go-mysql-server
2 participants
@ajnavarro @erizocosmico