SQLite- arguments swapped in SQL clauses

[janbiehl]

When generating the source for the below sql query the following sql is generated in the c# source file. We see that the arguments "skip" & "take" are swapped.

-- name: GetItemsPaginated :many
SELECT items.*, count(*)
FROM items
WHERE is_deleted = 0
ORDER BY item_number
LIMIT sqlc.arg('take') 
OFFSET sqlc.arg('skip');

private const string GetItemsPaginatedSql = "SELECT items.id, items.display_name, items.item_number, items.barcode, items.is_deleted, count(*) FROM  items  WHERE  is_deleted  =  0  ORDER  BY  item_number  LIMIT  @skip  OFFSET  @take  ";  

[SockworkOrange]

Can you please attach your schema file as well?
Also, I see that you're using COUNT function without a GROUP BY, which is at least weird:)
nce you provide your schema file we can debug and check the issue.

[SockworkOrange]

@janbiehl I was able to replicate the issue. Still investigating whether it's an issue with SQLC or the plugin, but as a workaround for now you can use this syntax instead of named arguments:

-- name: GetItemsPaginated :many
SELECT items.*, count(*)
FROM items
WHERE is_deleted = 0
ORDER BY item_number
LIMIT ? 
OFFSET ?;

[janbiehl]

Sorry, that i missed providing the schema file. I could try to test the same thing with go. I think this should give a direction.

[SockworkOrange]

Figured out the issue, definitely a bug in the plugin. Working on a fix

[SockworkOrange]

@janbiehl fixed in release v0.20.0 + working example in here