Repository navigation
Can't use name parameters for less than/greater than conditions #1439
Description
Version
1.12.0
What happened?
I tried to use named params for greater than check, but I get a syntax error. Works with $1 in place of @offset. Also sqlc.arg does not work either.
Relevant log output
# package query
queries/relations.sql:1:1: syntax error at or near "offset"Database schema
CREATE TABLE IF NOT EXISTS permission_group_membership (
group_name TEXT NOT NULL,
entity TEXT NOT NULL,
ns TEXT NOT NULL,
object TEXT NOT NULL,
PRIMARY KEY(ns, group_name, entity)
);SQL queries
SELECT *
FROM permission_group_membership
WHERE entity > @offset
LIMIT 50;Configuration
version: 1
packages:
- path: "query"
name: "query"
engine: "postgresql"
schema: "sqlcSchema.sql"
queries: "./queries/"
sql_package: "pgx/v4"Playground URL
No response
What operating system are you using?
macOS
What database engines are you using?
PostgreSQL
What type of code are you generating?
Go
Activity
danielbprice commentedon Mar 31, 2022
@danthegoodman1 I think that what you are hitting here is a problem with the use of the token
offset-- which is also reserved in SQL (i.e.LIMITandOFFSET). I plugged your code into the sqlc playground and reproduced the problem, but when I changedoffsettotheoffsetit worked. Dunno if that helps.https://play.sqlc.dev/p/6073003aaa3db6eae4250aee0de4c82ed28c7864064671fd50761341a9a900d0
Possibly it would be good to update the title of the issue to "cannot use
offsetas an input param name" or similar. You might need to experiment to see how widespread this problem is, I don't know. I triedlimitand it produced a similar issue.danthegoodman1 commentedon Apr 2, 2022
Ahh that could make sense, will have to try
bokunodev commentedon Jul 13, 2022
using the verbose sqlc.arg or narg work though.
kyleconroy commentedon Aug 28, 2022
Closing this one as there are two workarounds. I'm not sure we'll be able to get around using a reserved word with short-hand syntax.