github dolthub/dolt v1.0.2
1.0.2

latest releases: v1.43.14, v1.43.13, v1.43.12...
18 months ago

Merged PRs

dolt

  • 5923: Prepend table name to auto-generated constraint check names.
    Fixes #5915
  • 5922: Changing schema equality to not consider tag when comparing columns
    Two tables can have identical schemas, but different column tags if the columns were created in different orders (e.g. a different sequence of alters to get to the same schema). When we try to merge those two tables, we see that there is not a common ancestor, so we require the schemas to be exactly identical in order to merge the data. This results in a confusing merge error for customers because we tell them the schemas are different, but they look exactly the same (except for the different column tags).
    This change removes column tags from equality checks when testing equality of two schemas and enables the case above to merge cleanly.
  • 5913: Bh/replication metrics
    Adds some replication metrics to the prometheus metrics published by dolt.
  • 5907: go/doltcore/merge: model NOT NULL constraint violations
    …olations table

go-mysql-server

  • 1770: Union offset+limit bug
    Unions were dropping limit, applying offset as limit.
  • 1768: CREATE LIKE statements should preserve check-constraints on the new table.
  • 1767: Timezone improvements
    This PR starts handling some timezone differences between GMS and MySQL:
    • The NOW() and CURTIME() functions now respect the sessions's current time zone
    • Allows CONVERT_TZ to mix use of timezone names (e.g. UTC) and timezone offset strings (e.g. +00:00)
    • Adds some skipped tests for timestamp input/output session timezone conversion

Closed Issues

  • 5915: Generated names for checks are not guarenteed to be unique.
  • 5072: CREATE TABLE LIKE does not replicate CHECK constraints
  • 5917: Problems uploading data with ogr2ogr (spatial data)
  • 5906: Dolt is especially slow executing queries from within a loop
  • 3963: Eliminate column tags, use column name for identity in all cases
  • 5531: Foreign Keys can be dropped in a merge of branches that both resolve foreign keys

Latency

Read Tests MySQL Dolt Multiple
covering_index_scan 1.93 2.76 1.4
groupby_scan 12.3 16.41 1.3
index_join 1.16 4.03 3.5
index_join_scan 1.12 2.07 1.8
index_scan 30.26 54.83 1.8
oltp_point_select 0.14 0.49 3.5
oltp_read_only 2.86 8.43 2.9
select_random_points 0.29 0.75 2.6
select_random_ranges 0.35 1.14 3.3
table_scan 30.81 55.82 1.8
types_table_scan 69.29 170.48 2.5
reads_mean_multiplier 2.4
Write Tests MySQL Dolt Multiple
bulk_insert 0.001 0.001 1.0
oltp_delete_insert 5.37 5.77 1.1
oltp_insert 2.52 2.86 1.1
oltp_read_write 6.55 15.55 2.4
oltp_update_index 2.48 2.97 1.2
oltp_update_non_index 2.61 2.97 1.1
oltp_write_only 3.62 7.3 2.0
types_delete_insert 5.18 6.67 1.3
writes_mean_multiplier 1.4
Overall Mean Multiple 2.0

Don't miss a new dolt release

NewReleases is sending notifications on new releases.