Repository navigation
No parameter gets generated for CASE ? WHEN... #2847
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
What operating system are you using?
macOS
What database engines are you using?
MySQL
What type of code are you generating?
Go
Activity
fix(mysql): Handle simplified CASE statements (#2852)
fix(mysql): Handle simplified CASE statements (sqlc-dev#2852)