Merged PRs

dolt

• 8353: Support dolt diff --staged
  The common way to look at the staged diff in git is the --staged flag. --cached is still supported, but not recommended (and confusing). This change makes dolt more like git.
• 8352: Fix dolt_merge_base string validation for doltgres
  dolt_merge_base was failing in doltgres with a invalid type: unknown error
• 8350: [statspro] Restart drop db
  Quick fix for at least one of the problems in #8345.
  The specific example fails because the restart function refreshes the stats database instance, but does not reload the stats contained within. So the contents in memory did not track the contents on disk. This was only noticeable when restart and read were called within the same shell context.
• 8348: Testing for dolt add --patch
• 8343: support for schemas in various version control operations
  This change adds support for schemas in dolt_add, dolt_merge, and dolt_status. Many places that had a string for a table name now have a doltdb.TableName.
  Also fixes a newly discovered bug with creating a database:
  1. creating a DB with a collation left the working set dirty
  2. DBs created in a transaction couldn't be queried until starting a new tx
• 8341: Fix more stats collection races
  fixes: #8339
  The concurrency tests stopped working at some point when we were rearranging the default stats behavior. I caught a couple other issues after I got those tests running again.
• 8320: Bump actions/download-artifact from 3 to 4.1.7 in /.github/workflows
  Bumps actions/download-artifact from 3 to 4.1.7.
  Release notes

  Sourced from actions/download-artifact's releases.

  v4.1.7

  What's Changed

  • Update @​actions/artifact dependency by @​bethanyj28 in actions/download-artifact#325

  Full Changelog: actions/download-artifact@v4.1.6...v4.1.7

  v4.1.6

  What's Changed

  • updating @actions/artifact dependency to v2.1.6 by @​eggyhead in actions/download-artifact#324

  Full Changelog: actions/download-artifact@v4.1.5...v4.1.6

  v4.1.5

  What's Changed

  • Update readme with v3/v2/v1 deprecation notice by @​robherley in actions/download-artifact#322
  • Update dependencies @actions/core to v1.10.1 and @actions/artifact to v2.1.5

  Full Changelog: actions/download-artifact@v4.1.4...v4.1.5

  v4.1.4

  What's Changed

  • Update @​actions/artifact by @​bethanyj28 in actions/download-artifact#307

  Full Changelog: actions/download-artifact@v4...v4.1.4

  v4.1.3

  What's Changed

  • Update release-new-action-version.yml by @​konradpabjan in actions/download-artifact#292
  • Update toolkit dependency with updated unzip logic by @​bethanyj28 in actions/download-artifact#299
  • Update @​actions/artifact by @​bethanyj28 in actions/download-artifact#303

  New Contributors

  • @​bethanyj28 made their first contribution in actions/download-artifact#299

  Full Changelog: actions/download-artifact@v4...v4.1.3

  v4.1.2

  • Bump @​actions/artifacts to latest version to include updated GHES host check

  v4.1.1

  • Fix transient request timeouts actions/download-artifact#249
  • Bump @actions/artifacts to latest version

  v4.1.0

  What's Changed

  • Some cleanup by @​robherley in actions/download-artifact#247
  • Fix default for run-id by @​stchr in actions/download-artifact#252

  ... (truncated)

  Commits

  • 65a9edc Merge pull request #325 from bethanyj28/main
  • fdd1595 licensed
  • c13dba1 update @​actions/artifact dependency
  • 0daa75e Merge pull request #324 from actions/eggyhead/use-artifact-v2.1.6
  • 9c19ed7 Merge branch 'main' into eggyhead/use-artifact-v2.1.6
  • 3d3ea87 updating license
  • 89af5db updating artifact package v2.1.6
  • b4aefff Merge pull request #323 from actions/eggyhead/update-artifact-v215
  • 8caf195 package lock update
  • d7a2ec4 updating package version
  • Additional commits viewable in compare view
  
  [](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) ---
  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 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) You can disable automated security fix PRs for this repo from the [Security Alerts page](https://github.com/dolthub/dolt/network/alerts).
• 8310: Bump com.mysql:mysql-connector-j from 8.0.31 to 8.2.0 in /integration-tests/orm-tests/hibernate/DoltHibernateSmokeTest
  Bumps com.mysql:mysql-connector-j from 8.0.31 to 8.2.0.
  Changelog

  Sourced from com.mysql:mysql-connector-j's changelog.

  Changelog

  https://dev.mysql.com/doc/relnotes/connector-j/en/

  Version 9.0.0

  • WL#16391, Upgrade 3rd party libraries and tools.

  • Fix for Bug#114800 (Bug#36576596), Wrong code by an old patch.

  • Fix for Bug#114846 (Bug#36574322), Auto-closeable X dev session. Thanks to Daniel Kec for his contribution.

  • Fix for Bug#114989 (Bug#36612566), Setting null value in setClientInfo throws an NPE.

  • WL#16376, Set 'caching_sha2_password' as default fallback authentication plugin.

  • WL#16342, Update MySQL error codes mapping.

  • WL#16353, Refresh the list of acceptable TLS ciphers.

  • Fix for Bug#114687 (Bug#36529541), Tests fail after mysql_native_password has been made optional in server.

  • WL#16319, Remove deprecated insensitive terminology based methods.

  • WL#16324, Update static MySQL keywords list.

  • Fix for Bug#110512 (Bug#35223851), Contribution: Replace synchronized with ReentrantLock. Thanks to Bart De Neuter and Janick Reynders for their contributions.

  • Fix for Bug#108830 (Bug#34721173), LIMIT clause, setMaxRows and cursor combined returns wrong number or rows.

  Version 8.4.0

  • WL#15706, Add OpenTelemetry tracing.

  • WL#16174, Support for VECTOR data type.

  • Fix for Bug#36380711, Tests failing due to removal of deprecated features.

  • Fix for Bug#113600 (Bug#36171575), Contribution: Fix join condition for retrieval of imported primary keys. Thanks to Henning Pöttker for his contribution.

  • WL#16196, GPL License Exception Update.

  • Fix for Bug#111031 (Bug#35392222), Contribution: Update SyntaxRegressionTest.java. Thanks to Abby Palmero for her contribution.

  • Fix for Bug#113599 (Bug#36171571), Contribution: Replace StringBuffer with StringBuilder in ValueEncoders. Thanks to Henning Pöttker for his contribution.

  ... (truncated)

  Commits

  • 06a1f72 Fix for Bug#35811592, Missing implementation for Connection.releaseSavepoint().
  • 9df3820 Update for GPL license book.
  • ff822cf Fix for tests failing due to expecting unsupported TLS versions.
  • 429db00 Fix for test SecureSessionTest.testXdevapiTlsVersionsAndCiphersuites() failur...
  • d52033a Fix for tests failing due to using unsupported cipher suites in MySQL 5.7.
  • e18e626 Fix for tests failing due to using deprecated cipher suites.
  • 4f70ec3 Fix for Bug#91351 (Bug#28225464), MysqlConnectionPoolDataSource - autocommit ...
  • 71e4c6b Fix for property description 'ConnectionProperties.treatMysqlDatetimeAsTimest...
  • bae6356 Fix for property description 'ConnectionProperties.authenticationPlugins'.
  • 5701086 GPL license book update.
  • Additional commits viewable in compare view
  
  [](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) ---
  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 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) You can disable automated security fix PRs for this repo from the [Security Alerts page](https://github.com/dolthub/dolt/network/alerts).

go-mysql-server

• 2657: support get_format()
  MySQL Docs: https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html#function_get-format
• 2656: handle user variables in load data
  This PR adds support for assigning user variables within a LOAD DATA query, and referencing user variables withing an expression for SET clauses within the same LOAD DATA query.
  Additionally, this PR refactors much of the LOAD DATA code.
  We also moved GetField indexing out of iterator and into analyzer
  fixes: #8307
• 2653: support SET <col> = <expr>, ... clause in LOAD DATA
  partial support for: #8307
• 2652: Add sql.ContextProvider interface
  Doltgres needs a way to get a sql.Context in order to call some functions. This change adds a new sql.ContextProvider interface and has Handler implement it.
  See dolthub/doltgresql#685 for the code that needs to call this new interface.
• 2645: Fix revision databases not showing up for schema databases

vitess

• 363: support syntax for get_format
  MySQL Docs: https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html#function_get-format
• 362: parse SET statements for LOAD INFILE
  syntax for #8307
• 361: adding instant as non-reserved keyword
  The INSTANT keyword isn't in the MySQL docs, but it is a non reserved keyword.
  MySQL Docs: https://dev.mysql.com/doc/refman/8.4/en/keywords.html
  fixes: #8220

Closed Issues

• 8307: Load data error
• 8339: Panic when connection to a running server using dolt sql when stats are on

Performance