Skip to content

Code created with duplicated fields #2429

Open
@leobrines

Description

@leobrines

Version

Other

What happened?

Hi guys!

It generates an invalid go struct when there are duplicated fields at schema. Go compiler generates a redeclared field error.

type Tournament struct {
	ID     string
	Status sql.NullString
	Status sql.NullString
}

Using sqlc version 1.19.0

Relevant log output

No response

Database schema

CREATE TABLE tournaments (
    id VARCHAR(255) NOT NULL,
    status VARCHAR(255),
    status VARCHAR(255)
);

SQL queries

-- name: FindTournamentByID :one
SELECT *
FROM tournaments
WHERE id = ?;

Configuration

{
  "version": "1",
  "packages": [
    {
      "path": "sqlite",
      "name": "sqlite",
      "schema": "query.sql",
      "queries": "query.sql",
      "engine": "sqlite",
      "emit_json_tags": false,
      "emit_prepared_queries": true,
      "emit_interface": true
    }
  ]
}

Playground URL

https://play.sqlc.dev/p/9dadfd2d3b03f88c36209c864a83167e464cb327d8cb5a31aea62242b5b5fb58

What operating system are you using?

Windows

What database engines are you using?

SQLite

What type of code are you generating?

Go

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions