Merged PRs

dolt

• 9346: /docker/docker-entrypoint.sh: support env vars for creating a default database
• 9344: Nathan/commit time (Temporarily) fixes issue [#8477]. Commits in the shell created via \commit now have the correct time.
• 9336: Fix 4160 dolt commit amend flag for initial commit BuildNewCommit() now checks opts.Amend before implicitly appending parents to commit Fixes: https://github.com/dolthub/dolt/issues/4160
• 9271: go: sqle/statspro: Make ANALYZE TABLE faster by circumventing the rate limiter on stats work. When a user is requesting the analysis, we should not rate limit resource utilization in the same way we do when collecting stats in the background. Also simplifies the implementation of rate limiting a bit.

go-mysql-server

• 3028: add mysql dialect tag to new group by test new group by test added in dolthub/go-mysql-server#3025 is not Postgres/Doltgres compatible
• 3025: Convert if.Eval result to correct type if.Eval().Type() should evaluate to if.Type(), instead of whatever type the chosen subexpression is. https://dev.mysql.com/doc/refman/8.4/en/flow-control-functions.html#function_if Fixes [#9320]
• 3023: like match when collation is unspecified For some reason the LikeMatcher returns false with no error on unspecified collation, so this PR fixes that. Fixes: https://github.com/dolthub/dolt/issues/9337
• 3021: Added test for insert...select...returning Fixes [#9248]
• 3020: Support OCT() function and fix CONV() mishandling of negative floats and empty string N MySQL Docs: https://dev.mysql.com/doc/refman/8.4/en/string-functions.html#function_oct

vitess

• 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: https://github.com/dolthub/dolt/issues/9313
• 420: Make returning a reserved keyword Part of [#9248] Making returning a reserved keyword allows for returning clause in all types of insert statements

Closed Issues

• 9035: NULL in GROUP BY column is interpreted as 1
• 9347: Panic with case statements in information_schema.tables access
• 7998: Casting json to string doesn't escape double quotes in keys/values
• 4160: dolt commit --amend returns error for initial commit
• 9313: Incompatibility of streaming prepared statement responses with github.com/go-mysql-org/go-mysql
• 9345: Support MYSQL_DATABASE and DOLT_DATABASE environment variables in Dolt Docker image.
• 9320: Group-By with IF function fails to distinguish the integer "1" and the boolean value "true"
• 9307: UNKNOWN_CODE_PLEASE_REPORT: No authentication methods available for authentication.
• 9325: Support OCT() function
• 9324: Panic when pushing to remote