mysql from 1.7.1 to 1.8.0 #279

New issue

Closed

opened 2026-03-03 11:57:03 +03:00 by kerem · 0 comments

kerem commented

2026-03-03 11:57:03 +03:00

Owner

📋 Pull Request Information

Original PR: https://github.com/Finb/bark-server/pull/266
Author: @dependabot[bot]
Created: 3/11/2024
Status: ✅ Merged
Merged: 3/11/2024
Merged by: @mritd

Base: master ← Head: dependabot/go_modules/github.com/go-sql-driver/mysql-1.8.0

📝 Commits (1)

f31c44d chore(deps): bump github.com/go-sql-driver/mysql from 1.7.1 to 1.8.0

📊 Changes

2 files changed (+6 additions, -3 deletions)

View changed files

📝 go.mod (+2 -1)
📝 go.sum (+4 -2)

📄 Description

Bumps github.com/go-sql-driver/mysql from 1.7.1 to 1.8.0.

Release notes

Sourced from github.com/go-sql-driver/mysql's releases.

v1.8.0

What's Changed

Major changes

Use SET NAMES charset COLLATE collation. by @methane in go-sql-driver/mysql#1437

Older go-mysql-driver used collation_id in the handshake packet. But it caused collation mismatch in some situation.

If you don't specify charset nor collation, go-mysql-driver sends SET NAMES utf8mb4 for new connection. This uses server's default collation for utf8mb4.

If you specify charset, go-mysql-driver sends SET NAMES <charset>. This uses the server's default collation for <charset>.

If you specify collation and/or charset, go-mysql-driver sends SET NAMES charset COLLATE collation.

PathEscape dbname in DSN. by @methane in go-sql-driver/mysql#1432

This is backward incompatible in rare case. Check your DSN.

Drop Go 1.13-17 support by @methane in go-sql-driver/mysql#1420

Use Go 1.18+

Parse numbers on text protocol too by @methane in go-sql-driver/mysql#1452

When text protocol is used, go-mysql-driver passed bare []byte to database/sql for avoid unnecessary allocation and conversion.

If user specified *any to Scan(), database/sql passed the []byte into the target variabe.

This confused users because most user doesn't know when text/binary protocol used.

go-mysql-driver 1.8 converts integer/float values into int64/double even in text protocol. This doesn't increase allocation compared to []byte and conversion cost is negilible.

New options start using the Functional Option Pattern to avoid increasing technical debt in the Config object. Future version may introduce Functional Option for existing options, but not for now.

Make TimeTruncate functional option by @methane in go-sql-driver/mysql#1552

Add BeforeConnect callback to configuration object by @ItalyPaleAle in go-sql-driver/mysql#1469

Other changes

Adding DeregisterDialContext to prevent memory leaks with dialers we don't need anymore by @jypelle in go-sql-driver/mysql#1422

Make logger configurable per connection by @frozenbonito in go-sql-driver/mysql#1408

Fix ColumnType.DatabaseTypeName for mediumint unsigned by @evanelias in go-sql-driver/mysql#1428

Add connection attributes by @Daemonxiao in go-sql-driver/mysql#1389

Stop ColumnTypeScanType() from returning sql.RawBytes by @methane in go-sql-driver/mysql#1424

Exec() now provides access to status of multiple statements. by @mherr-google in go-sql-driver/mysql#1309

Allow to change (or disable) the default driver name for registration by @dolmen in go-sql-driver/mysql#1499

Add default connection attribute '_server_host' by @oblitorum in go-sql-driver/mysql#1506

QueryUnescape DSN ConnectionAttribute value by @zhangyangyu in go-sql-driver/mysql#1470

Add client_ed25519 authentication by @Gusted in go-sql-driver/mysql#1518

Reduced allocation on connection.go by @EPuncker in go-sql-driver/mysql#1421

Avoid panic in TestRowsColumnTypes by @wayyoungboy in go-sql-driver/mysql#1426

Add benchmark to receive massive rows. by @methane in go-sql-driver/mysql#1415

README: Update multistatement by @methane in go-sql-driver/mysql#1431

... (truncated)

Commits

