We are excited to announce the release of Dolt 0.15.2.

AS OF Further Enhanced

In our last release, 0.15.1 we highlighted the ability to query AS OF a branch or commit. In this release we expand this functionality by allowing uses to query AS OF a timestamp. This represents a version of the syntax familiar to users of other SQL databases with versioned data support. Thus we allow users to treat the underling commit graph as either wall clock time or relative to a commit.

TIMESTAMP and DATETIME functions

Dolt SQL now supports TIMESTAMP and DATETIME functions, which can be used to construct a time object of the given type. DATETIME('2020-03-01') and DATETIME() will return the given time or the current time, respectively.

Other

We continue to make enhancements to our underlying SQL engine, and other assorted bug fixes.

As usual, let us know if you have any thoughts by filing an issue!

Merged PRs

• 487: fix issue with merge blowing away changes in working
  Previously we used to fail if there was anything checked out and you tried to merge. Then we went to the git model where we would allow merging as long as the changes in the working set didn't touch the same tables as the changes in the commit being merged. For fast forward merges this was stomping working table changes as we'd just set the root and not re-apply the changes to the tables that were modified in the working set.
• 485: Andy/ci compatibility
• 482: Db/bats merge stats
  One test for inaccurate merge stats, one for confusion with the checkout command.
  @timsehn how do you want checkout to work when branch name and table name are identical?
• 481: go/go.mod: Upgrade dependencies.
• 480: /go/{go.mod, go.sum}: Update go.mod github.com/liquidata-inc/sqllogictest
• 478: execute saved query
  Implements:

  dolt sql -x <saved_query_name>
  dolt sql --list-saved
  

  Changes
  • dolt sql -s <name> -q <query> now saves the query with id = name
• 476: Zachmu/as of timestamp
  Support for AS OF queries with a timestamp
• 475: bump version
• 75: Added database qualifiers to view resolution.
• 74: Zachmu/datefns
  Added support for DATETIME() and TIMESTAMP() functions
• 73: Zachmu/as of
  Support for pushing AS OF clauses down to tables in a view. Kind of janky, but works great!
• 72: update vitess dep