You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
-- name: GetThings :manySELECT
a,
count(b) as cnt
FROM myTable
WHERELOWER(a) IN (sqlc.slice('a'))
AND b IN (sqlc.slice('b'))
GROUP BY a
ORDER BY cnt DESCLIMIT ?;
mlucic
changed the title
Using LOWER on column in WHERE clause does not generate parameter
Using function on column in WHERE clause does not generate parameter
Jun 24, 2024
Version
1.26.0
What happened?
This issue appears to be the same found in #103
Given a table with string column
a
and number columnb
, the following query will not generate a parameter for columna
.Removing the
LOWER()
invocation results in the parameter being createdRelevant log output
Database schema
SQL queries
Configuration
Playground URL
https://play.sqlc.dev/p/c59b57d2349c28a5ec9dee78a1a5ffbb64bea2853bb289e5b4aa19990980a9ca
What operating system are you using?
Linux
What database engines are you using?
MySQL
What type of code are you generating?
Go
The text was updated successfully, but these errors were encountered: