Skip to content

0.15.2

Compare
Choose a tag to compare
@oscarbatori oscarbatori released this 24 Mar 22:06
dcc3f53

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