build(deps): bump github.com/dolthub/go-mysql-server from 0.17.0 to 0.18.0

[dependabot[bot]]

Bumps github.com/dolthub/go-mysql-server from 0.17.0 to 0.18.0.

Release notes

Sourced from github.com/dolthub/go-mysql-server's releases.

Q1 2024 Release

This is our quarterly roll-up release that contains many bug fixes, features, and performance improvements. Reminder that interfaces are not guaranteed to settle until 1.0.

This release contains a breaking change for setting up an in-memory database server, e.g. in testing. The in-memory database now requires its own session implementation, and the server must be supplied with a compatible session builder to prevent panics. See the _examples directory for an example.

Merged PRs

go-mysql-server

• 2350: [planbuilder] Limit allows unsigned ints Parameterizing limits in stored procedures exposed a bug where we weren't accepting unsigned ints in LIMIT/OFFSET. This is only possible in prepared or stored procedure contexts afaik.
• 2348: Optional integrator schema validation Move table schema validation so that we validate the accumulated result rather than sequential alters.
• 2347: implement json_depth() MySQL Docs: https://dev.mysql.com/doc/refman/8.0/en/json-attribute-functions.html#function_json-depth
• 2346: fix null and empty paths for json functions
• 2345: Return correct MySQL error code when inserting into nonexistent columns. Fixes dolthub/go-mysql-server#2344 This PR also adds a test framework for testing MySQL error codes, since this doesn't appear to currently be tested. This should make adding tests for other error codes easy. Some of the MySQL error codes that I expected us to use (such as 1050: ERTableExists) have zero usages in GMS or Dolt. We're probably returning 1105: ERUnknownError for these.
• 2343: fix json bool comparison JSON Boolean values are special; they do not behave like normal when converted/compared against other types. fixes dolthub/dolt#7528
• 2342: Add row length guards Tests and basic engine-side guards similar to mysql's behavior. re: dolthub/dolt#7524
• 2339: only use crosshashjoin on subqueryaliases This fixes 2 sqllogictests.
• 2336: fix rangetree removal of largest node without left child When removing a right child, a missing nil guard was causing us to improperly propagate the new max range. This resulted in overlapping ranges. This fixes 1 sqllogictest.
• 2335: Schema pruning considers database name Fix some inconsistencies with project and join hints. New test added for new project pruning changes.
• 2334: fix char to bool conversion This PR adds missing nil guards in a few conversion methods. fixes dolthub/dolt#7515
• 2333: [planbuilder] Skip post-aggregate projection when there are no aliases in target scope re: dolthub/dolt#6982 This takes the last big chunk of CPU pressure off of TPC-C execution, which is mostly disk limited now:
• 2332: [time] shortcut for no timezone conversion This function reads files from disk to try to convert a timezone to itself. There are other optimizations we could do to maybe try checking for the integer offset before doing syscalls. re: dolthub/dolt#6982, ~10% TPC-C boost
• 2331: fix NOT expression in conjunction with WHERE EXISTS(<subquery>) The analyzer rule unnest_exists_subqueries was accidentally dropping NOT expressions when hoisting subqueries from WHERE EXISTS... clauses. This should fix 8 sqllogictests. Correctness: dolthub/dolt#7510
• 2330: Fix DISTINCT over DECIMALS

... (truncated)

Commits

• 8122f68 [ga-bump-dep] Bump dependency in GMS by jycor (#2352)
• 61579ae [no-release-notes] fix bug in memory session data management (#2353)
• a4f33df [planbuilder] Limit allows unsigned ints (#2350)
• ac39104 Optional integrator schema validation (#2348)
• 060b45b implement json_depth() (#2347)
• 0f1cfb7 Merge pull request #2345 from dolthub/nicktobey/mysql-errors
• c79a923 fix null and empty paths for json functions (#2346)
• 5826e68 Update handler_test tests to work when run together or individually.
• a028ca9 Merge pull request #2319 from seanlaff/customNetListener
• d6f264c [ga-format-pr] Run ./format_repo.sh to fix formatting
• 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 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)

[github-actions[bot]]

Manual Tests

:information_source: Remember to ask team members to perform manual tests and to assign tested label after testing.

[github-actions[bot]]

Manual Tests

:green_heart: Manual testing by @mrz1836 resulted in success.

[mergify[bot]]

This pull request looks stale. Feel free to reopen it if you think it's a mistake.

[dependabot[bot]]

OK, I won't notify you again about this release, but will get in touch when a new version is available. If you'd rather skip all updates until the next major or minor version, let me know by commenting @dependabot ignore this major version or @dependabot ignore this minor version. You can also ignore all major, minor, or patch releases for a dependency by adding an ignore condition with the desired update_types to your config file.

If you change your mind, just re-open this PR and I'll resolve any conflicts on it.