Skip to content

[MySQL] Query: Named arg is null or in slice caused Postgres import #3783

Open
@terwey

Description

@terwey

Version

1.27.0

What happened?

When a query checks if a sqlc.narg is null OR in a sqlc.slice it causes "github.com/lib/pq" to be imported.
Simply id IN (sqlc.slice('author_ids') does not.

Relevant log output

No response

Database schema

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

SQL queries

-- name: CausesPgToBeImported :many
SELECT 
    id AS author_id,
    name AS author_name,
    bio AS author_bio
FROM 
    authors
WHERE 
    (sqlc.narg('author_ids') IS NULL OR id IN (sqlc.slice('author_ids')));

Configuration

version: "2"
sql:
  - engine: "mysql"
    queries: "query.sql"
    schema: "schema.sql"
    gen:
      go:
        package: "tutorial"
        out: "tutorial"

Playground URL

https://play.sqlc.dev/p/0393067265d4e28076917f8b00b10e81d231a95ca79cdf222cf8ed61de62bffa

What operating system are you using?

macOS

What database engines are you using?

MySQL

What type of code are you generating?

Go

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions