github dolthub/dolt v0.50.14
0.50.14

latest releases: v1.43.13, v1.43.12, v1.43.11...
2 years ago

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 linux dolt 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 with GROUP 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

Don't miss a new dolt release

NewReleases is sending notifications on new releases.