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:
  • dolthub/go-mysql-server#2644
• 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