-
Notifications
You must be signed in to change notification settings - Fork 964
Closed
Labels
Milestone
Description
Version
1.22.0
What happened?
I use a CASE statement of the form CASE ? WHEN true THEN '1' WHEN false THEN '0' ELSE NULL END.
The generated Go function has no parameters for the ?.
Relevant log output
No response
Database schema
CREATE TABLE testing (
id int PRIMARY KEY,
value text
);SQL queries
UPDATE testing
SET value = CASE ? WHEN true THEN 'Hello' WHEN false THEN 'Goodbye' ELSE value END;Configuration
{
"version": "1",
"packages": [
{
"path": "db",
"engine": "mysql",
"schema": "query.sql",
"queries": "query.sql"
}
]
}Playground URL
https://play.sqlc.dev/p/c6a70bea34b4e836d2cc998f885ae6c51d2234632ebe9de53865c23a68588dc6
What operating system are you using?
macOS
What database engines are you using?
MySQL
What type of code are you generating?
Go