Merged PRs

dolt

• 8730: Make show command more resilient when resolving references
  Currently the show command can print internal objects, which requires a local environment. This goes against the sql migration expectations that there is no environment. This change only makes the situation less bad. Splitting out the admin operations into another command is the right approach.
  Fixes: #8727
• 8726: Replace min/max helpers with built-in min/max
  We can use the built-in min and max functions since Go 1.21.
  Reference: https://go.dev/ref/spec#Min_and_max
• 8719: Replace min/max helpers with built-in min/max
  We can use the built-in min and max functions since Go 1.21.
  Reference: https://go.dev/ref/spec#Min_and_max
• 8644: Generate config.yaml when running sql-server
  If sql-server is ran without a specified config file and there is no config.yaml in the database directory, one will be generated.
  The rules for how the default config.yaml file is generated are as follows:
  • If a field has a value defined by the sql-server execution (such as through CLI args), then that value will be used.
  • If a field has no set value but has a default value, then that default will be used.
  • If a field has no set value and no default, a commented-out line setting the field to null will be included as a placeholder.
    Part of #7980

go-mysql-server

• 2811: Reset BytesBuffer after each rowBatch
  Once we spool a batch of rows to client, there's no reason to keep them in memory.
  Fixes #8718

Closed Issues

• 8736: Sort/Alias dependency conflict preventing prune
• 8735: [Bug] FULL OUTER JOIN not commutative, and not giving correct results
• 8724: [Bug] Incorrect SUM calculation in CTE with correlated subquery
• 8727: \show in SQL shell panics when arg isn't a commit
• 8718: mydumper OOMs in deterministic fashion for large database

Performance