This release fixes several bugs in query execution, and adds several new features:
FOUND_ROWS()
,ROW_COUNT()
, andLAST_INSERT_ID()
information functions are now supporteddolt checkout .
now works (same asdolt reset --hard
)- Column aliases supported for subqueries and
VALUES
derived tables
Merged PRs
- 1508: add the tag name variable for the brew release
- 1507: Added DELIMITER newline termination
Fixes #1495
DELIMITER
had to be terminated by the previous delimiter, similar to other statements. However, MySQL does not have this requirement (a newline is adequate for termination). This PR removes this requirement. - 1505: Upgraded go-mysql-server and vitess, and unskipped a couple tests
- 1504: Andy/json diff merge
Implements diff and merge on the JSON type. The JSON type is still behind a feature flag - 1503: /go: Bump GMS
- bump go-mysql-server
- skip 2 queries
delete stale Noms perf tests- updated dependency
github.com/shirou/gopsutil
- 1502: libraries/doltcore/rowconv: error handling
This fixes dropped errors inlibraries/doltcore/rowconv
and replacesassert.NoError()
withrequire.NoError()
in tests. - 1501: go/go.mod: Bump vitess, pick up trailing spaces sql-server fix.
- 1500: Fixed dropped errors in libraries/doltcore/row
This fixes dropped errors inlibraries/doltcore/row
, as well as replacingassert.NoError()
withrequire.NoError()
. - 1499: /go/libraries/doltcore/dtestutils: use Format_LD_1 in CreateTestEnv Switches to using
Format_LD_1
instead ofFormat_7_18
inCreateTestEnv()
. This covers mostdoltcore
tests, includingenginetests
.
One major difference betweenLD_1
and7_18
istypes.Float
serialization format. - 1498: Vinai/dolt checkout period
Addsdolt checkout .
functionality. - 1494: Fix dropped errors in libraries/doltcore/doltdocs
Fixes dropped errors, changes tests to userequire.NoError()
. - 1493: go/utils/publishrelease/buildbinaries.sh: Use CGO_ENABLED=0 to statically link release binaries on Linux.
This lets Dolt release binaries work on Linux distributions that do not use glibc, like Alpine.
Fixes #1489. - 353: Column aliases for subqueries
This depends on dolthub/vitess#66, so tests won't pass yet (but pass with a local override) - 352: switch sql.Boolean columns in enginetests typestable to use 0 instead…
… of false - 351: sql/analyzer: Make column resolution more reliable when a subquery alias is under a table alias node.
Using a common table expression (and probably using a view), you can alias a common table expression. Some analyzer steps, and in particularprune_columns
, assume the subquery alias is the name that the parent schema sees. This adds an analyzer pass that flattens nested table aliases and a table alias on a subquery alias into the bottom-most node. - 350: Fixed a number of bugs in aliases and name resolution revealed by recent changes to the parser
Also added output schema verification to engine tests, and wrote some tests of same. - 349: ROW_COUNT(), FOUND_ROWS() and LAST_INSERT_ID()
Implemented ROW_COUNT(), FOUND_ROWS() and LAST_INSERT_ID(), as well as support for SQL_CALC_FOUND_ROWS with a LIMIT clause. - 347: Vinai/binary func
Adds theBINARY
operator to gms - 66: Support for subquery / values column aliases
- 65: go/vt/sqlparser/ast.go: SplitStatementToPieces: Avoid appending an empty "query" when splitting an incoming ComQuery.
- 64: Strip quotes and backticks from select expressions