SQLite cannot use `not in` with `sqlc.slice`

[jamietanna]

Version

1.20.0

What happened?

When attempting to use NOT IN with an sqlc.slice of arguments, the generated SQL query in the Go code results in:

const getAuthorNotIn = `-- name: GetAuthorNotIn :many
SELECT id, name, bio FROM authors
where true != false
 and id not in (sqlc.slice('userIDs'))
`

Which as we can see has not correctly interpolated the sqlc.slice.

This works when using IN, but not when there's a NOT IN.

Relevant log output

No response

Database schema

CREATE TABLE authors (
 id BIGSERIAL PRIMARY KEY,
 name text NOT NULL,
 bio text
);

SQL queries

-- name: GetAuthorIn :many
SELECT id, name, bio FROM authors
where id in (sqlc.slice('userIDs'));
 
-- name: GetAuthorNotIn :many
SELECT id, name, bio FROM authors
where id not in (sqlc.slice('userIDs'));

Configuration

{
 "version": "1",
 "packages": [
 {
 "path": "db",
 "engine": "sqlite",
 "schema": "query.sql",
 "queries": "query.sql"
 }
 ]
}

Playground URL

https://play.sqlc.dev/p/5da40f5dacdf8eebf5f92c67e572bac04c578a58e4629dd64c752bb99a9189ae

What operating system are you using?

Linux

What database engines are you using?

SQLite

What type of code are you generating?

Go

[jamietanna]

Thank you 👏🏽