Merged PRs

dolt

9599: go: sqle: autoincrement_tracker: When we close the engine.SqlEngine, finalize any ongoing initialization of AutoIncrementTrackers.
This lets us more cleanly close DoltDB instances, which we should not be accessed after we close them.
9595: Update MySqlConnector to latest version
The NuGet package and .NET version being used were both out of support.
9561: #9554 - Fix varbinary fields displaying as unicode instead of hex
Fixes #9554
- Adds --binary-as-hex flag to print binary types varbinary and binary as hex through custom iterator in the print layer
9560: Better dolt_query_catalog system table
Updates the dolt_query_catalog system table to use the following:
1. dolt_query_catalog is now a permanent writable system table, so can be used in the server context, and no longer requires cli initialization.
2. dolt sql options --save, --list-saved, and --execute now can be used in the server context.
3. The above options now follow conventions for usage in directories without initalized dolt repos.
4. Slightly improved test coverage.

3131: Unwrap ParenExpr when evaluating OrderBy expressions
fixes #9605
Commit 5cbc653 says "group by" but it should be "order by"
3126: Added test for adding check constraint when modifying column
Test for dolthub/vitess#422
3123: Support decimal unique keys
fixes #3071
3117: drop sorts in cross joins and inner joins
This PR applies the sort removal optimizations over cross and inner joins.

423: Allow using FOR UPDATE NOWAIT in SELECT statements
Fixes #9604
422: Add ConstraintAction when modified column has a constraint
fixes #9591
test added in dolthub/go-mysql-server#3126
421: fix up constants for server cursor types and add a support for PARAMETER_COUNT_AVAILABLE cursor
We were missing the PARAMETER_COUNT_AVAILABLE server cursor type when handling a COM_STMT_EXECUTE.
Oddly, it seems to behave as if there were no cursor.
MySQL Docs: https://dev.mysql.com/doc/dev/mysql-server/9.3.0/mysql__com_8h.html#a3e5e9e744ff6f7b989a604fd669977da
Fixes: #9313

9605: order by CTE table seems not to work
9554: varbinary fields are presented as unicode instead of hex
9604: SELECT ... FOR UPDATE NOWAIT, introduced in MySQL 8.0, cannot be parsed correctly
9598: Deleting an active branch used in multiple connections results in unrecoverable state
9591: Check constraints in modify column statements are ignored.
5400: UPDATE JOIN doesn't support triggers
2111: The time zone generated by CURRENT_TIMESTAMP is not the expected time zone
3071: In-memory tables don't support DECIMAL(...) UNIQUE KEY