Skip to content

1.42.18
Compare
Choose a tag to compare
@github-actions github-actions released this 05 Sep 05:59
v1.42.18
74cb601

Merged PRs

dolt

  • 8321: Optional String Argument
    support optional string arguments in the middle of command line args.
  • 8319: reset auto increment counter on dolt_reset('--hard')
    When calling dolt_reset(--hard), we don't properly reload the auto increment value from the global tracker.
    The bug is a side effect from maintaining auto increment value between branches. We track the last greatest auto increment value across all branches in the session, and dropping a table sets the previous auto_increment value to 0.
    The fix is to get the tracker to reload values when resetting.
    Some notable behavior here is that a dolt_reset over insert will not reset the auto_increment tracker.
    fixes: #8272
  • 8314: Fix Integration Workflow
    This is Dolt's counterpart to the following PR:
  • 8313: Fixed table resolution for reset
  • 8309: Minor doc updates
  • 8306: Export DoltSystemVariables var so that it can be used by doltgres

go-mysql-server

  • 2651: fix collations with recursive hash for HashInTuple expressions
    When hashing tuples, we don't take into account the collation of the individual elements, which results in incorrect comparisons for case insensitive collations.
    The fix here was to recursively hash each individual element in a tuple, and hash the slice of hashes.
    fixes #8316
  • 2650: conflict in EqualityRangeBuilder
    Fix bug in equality range builder where duplicate equality filters to one value would stomp each other.
    fixes: #8317
    dolt-side: #8322
  • 2645: Fix revision databases not showing up for schema databases

Closed Issues

  • 8317: SELECT WHERE (id = x AND id = y) returns row matching y instead of no results
  • 8330: Unique index not used when there is an IN expression in conditional
  • 8333: Class of Query intermittently slow on Wikipedia Import to Media Wiki
  • 8332: Slow query on where clause in composite primary key
  • 8316: Sqlalchemy can't reflect schema with foreign key
  • 8331: Slow query on wikipedia import to Media Wiki
  • 8272: dolt_reset(--hard) after a drop table reserts the auto_increment counter to 1
  • 8308: Empty result set from query with INNER JOIN + WHERE

Performance

Read Tests MySQL Dolt Multiple
covering_index_scan 2.07 0.67 0.3
groupby_scan 13.22 16.41 1.2
index_join 1.37 2.66 1.9
index_join_scan 1.3 2.11 1.6
index_scan 34.33 54.83 1.6
oltp_point_select 0.18 0.3 1.7
oltp_read_only 3.49 5.88 1.7
select_random_points 0.34 0.67 2.0
select_random_ranges 0.39 0.7 1.8
table_scan 34.95 54.83 1.6
types_table_scan 75.82 144.97 1.9
reads_mean_multiplier 1.6
Write Tests MySQL Dolt Multiple
oltp_delete_insert 8.13 5.99 0.7
oltp_insert 3.82 2.97 0.8
oltp_read_write 8.58 11.87 1.4
oltp_update_index 3.89 3.02 0.8
oltp_update_non_index 3.89 2.97 0.8
oltp_write_only 5.37 6.09 1.1
types_delete_insert 7.7 6.43 0.8
writes_mean_multiplier 0.9
TPC-C TPS Tests MySQL Dolt Multiple
tpcc-scale-factor-1 98.44 39.11 2.5
tpcc_tps_multiplier 2.5
Overall Mean Multiple 1.67
Assets 10
Loading