Merged PRs

dolt

• 4335: cmd user/password arguments always override yaml config
  Closes: #4333
• 4324: go/store/prolly/{message, tree}: Reduce memory footprint of message.ItemAccess, tree.Node
  • Refactored message.ItemAccess (previously ItemArray) to decrease memory footprint from 48 bytes to 10.
  • Refactored tree.Node to decrease memory footprint from 152 bytes to 56
  • tree.nodeCache now caches tree.Node instead of chunks.Chunk. This eliminates decode time for cache hits.
  • Reworked lock striping to tree.nodeCache to improved access latency.
• 4323: go/utils/remotesrv: Make remotesrv implementation into a library which can be used from dolt proper.
  Adds some functionality to remotesrv:
  • -http-port and -grpc-port can be the same, in which case there is only one listener and both gRPC and file server traffic are served over the same port.
  • the grpc server will echo the incoming request's :authority header, with the supplied -http-port, if no -http-host is supplied. Changes the default behavior of remotesrv to be that, rather than generating URLs with an authority component containing localhost as the hostname.
• 4316: Trim trailing nil fields from tuples
  This PR enforces a canonical form for tuples. Any tuple that has trailing nil field(s) will be truncated to the first non-nil field. This fixes #4270.
• 4314: go/store/prolly: Bound maximum pending writes to prolly.MutableMap

go-mysql-server

• 1255: fix numberTypeImpl.SQL() to convert from any type
  The SQL method for numberTypeImpl expects v to already be the right type for the baseType, this is not always the case.
  CASE statements have an error guard for this behavior, which shouldn't be there.
  There are likely other types that have SQL() methods that don't work for all types.
  Changes:
  • added type switch for types that are unconvertable to number
  • remove analyzer rule 'validateCaseResultTypesId`
    Closes #4306
• 1252: Reimplemented LIKE expressions to add collation support
  Previously, we were converting the patterns from LIKE expressions into patterns that the standard regex parser would understand. Said parser does not support collations (as implemented in MySQL), therefore this is a custom-developed pattern matcher for LIKE expressions that fully supports collations.
  This is ONLY for patterns on the LIKE expression. We still need to implement full regex parsing to support REGEXP_LIKE.. Once we have REGEXP_LIKE completed, we may revert this back to the regex conversion process, but that will be no time soon.
  This also fixes #4303
• 1249: UpdateJoin bug fixes
  Bug fixes for #4288
  • qualifying check constraint expressions when multiple tables are being updated
  • support finding UpdatableTables through ProcessIndexableTable and ProcessTable nodes
  • erroring out when a table updater isn't available for a SetField expression, instead of silently dropping it
    This does not address another UpdateJoin bug I just found while testing: #4304. Mentioning that one here so we have this context connected when we go to fix it.
    I verified that Dolt's enginetest suite runs correctly with these changes.

Closed Issues

• 4269: sum() of decimal types with negative numbers is incorrect
• 4333: Support --user and --password sql-server args even if their is a config.yaml
• 4270: Diff shows rows that have no diffs when a column has been added in the past.
• 4306: Panic on "conflicting" result types in IF() function
• 4288: Query to revert a single column fails
• 4303: Double backslash results in unexpected LIKE comparison

Latency

Current Default Format (__LD_1__)

New Format (__DOLT__)