Skip to content

Latest commit

 

History

History
999 lines (618 loc) · 20.8 KB

changelog.md

File metadata and controls

999 lines (618 loc) · 20.8 KB
Raw

Changelog

All notable changes to this project will be documented in this file.

1.13.0

Released 2022-03-31

Bug Fixes

  • (compiler) Fix left join nullability with table aliases (#1491)
  • (postgresql) Remove extra newline with db argument (#1417)
  • (sqlite) Fix DROP TABLE (#1443)

Features

  • (cli) Upload projects (#1436)
  • (codegen) Add sqlc version to generated Go code (#1513)
  • (codegen) Add sqlc version to generated Kotlin code (#1512)
  • (codegen) Insert comments in interfaces (#1458)
  • (codegen) Pass sqlc version in codegen request (#1514)
  • (pgx) Add support for batch operations (#1437)
  • (postgresql) Add materialized view support (#1509)
  • (python) Graduate Python support to beta (#1520)
  • (sdk) Add the plugin SDK package (#1463)
  • (sqlite) Add support for delete statements (#1447)
  • (sqlite) Start expanding support (#1410)

Miscellaneous Tasks

  • Fix extra newline in comments for copyfrom (#1438)
  • Generate marshal/unmarshal with vtprotobuf (#1467)

Refactor

  • (codegen) Port Kotlin codegen package to use plugin types (#1416)
  • (codegen) Port Go to plugin types (#1460)
  • (cmd) Simplify codegen selection logic (#1466)

Config

  • Add basic fuzzing for config / overrides (#1500)

1.12.0

Released 2022-02-05

Bug

  • ALTER TABLE SET SCHEMA (#1409)

Bug Fixes

  • Update ANTLR v4 go.mod entry (#1336)
  • Check delete statements for CTEs (#1329)
  • Fix validation of GROUP BY on field aliases (#1348)
  • Fix imports when non-copyfrom queries needed imports that copyfrom queries didn't (#1386)
  • Remove extra comment newline (#1395)
  • Enable strict function checking (#1405)

Documentation

  • Bump version to 1.11.0 (#1308)

Features

  • Inheritance (#1339)
  • Generate query code using ASTs instead of templates (#1338)
  • Add support for CREATE TABLE a ( LIKE b ) (#1355)
  • Add support for sql.NullInt16 (#1376)

Miscellaneous Tasks

  • Add tests for :exec{result,rows} (#1344)
  • Delete template-based codegen (#1345)

Build

  • Bump github.com/jackc/pgx/v4 from 4.14.0 to 4.14.1 (#1316)
  • Bump golang from 1.17.3 to 1.17.4 (#1331)
  • Bump golang from 1.17.4 to 1.17.5 (#1337)
  • Bump github.com/spf13/cobra from 1.2.1 to 1.3.0 (#1343)
  • Remove devel Docker build
  • Bump golang from 1.17.5 to 1.17.6 (#1369)
  • Bump github.com/google/go-cmp from 0.5.6 to 0.5.7 (#1382)
  • Format all Go code (#1387)

1.11.0

Released 2021-11-24

Bug Fixes

  • Update incorrect signatures (#1180)
  • Correct aggregate func sig (#1182)
  • Jsonb_build_object (#1211)
  • Case-insensitive identifiers (#1216)
  • Incorrect handling of meta (#1228)
  • Detect invalid INSERT expression (#1231)
  • Respect alias name for coalesce (#1232)
  • Mark nullable when casting NULL (#1233)
  • Support nullable fields in joins for MySQL engine (#1249)
  • Fix between expression handling of table references (#1268)
  • Support nullable fields in joins on same table (#1270)
  • Fix missing binds in ORDER BY (#1273)
  • Set RV for TargetList items on updates (#1252)
  • Fix MySQL parser for query without trailing semicolon (#1282)
  • Validate table alias references (#1283)
  • Add support for MySQL ON DUPLICATE KEY UPDATE (#1286)
  • Support references to columns in joined tables in UPDATE statements (#1289)
  • Add validation for GROUP BY clause column references (#1285)
  • Prevent variable redeclaration in single param conflict (#1298)
  • Use common params struct field for same named params (#1296)

Documentation

  • Replace deprecated go get with go install (#1181)
  • Fix package name referenced in tutorial (#1202)
  • Add environment variables (#1264)
  • Add go.17+ install instructions (#1280)
  • Warn about golang-migrate file order (#1302)

Features

  • Instrument compiler via runtime/trace (#1258)
  • Add MySQL support for BETWEEN arguments (#1265)

Refactor

  • Move from io/ioutil to io and os package (#1164)

Styling

  • Apply gofmt to sample code (#1261)

Build

  • Bump golang from 1.17.0 to 1.17.1 (#1173)
  • Bump eskatos/gradle-command-action from 1 to 2 (#1220)
  • Bump golang from 1.17.1 to 1.17.2 (#1227)
  • Bump github.com/pganalyze/pg_query_go/v2 (#1234)
  • Bump actions/checkout from 2.3.4 to 2.3.5 (#1238)
  • Bump babel from 2.9.0 to 2.9.1 in /docs (#1245)
  • Bump golang from 1.17.2 to 1.17.3 (#1272)
  • Bump actions/checkout from 2.3.5 to 2.4.0 (#1267)
  • Bump github.com/lib/pq from 1.10.3 to 1.10.4 (#1278)
  • Bump github.com/jackc/pgx/v4 from 4.13.0 to 4.14.0 (#1303)

Cmd/sqlc

  • Bump version to v1.11.0

1.10.0

Released 2021-09-07

Documentation

  • Fix invalid language support table (#1161)
  • Add a getting started guide for MySQL (#1163)

Build

  • Bump golang from 1.16.7 to 1.17.0 (#1129)
  • Bump github.com/lib/pq from 1.10.2 to 1.10.3 (#1160)

Ci

  • Upgrade Go to 1.17 (#1130)

Cmd/sqlc

  • Bump version to v1.10.0 (#1165)

Codegen/golang

  • Consolidate import logic (#1139)
  • Add pgx support for range types (#1146)
  • Use pgtype for hstore when using pgx (#1156)

Codgen/golang

  • Use p[gq]type for network address types (#1142)

Endtoend

  • Run go test in CI (#1134)

Engine/mysql

  • Add support for LIKE (#1162)

Golang

  • Output NullUUID when necessary (#1137)

1.9.0

Released 2021-08-13

Documentation

  • Update documentation (a bit) for v1.9.0 (#1117)

Build

  • Bump golang from 1.16.6 to 1.16.7 (#1107)

Cmd/sqlc

  • Bump version to v1.9.0 (#1121)

Compiler

  • Add tests for COALESCE behavior (#1112)
  • Handle subqueries in SELECT statements (#1113)

1.8.0

Released 2021-05-03

Documentation

  • Add language support Matrix (#920)

Features

  • Add case style config option (#905)

Python

  • Eliminate runtime package and use sqlalchemy (#939)

Build

  • Bump github.com/google/go-cmp from 0.5.4 to 0.5.5 (#926)
  • Bump github.com/lib/pq from 1.9.0 to 1.10.0 (#931)
  • Bump golang from 1.16.0 to 1.16.1 (#935)
  • Bump golang from 1.16.1 to 1.16.2 (#942)
  • Bump github.com/jackc/pgx/v4 from 4.10.1 to 4.11.0 (#956)
  • Bump github.com/go-sql-driver/mysql from 1.5.0 to 1.6.0 (#961)
  • Bump github.com/pganalyze/pg_query_go/v2 (#965)
  • Bump urllib3 from 1.26.3 to 1.26.4 in /docs (#968)
  • Bump golang from 1.16.2 to 1.16.3 (#963)
  • Bump github.com/lib/pq from 1.10.0 to 1.10.1 (#980)

Cmd

  • Add the --experimental flag (#929)
  • Fix sqlc init (#959)

Cmd/sqlc

  • Bump version to v1.7.1-devel (#913)
  • Bump version to v1.8.0

Codegen

  • Generate valid enum names for symbols (#972)

Postgresql

  • Support generated columns
  • Add test for PRIMARY KEY INCLUDE
  • Add tests for CREATE TABLE PARTITION OF
  • CREATE TRIGGER EXECUTE FUNCTION
  • Add support for renaming types (#971)

Sql/ast

  • Resolve return values from functions (#964)

Workflows

  • Only run tests once (#924)

1.7.0

Released 2021-02-28

Bug Fixes

  • Struct tag formatting (#833)

Documentation

  • Include all the existing Markdown files (#877)
  • Split docs into four sections (#882)
  • Reorganize and consolidate documentation
  • Add link to Windows download (#888)
  • Shorten the README (#889)

Features

  • Adding support for pgx/v4
  • Adding support for pgx/v4

README

  • Add Go Report Card badge (#891)

Build

  • Bump github.com/google/go-cmp from 0.5.3 to 0.5.4 (#813)
  • Bump github.com/lib/pq from 1.8.0 to 1.9.0 (#820)
  • Bump golang from 1.15.5 to 1.15.6 (#822)
  • Bump github.com/jackc/pgx/v4 from 4.9.2 to 4.10.0 (#823)
  • Bump github.com/jackc/pgx/v4 from 4.10.0 to 4.10.1 (#839)
  • Bump golang from 1.15.6 to 1.15.7 (#855)
  • Bump golang from 1.15.7 to 1.15.8 (#881)
  • Bump github.com/spf13/cobra from 1.1.1 to 1.1.2 (#892)
  • Bump golang from 1.15.8 to 1.16.0 (#897)
  • Bump github.com/lfittl/pg_query_go from 1.0.1 to 1.0.2 (#901)
  • Bump github.com/spf13/cobra from 1.1.2 to 1.1.3 (#893)

Catalog

  • Improve alter column type (#818)

Ci

  • Uprade to Go 1.15 (#887)

Cmd

  • Allow config file location to be specified (#863)

Cmd/sqlc

  • Bump to version v1.6.1-devel (#807)
  • Bump version to v1.7.0 (#912)

Codegen/golang

  • Make sure to import net package (#858)

Compiler

  • Support UNION query

Dolphin

  • Generate bools for tinyint(1)
  • Support joins in update statements (#883)
  • Add support for union query

Endtoend

  • Add tests for INTERSECT and EXCEPT

Go.mod

  • Update to go 1.15 and run 'go mod tidy' (#808)

Mysql

  • Compile tinyint(1) to bool (#873)

Sql/ast

  • Add enum values for SetOperation

1.6.0

Released 2020-11-23

Dolphin

  • Implement Rename (#651)
  • Skip processing view drops (#653)

README

  • Update language / database support (#698)

Astutils

  • Fix Params rewrite call (#674)

Build

  • Bump golang from 1.14 to 1.15.3 (#765)
  • Bump docker/build-push-action from v1 to v2.1.0 (#764)
  • Bump github.com/google/go-cmp from 0.4.0 to 0.5.2 (#766)
  • Bump github.com/spf13/cobra from 1.0.0 to 1.1.1 (#767)
  • Bump github.com/jackc/pgx/v4 from 4.6.0 to 4.9.2 (#768)
  • Bump github.com/lfittl/pg_query_go from 1.0.0 to 1.0.1 (#773)
  • Bump github.com/google/go-cmp from 0.5.2 to 0.5.3 (#783)
  • Bump golang from 1.15.3 to 1.15.5 (#782)
  • Bump github.com/lib/pq from 1.4.0 to 1.8.0 (#769)

Catalog

  • Improve variadic argument support (#804)

Cmd/sqlc

  • Bump to version v1.6.0 (#806)

Codegen

  • Fix errant database/sql imports (#789)

Compiler

  • Use engine-specific reserved keywords (#677)

Dolphi

  • Add list of builtin functions (#795)

Dolphin

  • Update to the latest MySQL parser (#665)
  • Add ENUM() support (#676)
  • Add test for table aliasing (#684)
  • Add MySQL ddl_create_table test (#685)
  • Implete TRUNCATE table (#697)
  • Represent tinyint as int32 (#797)
  • Add support for coalesce (#802)
  • Add function signatures (#796)

Endtoend

  • Add MySQL json test (#692)
  • Add MySQL update set multiple test (#696)

Examples

  • Use generated enum constants in db_test (#678)
  • Port ondeck to MySQL (#680)
  • Add MySQL authors example (#682)

Internal/cmd

  • Print correct config file on parse failure (#749)

Kotlin

  • Remove runtime dependency (#774)

Metadata

  • Support multiple comment prefixes (#683)

Postgresql

  • Support string concat operator (#701)

Sql/catalog

  • Add support for variadic functions (#798)

1.5.0

Released 2020-08-05

Documentation

  • Build sqlc using Go 1.14 (#549)

Cmd

  • Add debugging support (#573)

Cmd/sqlc

  • Bump version to v1.4.1-devel (#548)
  • Bump version to v1.5.0

Compiler

  • Support calling functions with defaults (#635)
  • Skip func args without a paramRef (#636)
  • Return a single column from coalesce (#639)

Config

  • Add emit_empty_slices to version one (#552)

Contrib

  • Add generated code for contrib

Dinosql

  • Remove deprecated package (#554)

Dolphin

  • Add support for column aliasing (#566)
  • Implement star expansion for subqueries (#619)
  • Implement exapansion with reserved words (#620)
  • Implement parameter refs (#621)
  • Implement limit and offest (#622)
  • Implement inserts (#623)
  • Implement delete (#624)
  • Implement simple update statements (#625)
  • Implement INSERT ... SELECT (#626)
  • Use test driver instead of TiDB driver (#629)
  • Implement named parameters via sqlc.arg() (#632)

Endtoend

  • Add MySQL test for SELECT * JOIN (#565)
  • Add MySQL test for inflection (#567)

Engine

  • Create engine package (#556)

Equinox

  • Use the new equinox-io/setup action (#586)

Examples

  • Run tests for MySQL booktest (#627)

Golang

  • Add support for the money type (#561)
  • Generate correct types for int2 and int8 (#579)

Internal

  • Rm catalog, pg, postgres packages (#555)

Mod

  • Downgrade TiDB package to fix build (#603)

Mysql

  • Upgrade to the latest vitess commit (#562)
  • Support to infer type of a duplicated arg (#615)
  • Allow some builtin functions to be nullable (#616)

Postgresql

  • Generate all functions in pg_catalog (#550)
  • Remove pg_catalog schema from tests (#638)
  • Move contrib code to a package

Sql/catalog

  • Fix comparison of pg_catalog types (#637)

Tools

  • Generate functions for all of contrib

Workflow

  • Migrate to equinox-io/setup-release-tool (#614)

1.4.0

Released 2020-06-17

Dockerfile

  • Add version build argument (#487)

MySQL

  • Prevent Panic when WHERE clause contains parenthesis. (#531)

README

  • Document emit_exact_table_names (#486)

All

  • Remove the exp build tag (#507)

Catalog

  • Support functions with table parameters (#541)

Cmd

  • Bump to version 1.3.1-devel (#485)

Cmd/sqlc

  • Bump version to v1.4.0 (#547)

Codegen

  • Add the new codegen packages (#513)
  • Add the :execresult query annotation (#542)

Compiler

  • Validate function calls (#505)
  • Port bottom of parseQuery (#510)
  • Don't mutate table name (#517)
  • Enable experimental parser by default (#518)
  • Apply rename rules to enum constants (#523)
  • Temp fix for typecast function parameters (#530)

Endtoend

  • Standardize JSON formatting (#490)
  • Add per-test configuration files (#521)
  • Read expected stderr failures from disk (#527)

Internal/dinosql

  • Check parameter style before ref (#488)
  • Remove unneeded column suffix (#492)
  • Support named function arguments (#494)

Internal/postgresql

  • Fix NamedArgExpr rewrite (#491)

Multierr

  • Move dinosql.ParserErr to a new package (#496)

Named

  • Port parameter style validation to SQL (#504)

Parser

  • Support columns from subselect statements (#489)

Rewrite

  • Move parameter rewrite to package (#499)

Sqlite

  • Use convert functions instead of the listener (#519)

Sqlpath

  • Move ReadSQLFiles into a separate package (#495)

Validation

  • Move query validation to separate package (#498)

1.3.0

Released 2020-05-12

Makefile

  • Update target (#449)

README

  • Add Myles as a sponsor (#469)

Testing

  • Make sure all Go examples build (#480)

Cmd

  • Bump version to v1.3.0 (#484)

Cmd/sqlc

  • Bump version to v1.2.1-devel (#442)

Dinosql

  • Inline addFile (#446)
  • Add PostgreSQL support for TRUNCATE (#448)

Gen

  • Emit json.RawMessage for JSON columns (#461)

Go.mod

  • Use latest lib/pq (#471)

Parser

  • Use same function to load SQL files (#483)

Postgresql

  • Fix panic walking CreateTableAsStmt (#475)

1.2.0

Released 2020-04-07

Documentation

  • Publish to Docker Hub (#422)

README

  • Docker installation docs (#424)

Cmd/sqlc

  • Bump version to v1.1.1-devel (#407)
  • Bump version to v1.2.0 (#441)

Gen

  • Add special case for "campus" (#435)
  • Properly quote reserved keywords on expansion (#436)

Migrations

  • Move migration parsing to new package (#427)

Parser

  • Generate correct types for SELECT EXISTS (#411)

1.1.0

Released 2020-03-17

README

  • Add installation instructions (#350)
  • Add section on running tests (#357)
  • Fix typo (#371)

Ast

  • Add AST for ALTER TABLE ADD / DROP COLUMN (#376)
  • Add support for CREATE TYPE as ENUM (#388)
  • Add support for CREATE / DROP SCHEMA (#389)

Astutils

  • Apply changes to the ValuesList slice (#372)

Cmd

  • Return v1.0.0 (#348)
  • Return next bug fix version (#349)

Cmd/sqlc

  • Bump version to v1.1.0 (#406)

Compiler

  • Wire up the experimental parsers

Config

  • Remove "emit_single_file" option (#367)

Dolphin

  • Add experimental parser for MySQL

Gen

  • Add option to emit single file for Go (#366)
  • Add support for the ltree extension (#385)

Go.mod

  • Add packages for MySQL and SQLite parsers

Internal/dinosql

  • Support Postgres macaddr type in Go (#358)

Internal/endtoend

  • Remove %w (#354)

Kotlin

  • Add Query class to support timeout and cancellation (#368)

Postgresql

  • Add experimental parser for MySQL

Sql

  • Add generic SQL AST

Sql/ast

  • Port support for COMMENT ON (#391)
  • Implement DROP TYPE (#397)
  • Implement ALTER TABLE RENAME (#398)
  • Implement ALTER TABLE RENAME column (#399)
  • Implement ALTER TABLE SET SCHEMA (#400)

Sql/catalog

  • Port tests over from catalog pkg (#402)

Sql/errors

  • Add a new errors package (#390)

Sqlite

  • Add experimental parser for SQLite

1.0.0

Released 2020-02-18

Documentation

  • Add documentation for query commands (#270)
  • Add named parameter documentation (#332)

README

  • Add sponsors section (#333)

Cmd

  • Remove parse subcommand (#322)

Config

  • Parse V2 config format
  • Add support for YAML (#336)

Examples

  • Add the jets and booktest examples (#237)
  • Move sqlc.json into examples folder (#238)
  • Add the authors example (#241)
  • Add build tag to authors tests (#319)

Internal

  • Allow CTE to be used with UPDATE (#268)
  • Remove the PackageMap from settings (#295)

Internal/config

  • Create new config package (#313)

Internal/dinosql

  • Emit Querier interface (#240)
  • Strip leading "go-" or trailing "-go" from import (#262)
  • Overrides can now be basic types (#271)
  • Import needed types for Querier (#285)
  • Handle schema-scoped enums (#310)
  • Ignore golang-migrate rollbacks (#320)

Internal/endtoend

  • Move more tests to the record/replay framework
  • Add update test for named params (#329)

Internal/mysql

  • Fix flaky test (#242)
  • Port tests to endtoend package (#315)

Internal/parser

  • Resolve nested CTEs (#324)
  • Error if last query is missing (#325)
  • Support joins with aliases (#326)
  • Remove print statement (#327)

Internal/sqlc

  • Add support for composite types (#311)

Kotlin

  • Support primitives
  • Arrays, enums, and dates
  • Generate examples
  • README for examples
  • Factor out db setup extension
  • Fix enums, use List instead of Array
  • Port Go tests for examples
  • Rewrite numbered params to positional params
  • Always use use, fix indents
  • Unbox query params

Parser

  • Attach range vars to insert params
  • Attach range vars to insert params (#342)
  • Remove dead code (#343)

0.1.0

Released 2020-01-07

Documentation

  • Replace remaining references to DinoSQL with sqlc (#149)

README

  • Fix download links (#66)
  • Add LIMIT 1 to query that should return one (#99)

Catalog

  • Support "ALTER TABLE ... DROP CONSTRAINT ..." (#34)
  • Differentiate functions with different argument types (#51)

Ci

  • Enable tests on pull requests

Cmd

  • Include filenames in error messages (#69)
  • Do not output any changes on error (#72)

Dinosql/internal

  • Add lower and upper functions (#215)
  • Ignore alter sequence commands (#219)

Gen

  • Add DO NOT EDIT comments to generated code (#50)
  • Include all schemas when generating models (#90)
  • Prefix structs with schema name (#91)
  • Generate single import for uuid package (#98)
  • Use same import logic for all Go files
  • Pick correct struct to return for queries (#107)
  • Create consistent JSON tags (#110)
  • Add Close method to Queries struct (#127)
  • Ignore empty override settings (#128)
  • Turn SQL comments into Go comments (#136)

Internal/catalog

  • Parse unnamed function arguments (#166)

Internal/dinosql

  • Prepare() with no GoQueries still valid (#95)
  • Fix multiline comment rendering (#142)
  • Dereference alias nodes on walk (#158)
  • Ignore sql-migrate rollbacks (#160)
  • Sort imported packages (#165)
  • Add support for timestamptz (#169)
  • Error on missing queries (#180)
  • Use more database/sql null types (#182)
  • Support the pg_temp schema (#183)
  • Override columns with array type (#184)
  • Implement robust expansion
  • Implement robust expansion (#186)
  • Add COMMENT ON support (#191)
  • Add DATE support
  • Add DATE support (#196)
  • Filter out invalid characters (#198)
  • Quote reserved keywords (#205)
  • Return parser errors first (#207)
  • Implement advisory locks (#212)
  • Error on duplicate query names (#221)
  • Fix incorrect enum names (#223)
  • Add support for numeric types
  • Add support for numeric types (#228)

Internal/dinosql/testdata/ondeck

  • Add Makefile (#156)

Ondeck

  • Move all tests to GitHub CI (#58)

ParseQuery

  • Return either a query or an error (#178)

Parser

  • Use schema when resolving catalog refs (#82)
  • Support function calls in expressions (#104)
  • Correctly handle single files (#119)
  • Return error if missing RETURNING (#131)
  • Add support for mathmatical operators (#132)
  • Add support for simple case expressions (#134)
  • Error on mismatched INSERT input (#135)
  • Set IsArray on joined columns (#139)

Pg

  • Store functions in the catalog (#41)
  • Add location to errors (#73)