Merged PRs
dolt
go-mysql-server
- 1529: Fix resolve subq issue with empty parent scope
- 1527: Catch missed antijoins
A resolve irregularity tries to resolve subqueries before resolving the outer scope. The result was subscopes with off-by-scope index field counts. Add a skip to delay this so we can catch more cacheable subqueries for decorrelation. A proper fix will need to rewrite resolve and field setting rules.
The runtime for the query of interest reduces from 29 min -> 18 min, despite the second breaking the join hint order. - 1521: implementing more st_... functions
implements:
Closed Issues
Latency
| Read Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| covering_index_scan | 2.03 | 2.97 | 1.5 |
| groupby_scan | 13.46 | 17.95 | 1.3 |
| index_join | 1.27 | 5.0 | 3.9 |
| index_join_scan | 1.21 | 4.25 | 3.5 |
| index_scan | 32.53 | 59.99 | 1.8 |
| oltp_point_select | 0.16 | 0.52 | 3.2 |
| oltp_read_only | 3.13 | 9.39 | 3.0 |
| select_random_points | 0.32 | 0.83 | 2.6 |
| select_random_ranges | 0.37 | 1.23 | 3.3 |
| table_scan | 33.12 | 66.84 | 2.0 |
| types_table_scan | 75.82 | 204.11 | 2.7 |
| reads_mean_multiplier | 2.6 |
| Write Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| bulk_insert | 0.001 | 0.001 | 1.0 |
| oltp_delete_insert | 2.91 | 11.87 | 4.1 |
| oltp_insert | 1.42 | 3.13 | 2.2 |
| oltp_read_write | 5.37 | 17.95 | 3.3 |
| oltp_update_index | 1.44 | 5.47 | 3.8 |
| oltp_update_non_index | 1.39 | 5.99 | 4.3 |
| oltp_write_only | 2.3 | 8.58 | 3.7 |
| types_delete_insert | 2.97 | 13.22 | 4.5 |
| writes_mean_multiplier | 3.4 |
| Overall Mean Multiple | 2.9 |
|---|