Skip to content

upsert with arg or narg doesn't work in sqlite3 #3508

@yopoyka

Description

@yopoyka

Version

1.25.0

What happened?

sqlc fails to generate query placeholders and leaves @arg sqlc.arg sqlc.narg in generated query when doing upsert.
Doesn't output any errors.
Possibly related to #1881

Generated code from playground

const upsertAuthor = `-- name: UpsertAuthor :one
insert into authors (
  "id",
  "name",
  "bio"
) values (
  ?1,
  ?2,
  ?3
) on conflict("id") do update set
  "name" = @name,
  "bio" = sqlc.narg('bio')
returning id, name, bio
`

Relevant log output

No response

Database schema

create table authors (
  id   text primary key,
  name text not null,
  bio  text
);

SQL queries

-- name: UpsertAuthor :one
insert into authors (
  "id",
  "name",
  "bio"
) values (
  @id,
  @name,
  sqlc.narg('bio')
) on conflict("id") do update set
  "name" = @name,
  "bio" = sqlc.narg('bio')
returning *;

Configuration

{
  "version": "2",
  "sql": [{
    "schema": "schema.sql",
    "queries": "query.sql",
    "engine": "sqlite",
    "gen": {
      "go": {
        "out": "db"
      }
    }
  }]
}

Playground URL

https://play.sqlc.dev/p/4b01c7bd73781a3aeaf17fa1c9fba826640a5907f97b2faaee51ccac9197d00e

What operating system are you using?

Linux

What database engines are you using?

SQLite

What type of code are you generating?

Go

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions