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: https://github.com/dolthub/dolt/issues/8272
• 8314: Fix Integration Workflow This is Dolt's counterpart to the following PR:
  • https://github.com/dolthub/go-mysql-server/pull/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 https://github.com/dolthub/dolt/issues/8316
• 2650: conflict in EqualityRangeBuilder Fix bug in equality range builder where duplicate equality filters to one value would stomp each other. fixes: https://github.com/dolthub/dolt/issues/8317 dolt-side: https://github.com/dolthub/dolt/pull/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