Merged PRs

dolt

• 8872: Add the dolt_backups table
  Read only table which only lists the name and url of backups created by the dolt_backups procedure

go-mysql-server

• 2857: [cte] fix issue with invalid cte scope mapping
  fixes: #8871
  We were not setting subquery scope mapping, which produced a nil expression when trying to preform a filter inversion.
• 2856: have explain format=tree,debug,estimates print an explain tree
• 2855: fix insert for subquery aliases with on duplicate update expr
  The table not found error was actually a bad error message; it really wasn't finding the column due to some weird logic around resolving duplicate indexes.
  The logic assumes that n.Destination.Schema() and n.Source.Schema() must be equal length, and if it's not then we need to replace the Source columns' Source node with the provided OnDupValuesPrefix.
  Additionally, when assigning getfield indexes, we can't assume that if the schema lengths are mismatched that they must be using the OnDupValuesPrefix. Instead, we should always search for a matching column, and then substitute.
  fixes: #8862
• 2853: [expression] coalesce should cast return values
  fixes: dolthub/go-mysql-server#2847

Closed Issues

• 8871: panic (cause not yet known)
• 8835: dolt init fails if dolt config is run without global arguments
• 8862: derived table syntax not supported (in select with insert into?)
• 2847: BUG: Element types don't match MySQL: query-results have inconsistent types

Performance