github dolthub/dolt v1.78.0
1.78.0

8 hours ago

Merged PRs

dolt

  • 10085: Allow DOLT_LOG table function to defer parsing of arguments until row iteration.
    This allows us to implement correct behavior for a DOLT_LOG table function in a subquery or lateral join with references to the outside scope.
  • 10084: Dolt bump for gms zeroTime update
    depends on dolthub/go-mysql-server#3305
    Changes how ZeroTime dates are written to storage

go-mysql-server

  • 3305: Fix datetime functions to return correct results for 0 and false
    Fixes #10075
    Our datetime functions were not returning the correct results for 0 and false. This was because we were using 0000-01-01 as zeroTime (which evaluates to true using Go's time.IsZero) and then extracting datetime information from that timestamp. Using 0000-01-01 as zeroTime was also giving incorrect results for some functions when the input timestamp was actually 0000-01-01, since it was being equated as zeroTime.
    Also, depending on whether false was read as false or 0, we were also not able to convert it to zeroTime.
    This fix involves updating zeroTime to time.Date(0, 0, 0, 0, 0, 0, 0, time.UTC), which has the timestamp -0001-11-30. Since negative years are not valid in MySQL, this timestamp would not conflict with a non-zero timestamp. We also add in checks for zeroTime to make sure functions return the correct value from zeroTime instead of simply extracting datetime information from the timestamp.
    Dolt bump PR: #10084
  • 3298: Validate connection security properties
    Extends authentication handlers to validate additional connection properties (e.g. SSL, X509 client cert, cert issuer, cert subject) when additional connection constraints have been configured for a user.
    Note: tests for this functionality are in #10067
    Related to #10008

Closed Issues

  • 10075: Unexpected DAYOFMONTH Result

Don't miss a new dolt release

NewReleases is sending notifications on new releases.