Merged PRs
dolt
- 4714: GMS bump
- 4710: go/doltcore/sqle: pickup sql.IndexDef bump
- 4703: go/store/nbs: fix memory accounting for
MemoryQuotaProvider
- 4692: Got rid of testing libraries from dolt binary
This decreases the size of the linuxdolt
binary by 8MB, from 75 to 67MB.
go-mysql-server
- 1381: Adding support for setting 'ANSI' as a
sql_mode
Fixes: #4663 - 1380: sql: Added IndexDef to sql/index.go, sql/core.go
- 1379: prepend rows for only projector nodes
This PR was reverted but now it has fixed tests that passes for dolt engine tests. The table is keyless table, which causes output result to be in randomized order in dolt compared to gms, so the tests now include order by clauses to persist the order of the output rows. - 1377: make json ordering tests less strict
We shouldn't include tests for ordering between two MySQL "json object" types. MySQL notes that their ordering is unspecified but deterministic.
The new storage format has a different deterministic ordering than the old storage format in dolt. - 1373: Validate stored procedures, but only throw errors when they are invoked.
This fixes #4670
Closed Issues
- 1478: CREATE TABLE ... AS SELECT ... supports DISTINCT
- 4699: dolt sql not showing results (windows)
- 4606:
show keys from information_schema.columns
panics - 4623:
dolt sql-client
panics if passed a branch scoped database - 4628:
dolt sql-client -q
does not acceot multiple statements - 4635:
dolt sql-client --no-auto-commit
still commits - 3334: JSON output might be broken due to invalid escapes in the data
- 4670: Stored procedure referencing dropped column causes error during checkout or reset.
- 4365:
IN
predicate returns wrong results when used withGROUP BY ... HAVING
subquery
Latency
Read Tests | MySQL | Dolt | Multiple |
---|---|---|---|
covering_index_scan | 2.0 | 2.71 | 1.4 |
groupby_scan | 12.52 | 16.71 | 1.3 |
index_join | 1.21 | 4.57 | 3.8 |
index_join_scan | 1.14 | 3.82 | 3.4 |
index_scan | 30.26 | 53.85 | 1.8 |
oltp_point_select | 0.15 | 0.47 | 3.1 |
oltp_read_only | 2.97 | 8.74 | 2.9 |
select_random_points | 0.3 | 0.75 | 2.5 |
select_random_ranges | 0.35 | 1.12 | 3.2 |
table_scan | 30.26 | 63.32 | 2.1 |
types_table_scan | 69.29 | 189.93 | 2.7 |
reads_mean_multiplier | 2.6 |
Write Tests | MySQL | Dolt | Multiple |
---|---|---|---|
bulk_insert | 0.001 | 0.001 | 1.0 |
oltp_delete_insert | 3.13 | 12.08 | 3.9 |
oltp_insert | 1.61 | 2.71 | 1.7 |
oltp_read_write | 5.28 | 17.01 | 3.2 |
oltp_update_index | 1.58 | 5.28 | 3.3 |
oltp_update_non_index | 1.64 | 5.57 | 3.4 |
oltp_write_only | 2.39 | 8.13 | 3.4 |
types_delete_insert | 3.25 | 16.12 | 5.0 |
writes_mean_multiplier | 3.1 |
Overall Mean Multiple | 2.8 |
---|