Issues

• Using REPLACE instead of INSERT with :copyfrom in MySQL doesn't add REPLACE to resulting LOAD DATA LOCAL INFILE query

  📚 mysqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#4339 · Filter by author maglicheev-check24 opened on Mar 13, 2026

• MySQL copyfrom throws "can't encode type models.ExperienceLocationsType to TSV" if models.ExperienceLocationsType is a string enum

  📚 mysqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#4324 · Filter by author maglicheev-check24 opened on Mar 5, 2026
  1

• Column/table references inside aggregate functions are not validated against the schema

  📚 postgresqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#4300 · Filter by author Jorann opened on Feb 16, 2026
  1

• MySQL/Golang - Wrong generated argument type for DATEDIFF comparison

  📚 mysqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#4268 · Filter by author maglicheev-check24 opened on Jan 19, 2026

• Non-valid subquery generation

  📚 sqlitebug💻 darwin🔧 golang
  sqlc-dev/sqlc#4223 · Filter by author TobiasGleiter opened on Dec 9, 2025
  1

• Optional WHERE parameters via $1 IS NULL OR - redeclared in this block - query_parameter_limit

  📚 mysqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#4191 · Filter by author sergeishilkocardmarket opened on Nov 21, 2025
  2

• Unable to generate queries using "SET" and "SET LOCAL"

  📚 postgresqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#4186 · Filter by author pitasi opened on Nov 19, 2025
  2

• Postgres COPY with ltree column error: "unsupported ltree version"

  📚 postgresqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#4185 · Filter by author jameshochadel opened on Nov 18, 2025
  1

• LATERAL subquery cannot resolve outer table columns

  📚 postgresqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#4182 · Filter by author WillAbides opened on Nov 13, 2025

• Type clash between enums from different tables

  📚 mysqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#4162 · Filter by author olivierboucher opened on Oct 30, 2025

• Limit/Offset use int32 instead of int64 with schema file vs managed db

  📚 postgresqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#4142 · Filter by author pgr0ss opened on Oct 16, 2025

• Unexpected extra fields in Params struct when using BETWEEN and joining tables with same column names

  📚 mysqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#4135 · Filter by author KoheiMatsuno99 opened on Oct 12, 2025
  1

• Seg fault when running in Docker

  📚 postgresqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#4131 · Filter by author denialanderror opened on Oct 7, 2025
  2

• Can not handle cross-schema inheritance in postgres

  📚 postgresqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#4128 · Filter by author axlalmflower opened on Oct 6, 2025
  1

• Can't parse SQLite json_array_agg with ORDER BY clause

  📚 sqlitebug💻 darwin🔧 golang
  sqlc-dev/sqlc#4125 · Filter by author rosszurowski opened on Oct 4, 2025

• Codegen not producing nullable output values when using LEFT Joins and subqueries (GO)

  📚 postgresqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#4117 · Filter by author werjo-gridfuse opened on Sep 29, 2025

• sqlc.Narg does not work with array enums

  📚 postgresqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#4113 · Filter by author kilofeq opened on Sep 23, 2025

• Wrong number of arguments passed in generated function

  📚 sqlitebug💻 darwin🔧 golang
  sqlc-dev/sqlc#4104 · Filter by author philz opened on Sep 13, 2025

• WITH RECURSIVE JOIN column reference "id" is ambiguous

  📚 postgresqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#4094 · Filter by author honzap opened on Sep 5, 2025

• Crashes with nested COUNT(SELECT(…)) query

  📚 postgresqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#4084 · Filter by author chimbori opened on Aug 30, 2025

• Sqlite does not support SELECT...WHERE with no FROM

  📚 sqlitebug💻 darwin🔧 golang
  sqlc-dev/sqlc#4079 · Filter by author gamebox opened on Aug 27, 2025
  1

• COUNT(<column>) in a HAVING clause makes dynamic argument assume the type of the counted column, not an integer

  📚 mysqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#4011 · Filter by author tru-axo opened on Jul 3, 2025

• Argument inside CTE not detected

  📚 mysqlbug💻 darwin
  sqlc-dev/sqlc#3990 · Filter by author cjtheham opened on Jun 13, 2025

• Postgresql, sum of float turns into int

  📚 postgresqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#3966 · Filter by author Jcambass opened on May 15, 2025

• DROP TRIGGER and DROP EVENT TRIGGER Postgres queries are quietly ignored

  📚 postgresqlbug💻 darwin🔧 golang
  sqlc-dev/sqlc#3935 · Filter by author dubek opened on Apr 18, 2025