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.

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

CASE, WHEN, ELSE support is incomplete for MySQL #271

Open
sollniss opened this issue Oct 9, 2024 · 0 comments
Open

CASE, WHEN, ELSE support is incomplete for MySQL #271

sollniss opened this issue Oct 9, 2024 · 0 comments

Comments

@sollniss
Copy link

sollniss commented Oct 9, 2024

CASE, WHEN, ELSE support got added with #266, but it does not seem to support all use-cases.

In MySQL the following is valid SQL:

update tbl set col = case when 1 = 2 then 'val' else col end

With the current implementation you can't use dbr.Case in update statements and you can also not provide a column name in dbr.Else.

Please consider adding these two features.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant