8000 feat(cmd/sqlc): Bump version to 1.20.0 by kyleconroy · Pull Request #2549 · sqlc-dev/sqlc · GitHub
[go: up one dir, main page]

Skip to content

feat(cmd/sqlc): Bump version to 1.20.0 #2549

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 7 commits into from
Jul 31, 2023
Merged
Changes from 1 commit
Commits
File filter

Filter by extension

Filter by extension

Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
style(changelog): minor copyedits
  • Loading branch information
andrewmbenton committed Jul 31, 2023
commit 9333a8ae4d5a23c73861af653a7307d0cc31526c
10 changes: 5 additions & 5 deletions docs/reference/changelog.md
Original file line number Diff line number Diff line change
Expand Up @@ -22,7 +22,7 @@ We designed the upgrade process to be as smooth as possible. If you run into any

#### Use `EXPLAIN ...` output in lint rules

`sqlc vet` can now run `EXPLAIN` on queries and include the results in your lint rules. For example, this rule checks that `SELECT` queries use an index.
`sqlc vet` can now run `EXPLAIN` on your queries and include the results for use in your lint rules. For example, this rule checks that `SELECT` queries use an index.

```yaml
version: 2
Expand Down Expand Up @@ -103,7 +103,7 @@ _Developed by [@Jille](https://github.com/Jille)_

MySQL now supports the `:copyfrom` query annotation. The generated code uses the [LOAD DATA](https://dev.mysql.com/doc/refman/8.0/en/load-data.html) command to insert data quickly and efficiently.

Some caution must be taken when using this feature. Errors and duplicate keys are treated as warnings and insertion will continue, even without an error for some cases. Use this in a transaction and use `SHOW WARNINGS` to check for any problems and roll back if you want to.
Use caution with this feature. Errors and duplicate keys are treated as warnings and insertion will continue, even without an error for some cases. Use this in a transaction and use `SHOW WARNINGS` to check for any problems and roll back if necessary.

Check the [error handling](https://dev.mysql.com/doc/refman/8.0/en/load-data.html#load-data-error-handling) documentation for more information.

Expand All @@ -120,13 +120,13 @@ func (q *Queries) InsertValues(ctx context.Context, arg []InsertValuesParams) (i
}
```

`LOAD DATA` support must be enabled in the MySQL client and server.
`LOAD DATA` support must be enabled in the MySQL server.

#### CAST support for MySQL

_Developed by [@ryanpbrewster](https://github.com/ryanpbrewster) and [@RadhiFadlillah](https://github.com/RadhiFadlillah)_

When `sqlc` now understands `CAST` calls in MySQL queries, offering greater flexibility for generating code for complex queries.
`sqlc` now understands `CAST` calls in MySQL queries, offering greater flexibility when generating code for complex queries.

```sql
CREATE TABLE foo (bar BOOLEAN NOT NULL);
Expand All @@ -153,7 +153,7 @@ func (q *Queries) SelectColumnCast(ctx context.Context) ([]int64, error) {

#### SQLite improvements

A slew of fixes landed for our SQLite implementation, bringing it closer to parity with MySQL and PostgreSQL. We wanted to thank [@orisano](https://github.com/orisano) for their continued dedication to making SQLite better.
A slew of fixes landed for our SQLite implementation, bringing it closer to parity with MySQL and PostgreSQL. We want to thank [@orisano](https://github.com/orisano) for their continued dedication to improving `sqlc`'s SQLite support.

### Changes

Expand Down
0