Merged PRs

dolt

• 4229: go/doltcore/sqle/globalstate: Reset AUTO_INCREMENT sequence to 1 on table drop
• 4206: fix wrong error variable used

go-mysql-server

• 1227: Fixed collation error message, added more collations
  Fixes #4236, in addition to adding two new collations:
  • utf8mb3_unicode_ci
  • utf8mb4_unicode_520_ci
• 1225: Hoist CTEs above Filter, Limit, OrderBy, and Having
• 1224: SET NAMES collation fix, results have proper charset
  Fixes two issues. SET NAMES would cause all statements that feature a COLLATE expression to error if the character set and collation did not match, however such a comparison only makes sense for string literals (at parse time). This has been fixed, as the parse-time check only occurs for literals, and checks that require analysis (such as table columns) now occur at the appropriate time. In addition, the system variable character_set_results was not used when returning string results, resulting in unexpected behavior, which has also been fixed.
• 1223: fix infinite recursion during cte self-reference
  Changes:
  • don't resolve subqueries where there are CTEs of the same name; transformations are bottom up, so they've been resolved at least once already
    Fix for:
  • #4173

Closed Issues

• 3142: Dolt pull using 90% of memory
• 3111: Start supporting the mysql database
• 3087: unknown push error When pushing a branch with a 20,000 commits to DoltHub
• 3064: trying to drop a column used in a foreign key gives a bad error message
• 3051: CREATE TABLE with RESERVED KEYWORD status breaks
• 2820: Using --continue flag for dolt table import -u doesn't add any rows
• 2808: Support minio as remote storage
• 2756: set root password in SQL session without removing administrator password
• 2723: DOLT_CHECKOUT('-b', 'newbranch) should take working set changes to new branch
• 2673: Reorder of columns in UNIQUE INDEX when re-create table
• 2637: Dolt SQL shell can't handle semicolons in comments
• 2600: dolt diff does not show schema changes when modifying constraints
• 2594: Dropping and readding constraints generates schema diff
• 2591: dolt constraints should be exposed in the top level dolt help text
• 4173: Query crashes SQL server
• 4236: Bad collation Error Message
• 4222: Can't build dolt with LTO
• 2398: panic for dolt_diff tables when in detached head mode
• 4103: dolt ls --verbose panics in the new format
• 4123: count(*) in new format 3X slower for large table
• 2359: CLI supports param for different working directory
• 2335: Identical schema alterations results in two different columns with same tag error on merge
• 2328: dolt pull -f fails when dolt fetch -f works && dolt branch main remotes/origin/main -f works
• 2315: DOLT_MERGE should return detailed error
• 2311: Tableplus can't detect Table
• 2306: daemon mode
• 2305: confusing error message when selecting from conflict tables with @@autocommit = true
• 2304: Reverse order between from_commit and to_commit of "dolt_commit_diff_$table" will throw out exception and code stack
• 2296: Prevent branch deletion when another client has a session open on it
• 2292: [Feature Request] Progress Indicators for GC
• 2286: Dolt errors out on table definitions that use a UNIQUE KEY and KEY on the same column
• 2283: [Feature Request] Progress indicator for merges
• 2275: golang go-sql-driver/mysql does't work with Multiple HEADs
• 2260: Can't connect with Visual Studio MySQL Connector
• 2181: dolt table import -u <table> slows down almost 20x after only five imports of ~20k rows
• 2118: dolt import table Foreign Key NOT NULL violation error is not helpful
• 2070: Dolt doesn't respect primary key for sort order
• 2018: Deleting branch does not delete associated working set
• 1708: Feature request: show status during dolt sql edits
• 1561: Django multi-table inheritance: duplicate primary key error on edit
• 1318: When checking out via SQL, views don't automatically update
• 1010: Show progress on dolt schema import
• 655: Dolt SQL vs MySQL client: MySQL client right justifies number columns
• 407: Weird group by behavior
• 1096: go 1.17 support