This release adds alpha support for the following SQL features:
- Stored procedures
- Common table expressions (WITH clause)
- LOAD DATA statements
Merged PRs
- 1425: Upgraded go-mysql-server
- 1419: Expose Load data and add a bunch of tests.
This PR exposes LOAD DATA to Dolt. This is a relatively new path to import data into a dolt repo. - 1411: libraries/doltcore/schema/typeinfo: fix dropped errors
This fixes a dropped test error and a dropped code error inlibraries/doltcore/schema/typeinfo
. - 1410: libraries/doltcore/schema/alterschema: fix dropped errors
This fixes dropped test errors inlibraries/doltcore/schema/alterschema
. - 1409: libraries/doltcore/rebase: fix dropped errors
This fixes droppederr
variables inlibraries/doltcore/rebase
. - 1408: bump gms and jsonagg
- 1407: libraries/doltcore/merge: fix dropped errors
This fixes dropped code and testerr
variables inlibraries/doltcore/merge
. - 1406: diff printing fix
Columns with % signs were being printed using printf style functions which were looking at %s and escape characters. - 1405: Turn off discord notify for now
- 1403: add file copy helper method to iohelp package
generally useful io helper method - 1402: diff between a range of values
allows for performance improvements. Not used in dolt yet, but used by the bounty attribution code. - 1401: chunk store in a file no manifest needed
Utility library used by bounties - 1391: libraries/doltcore/diff: fix dropped error
This fixes a droppederr
inlibraries/doltcore/diff
. - 1387: Refactoring error message in merge.go [ https://github.com//issues/1307#issue-804175419 ]
Issue ID : #1307 (comment) - 1386: Added file names to bats tests
Also edited some of the titles to cut down on redundancy since the file names are now in the title. This makes it far easier to see what test belongs in what file if a test ever fails. - 330: Support for WITH clauses (common table expressions)
- 328: Vinai/load data quick fixes
Add quick fixes from testing load data on the Dolt side. - 327: Add functionality and tests for JSON_ARRAGG.
This pr does not include window function capabilities - 326: Added function stubs for unimplemented JSON functions
31 unimplemented JSON functions, including two aggregation functionsJSON_ARRAYAGG
andJSON_OBJECTAGG
. - 58: Add json aggregate functions to ast.go
- 57: Implemented common table expressions (WITH)
Also removed a bunch of unused vitess-only constructs from the grammar. - 56: Capture the verbatim expression for select statements
This is a bit hacky and currently breaks on embedded comments. But in general this lets us faithfully reproduce the verbatim select expression in the return schema, which is required for compatibility with some clients.
Also makes expressions such asMAX(a as b)
illegal, allowed before. - 55: Small parser fixes for stored procedures
- 54: Vinai/load data basic network handling.
Basic steps for packet management. Have text with files up to 1gb.
Definitely some more work to be done here in the future. Is it optimal to write everything to a file or can we do something better? Regardless, I think this is a good enough start for Max to get unblocked while I continue to build more functionality. - 52: Allow reserved words as column names for CREATE TABLE statements
Needs tests - 51: Vinai/load data p1
- 50: Removed CODE keyword
- 49: Max/float53
adds support and tests forFLOAT(prec)
, which will help with pandas table creation.