0.15.2
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 thecheckout
command.
@timsehn how do you wantcheckout
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:Changesdolt sql -x <saved_query_name> dolt sql --list-saved
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