Merged PRs

dolt

• 10576: dolt_test input validation
  Added constraints to the dolt_tests table so that invalid values can't be inserted. Didn't use an ENUM because that would break databases which created tests before this version (backwards incompatible)
  Fixes: #10568
• 10550: go/store/nbs: journal.go: Crash rather than continue on error if dropJournalWriter fails in a critical spot.
• 10548: {proto,go/serial}/MODULE.bazel: Bump some module versions.
• 10480: proto/: Migrate protobuf and flatbuffer message generation to Bazel.
  Previously these were managed by submodule dependencies on the tools which had to be manually built in a non-hermetic environment by a developer and then a shell script or a Makefile which generated the actual source files into the repository.
  Migrate those dependencies to Bazel modules or remote repositories, and wire things up so that a single target, //:update in the proto/ directory, can be bazel run to update both protobuf and flatbuffer messages.

go-mysql-server

• 3449: keep top-level plan.Limit for doltgres generate_series
  PR dolthub/go-mysql-server#3432 replaced plan.Limit nodes with plan.TopN, because they are unnecessary for anything in dolt and gms. However, because of the way generate_series works with LIMIT, we actually need to keep the plan.Limit at the top.
  This should have minimal impact on performance
• 3447: Handle Decimal types in greatest and least functions
  fixes #10562
• 3442: sql/types: implement NumberType for system numeric types

  Summary

  • Implement sql.NumberType for system numeric system-variable types:
  • SystemBoolType
  • systemIntType
  • systemUintType
  • systemDoubleType
  • Add compile-time interface conformance checks for these types.
  • Add tests to verify:
  • sql.IsNumberType recognizes system numeric types.
  • stats join alignment accepts system numeric types (AlignBuckets path).

  Testing

  • go test ./sql/types ./sql/stats
  • go test ./sql/... -run TestDoesNotExist -tags=gms_pure_go

  Related

  • Relates to #10535
• 3441: bug fix: allow ALTER TABLE DROP CONSTRAINT to remove unique indexes
  When adding a unique constraint to a table, it wasn't possible to remove it using ALTER TABLE DROP CONSTRAINT. This change allows unique indexes to be removed with this syntax.
  Related to: dolthub/doltgresql#2359
• 3432: TopN optimizations
  Changes:
  • Replace LIMIT(PROJECT(SORT(...))) with PROJECT(TOPN(...))
  • When TopN(Limit = 1), use topRowIter to avoid interface conversions and extra mallocs.
    Benchmarks: #10522 (comment)

vitess

• 457: Add support for SHOW EXTENDED COLUMNS syntax
  Adds support for parsing the EXTENDED keyword as part of the SHOW EXTENDED COLUMNS syntax.
• 456: add AuthInformation to FuncExpr
• 455: go/mysql: Add some recycleWritePacket calls on error returning paths where the ephemeral packet was not previously returned.
• 453: Add support for serializing optional table map metadata
  To support @@binlog_row_metadata = 'FULL', we need support for serializing optional table map metadata.

Closed Issues

• 10568: dolt_tests can be populated with impossible values
• 10562: unsupported type for greatest/least argument: decimal.Decimal
• 10537: Git remote push performance: ~45-80s per push for tiny databases over fast connection
• 10544: Automatic Garbage Collection not on by default in auto-generated config.yaml