We are pleased to announce the release of Dolt version 0.14.0.
Query Catalog
The major new feature in this release is the query catalog, which is implemented via adding additional options to the dolt sql command. Users can now pass --save and --message options to SQL queries to save and version them at the repo level:
-s <saved query name>, --save=<saved query name>
Used with --query, save the query to the query catalog with the name provided. Saved queries can be examined in the dolt_query_catalog system table.
-m <saved query description>, --message=<saved query description>
Used with --query and --save, saves the query with the descriptive message given. See also --name
This will allow users to document their data with versioned SQL queries. In the future we hope to make this a validation tool.
Assorted Fixes and Improvements
We continue to make progress on our SQL implementation, both in terms of correctness and performance. For example, GREATEST() now supports timestamps. We are prioritizing correctness over performance, though we are making gains in performance.
As usual, if you see anything amiss, please don't hesitate to file an issue.
Merged PRs
- 401: Fixed arg-parsing.bats not working on Windows
- 400: Added 2 skipped argument parsing bats tests.
We don't support Nix style argument parsing completely right now - 399: Quote view name on create view
- 395: go/cmd/dolt/commands/sql.go: Always close row iters. Improves robustness when SQL returns an error.
- 394: Km/doc diff print bug
- 393: Bumped go-mysql-server version
Integrates dolthub/go-mysql-server#65 into dolt - 390: bats/sql.bats: Document some unsupported SQL features with some failing bats tests.
- 389: go.mod: Upgrade dependencies.
- 386: delete cell values on drop column
- 383: deadlock fix
- 382: README.md: Add sudo invocation to install instructions.
- 379: no whitespace column names
- 378: Bumped go-mysql-server version
- 376: Added skipped test for select as
- 375: Zachmu/query save feature
Implemented query saving via new dolt_query_catalog table, created by dolt sql -q -s.
Also:- Unified business logic for validating table names in every code path where a table is created
- Separated out read-only, read-write, and alterable SQL tables
- Refactored deeply nested error handling logic in mv and cp commands
- Refactored import command to separate validation from execution logic
- Added many tests
- 372: check for nil or empty column headers
@timsehn do we want to allow whitespace column names? - 371: unskip test after fixing query
- 369: fix metrics bug
- 368: chunk store metrics wrapper
- 367: Changed add all shortcut from lowercase a to uppercase A to match git.
Added corresponding bats test.
Fixes #345 - 366: name already existing file in error message
- 365: Bumped version for 0.13.2 release
- 364: Added a basic tests for dolt_diff_ and dolt_history_ system tables.
Found weird behavior in dolt_diff_. - 363: Fix error message when table doesn't exist
Fixes #275. - 65: Added DATETIME handling to GREATEST/LEAST functions
Fixes #380 - 63: sql/expression/function: Add UNIX_TIMESTAMP function.
- 62: Fix stupid compilation issue
- 61: small fixes
- 60: Fixed Bit type
- 59: Fixed a bug in drop table logic caused by variable shadowing. No test…
…s of this behavior because we don't have an easy way to make an operation like DropTable return an error in the in-memory database.