33b7747 Add BeforeConnect callback to configuration object (#1469)
6964272 Make TimeTruncate functional option (#1552)
097fe6e Update workflows (#1547)
f019727 add TiDB support in README.md (#1333)
743e263 Introduce timeTruncate parameter for time.Time arguments (#1541)
c48c0e7 Fix unsigned int overflow (#1530)
0004702 Parallelize test (#1525)
d4517c5 Support ENUM and SET type in DatabaseTypeName() (#1520)
2cdf624 Fix sql.RawBytes corruption issue (#1523)
fc589cb Add client_ed25519 authentication (#1518)
Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

@dependabot rebase will rebase this PR
@dependabot recreate will recreate this PR, overwriting any edits that have been made to it
@dependabot merge will merge this PR after your CI passes on it
@dependabot squash and merge will squash and merge this PR after your CI passes on it
@dependabot cancel merge will cancel a previously requested merge and block automerging
@dependabot reopen will reopen this PR if it is closed
@dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
@dependabot show <dependency name> ignore conditions will show all of the ignore conditions of the specified dependency
@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/Finb/bark-server/pull/266 **Author:** [@dependabot[bot]](https://github.com/apps/dependabot) **Created:** 3/11/2024 **Status:** ✅ Merged **Merged:** 3/11/2024 **Merged by:** [@mritd](https://github.com/mritd) **Base:** `master` ← **Head:** `dependabot/go_modules/github.com/go-sql-driver/mysql-1.8.0` --- ### 📝 Commits (1) - [`f31c44d`](https://github.com/Finb/bark-server/commit/f31c44d80f269f4d438986b33799a7d9f9404843) chore(deps): bump github.com/go-sql-driver/mysql from 1.7.1 to 1.8.0 ### 📊 Changes **2 files changed** (+6 additions, -3 deletions) <details> <summary>View changed files</summary> 📝 `go.mod` (+2 -1) 📝 `go.sum` (+4 -2) </details> ### 📄 Description Bumps [github.com/go-sql-driver/mysql](https://github.com/go-sql-driver/mysql) from 1.7.1 to 1.8.0. <details> <summary>Release notes</summary> Sourced from <a href="https://github.com/go-sql-driver/mysql/releases">github.com/go-sql-driver/mysql's releases</a>. <blockquote> <h2>v1.8.0</h2> <h2>What's Changed</h2> <h2>Major changes</h2> <ul> <li> Use <code>SET NAMES charset COLLATE collation</code>. by <a href="https://github.com/methane"><code>@methane</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1437">go-sql-driver/mysql#1437</a> <ul> <li>Older go-mysql-driver used <code>collation_id</code> in the handshake packet. But it caused collation mismatch in some situation.</li> <li>If you don't specify charset nor collation, go-mysql-driver sends <code>SET NAMES utf8mb4</code> for new connection. This uses server's default collation for utf8mb4.</li> <li>If you specify charset, go-mysql-driver sends <code>SET NAMES <charset></code>. This uses the server's default collation for <code><charset></code>.</li> <li>If you specify collation and/or charset, go-mysql-driver sends <code>SET NAMES charset COLLATE collation</code>.</li> </ul> </li> <li> PathEscape dbname in DSN. by <a href="https://github.com/methane"><code>@methane</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1432">go-sql-driver/mysql#1432</a> <ul> <li>This is backward incompatible in rare case. Check your DSN.</li> </ul> </li> <li> Drop Go 1.13-17 support by <a href="https://github.com/methane"><code>@methane</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1420">go-sql-driver/mysql#1420</a> <ul> <li>Use Go 1.18+</li> </ul> </li> <li> Parse numbers on text protocol too by <a href="https://github.com/methane"><code>@methane</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1452">go-sql-driver/mysql#1452</a> <ul> <li>When text protocol is used, go-mysql-driver passed bare <code>[]byte</code> to database/sql for avoid unnecessary allocation and conversion.</li> <li>If user specified <code>*any</code> to <code>Scan()</code>, database/sql passed the <code>[]byte</code> into the target variabe.</li> <li>This confused users because most user doesn't know when text/binary protocol used.</li> <li>go-mysql-driver 1.8 converts integer/float values into int64/double even in text protocol. This doesn't increase allocation compared to <code>[]byte</code> and conversion cost is negilible.</li> </ul> </li> <li> New options start using the Functional Option Pattern to avoid increasing technical debt in the Config object. Future version may introduce Functional Option for existing options, but not for now. <ul> <li>Make TimeTruncate functional option by <a href="https://github.com/methane"><code>@methane</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1552">go-sql-driver/mysql#1552</a></li> <li>Add BeforeConnect callback to configuration object by <a href="https://github.com/ItalyPaleAle"><code>@ItalyPaleAle</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1469">go-sql-driver/mysql#1469</a></li> </ul> </li> </ul> <h3>Other changes</h3> <ul> <li> Adding DeregisterDialContext to prevent memory leaks with dialers we don't need anymore by <a href="https://github.com/jypelle"><code>@jypelle</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1422">go-sql-driver/mysql#1422</a> </li> <li> Make logger configurable per connection by <a href="https://github.com/frozenbonito"><code>@frozenbonito</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1408">go-sql-driver/mysql#1408</a> </li> <li> Fix ColumnType.DatabaseTypeName for mediumint unsigned by <a href="https://github.com/evanelias"><code>@evanelias</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1428">go-sql-driver/mysql#1428</a> </li> <li> Add connection attributes by <a href="https://github.com/Daemonxiao"><code>@Daemonxiao</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1389">go-sql-driver/mysql#1389</a> </li> <li> Stop <code>ColumnTypeScanType()</code> from returning <code>sql.RawBytes</code> by <a href="https://github.com/methane"><code>@methane</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1424">go-sql-driver/mysql#1424</a> </li> <li> Exec() now provides access to status of multiple statements. by <a href="https://github.com/mherr-google"><code>@mherr-google</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1309">go-sql-driver/mysql#1309</a> </li> <li> Allow to change (or disable) the default driver name for registration by <a href="https://github.com/dolmen"><code>@dolmen</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1499">go-sql-driver/mysql#1499</a> </li> <li> Add default connection attribute '_server_host' by <a href="https://github.com/oblitorum"><code>@oblitorum</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1506">go-sql-driver/mysql#1506</a> </li> <li> QueryUnescape DSN ConnectionAttribute value by <a href="https://github.com/zhangyangyu"><code>@zhangyangyu</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1470">go-sql-driver/mysql#1470</a> </li> <li> Add client_ed25519 authentication by <a href="https://github.com/Gusted"><code>@Gusted</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1518">go-sql-driver/mysql#1518</a> </li> <li> Reduced allocation on connection.go by <a href="https://github.com/EPuncker"><code>@EPuncker</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1421">go-sql-driver/mysql#1421</a> </li> <li> Avoid panic in TestRowsColumnTypes by <a href="https://github.com/wayyoungboy"><code>@wayyoungboy</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1426">go-sql-driver/mysql#1426</a> </li> <li> Add benchmark to receive massive rows. by <a href="https://github.com/methane"><code>@methane</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1415">go-sql-driver/mysql#1415</a> </li> <li> README: Update multistatement by <a href="https://github.com/methane"><code>@methane</code></a> in <a href="https://redirect.github.com/go-sql-driver/mysql/pull/1431">go-sql-driver/mysql#1431</a> </li> </ul>  </blockquote> ... (truncated) </details> <details> <summary>Commits</summary> <ul> <li><a href="https://github.com/go-sql-driver/mysql/commit/33b7747a9144946e50399904d3f27ecc0f96c2b6"><code>33b7747</code></a> Add BeforeConnect callback to configuration object (<a href="https://redirect.github.com/go-sql-driver/mysql/issues/1469">#1469</a>)</li> <li><a href="https://github.com/go-sql-driver/mysql/commit/6964272ffd13a41ad66383cd2ea738fded75ad06"><code>6964272</code></a> Make TimeTruncate functional option (<a href="https://redirect.github.com/go-sql-driver/mysql/issues/1552">#1552</a>)</li> <li><a href="https://github.com/go-sql-driver/mysql/commit/097fe6e3ad83bbd7c84debe810aec4c4a533bcaa"><code>097fe6e</code></a> Update workflows (<a href="https://redirect.github.com/go-sql-driver/mysql/issues/1547">#1547</a>)</li> <li><a href="https://github.com/go-sql-driver/mysql/commit/f019727e4706bf9c4f60579382f6e72b94bd0305"><code>f019727</code></a> add TiDB support in README.md (<a href="https://redirect.github.com/go-sql-driver/mysql/issues/1333">#1333</a>)</li> <li><a href="https://github.com/go-sql-driver/mysql/commit/743e263bab87912dfb61789f36c21d9685887c76"><code>743e263</code></a> Introduce <code>timeTruncate</code> parameter for <code>time.Time</code> arguments (<a href="https://redirect.github.com/go-sql-driver/mysql/issues/1541">#1541</a>)</li> <li><a href="https://github.com/go-sql-driver/mysql/commit/c48c0e7da17e8fc06133e431ce7c10e7a3e94f06"><code>c48c0e7</code></a> Fix unsigned int overflow (<a href="https://redirect.github.com/go-sql-driver/mysql/issues/1530">#1530</a>)</li> <li><a href="https://github.com/go-sql-driver/mysql/commit/0004702b931d3429afb3e16df444ed80be24d1f4"><code>0004702</code></a> Parallelize test (<a href="https://redirect.github.com/go-sql-driver/mysql/issues/1525">#1525</a>)</li> <li><a href="https://github.com/go-sql-driver/mysql/commit/d4517c5d905ccd3cc1e750f592edfa88d774d908"><code>d4517c5</code></a> Support ENUM and SET type in DatabaseTypeName() (<a href="https://redirect.github.com/go-sql-driver/mysql/issues/1520">#1520</a>)</li> <li><a href="https://github.com/go-sql-driver/mysql/commit/2cdf62442f2edb873d1270897d994fc83b78f118"><code>2cdf624</code></a> Fix sql.RawBytes corruption issue (<a href="https://redirect.github.com/go-sql-driver/mysql/issues/1523">#1523</a>)</li> <li><a href="https://github.com/go-sql-driver/mysql/commit/fc589cbaba22032382488393c72b9b3b5366917c"><code>fc589cb</code></a> Add client_ed25519 authentication (<a href="https://redirect.github.com/go-sql-driver/mysql/issues/1518">#1518</a>)</li> <li>Additional commits viewable in <a href="https://github.com/go-sql-driver/mysql/compare/v1.7.1...v1.8.0">compare view</a></li> </ul> </details> [![Dependabot compatibility score](https://dependabot-badges.githubapp.com/badges/compatibility_score?dependency-name=github.com/go-sql-driver/mysql&package-manager=go_modules&previous-version=1.7.1&new-version=1.8.0)](https://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores) Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting `@dependabot rebase`. [//]: # (dependabot-automerge-start) [//]: # (dependabot-automerge-end) --- <details> <summary>Dependabot commands and options</summary> You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot show <dependency name> ignore conditions` will show all of the ignore conditions of the specified dependency - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself) </details> --- 🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.