This release addresses a number of correctness bugs and improves query performance.
Merged PRs
- 1285: Upgraded to latest go-mysql-server, and added a skip for a new query plan test
- 1284: fix projected columns with single partition indexes
- 1280: o/libraries/doltcore/table/editor: Add ability to configure map editor flush interval with environment variables.
- 1269: Implement StatisticsTable interface to provide table statistics to the analyzer.
- 1267: Fix bug where batched inserts containing subqueires chose non flushing option..
- 1264: adds ability to redirect stdin from a file
- 282: Bug fix for pushing a projection down to a table in a subquery more than once
- 278: remove sync.Once from autoincrement expression
- 275: add StatisticsTable interface
- 274: Fixed various bugs in subquery execution, added table ordering optimization
Fixes many correctness issues in subquery execution:- Incorrect field indexes for subquery aliases in some cases
- Incorrect field indexes for subquery expressions in the case of column pruning in other parts of the query
- Queries selecting the same table more than once with aliases getting incorrect indexes applied
Also introduces performance enhancements: - Table ordering optimizations based on rows counts of tables in a join
- Better use of index pushdown for some join queries
- 273: Added the VALUES() function
Requested in: #1225
VALUES()is deprecated in the latest versions of MySQL (as of version 8.0.20, released April 2020), but it is recent enough that I feel its inclusion in the engine is justified.