0.57.2

Merged PRs

doltgresql

• 2990: Flesh out remaining pg_catalog tables
• 2988: Regression test for bug fix in lookup join when using extended types
  Fixes: #2979
  Depends on: dolthub/dolt#11368
• 2987: Add regression tests for bug fix in CASE support for ExtendedType
  Depends on: dolthub/go-mysql-server#3656
  Related to: #2980
• 2983: Re-enable replication tests on MacOS
  GitHub MacOS runners can take a long time to do DNS lookups, even for localhost, which was the root cause of the races on that platform. All are now changed to the loopback IP.
  Also fixes an unrelated bug: connections that default to a DB with the same name as a user are now rejected if that DB doesn't exist.
• 2982: Allow aliasing columns in a table function
  Allows aliasing the column names of a table function, such as: SELECT * FROM generate_series(1,3) AS s(r).
  Also enables regproc to work with schema-qualified procedures.
  Both of these gaps were found while fixing a gap to enable DBeaver to work correctly with Doltgres.
  Depends on:
  • dolthub/vitess#477
  • dolthub/go-mysql-server#3652
• 2977: Hidden column support
  This adds partial support for hidden columns, in that they return empty values, but don't have the full internal mechanics backing them at this time.

Closed Issues

• 2979: Server panic in kvexec lookup-join when the join key is not the first non-PK column (0.57.0 + 0.57.1)
• 2980: CASE with mixed numeric/integer branches resolves to text — SUM errors, MAX returns silently wrong values (0.57.1)
• 2973: Silent data corruption: int4 parameter bound to BIGINT column is misread as int8 when the same statement contains an untyped NULL parameter (extended query protocol)