Merged PRs

dolt

• 4545: Enable new clones to begin replicating on the primary
• 4539: Replace incorrect character.
  Replaces an incorrect ' character with the correct ` character.
  The current code results in broken docs html:
  
• 4528: Branch Control Pt. 5
  This is an aggregate of
  • #4507
  • #4508
  • #4509
  • #4510
    along with each PR's respective feedback.
• 4524: add file read progress info for dolt sql --file=<file.sql> command
  There will be percentage progress output printed for --file flag of dolt sql command. It can be used with or without --batch flag.
• 4512: Tests for unique index creation on keyless tables
  tests for: #4420
  companion pr: dolthub/go-mysql-server#1320
• 4505: dolt support for MULTILINESTRING
  Fix for: #3638
  Companion PR: dolthub/go-mysql-server#1323

go-mysql-server

• 1329: explain output includes FilteredTable
  We already print filtered table in the debug string for IndexedTableAccess, this adds it to regular explain and ResolvedTable.
• 1323: add support for MultiLineString pt. 3
  Part 4 of fix for: #3638
  TODO: rebase to main, left as a merge to james/mline2 for better readability
  Changes:
  • these functions now work with MultiLineString
  • ST_GEOMFROMGEOJSON
  • ST_ASGEOJSON
  • added engine tests
• 1322: add support for MultiLineString pt. 2
  Part 3 of fix for: #3638
  TODO: rebase to main, left as a merge to james/mline for better readability
  Changes:
  • small fix to polygon test
  • these functions now work with MultiLineString
  • ST_SWAP
  • ST_SRID
  • ST_DIMENSION
  • MULTILINESTRING
• 1321: add support for MultiLineString pt. 1
  Part 2 of fix for: #3638
  Changes:
  • small copy-pasta comment fixes
  • adding multilinestring type and structs
  • MultiLineString support for these sql functions
  • ST_MULTILINESTRINGFROMWKB
  • ST_MULTILINESTRINGFROMTEXT
  • ST_MLINESTRINGFROMWKB
  • ST_MLINESTRINGFROMTEXT
  • ST_GEOMFROMWKB
  • ST_ASWKB
  • ST_ASTEXT
• 1320: rewrite table on unique key creation
  Fix for: #4420
  In-memory tables don't support unique keys, so tests are in dolt:
  #4512
• 1311: internal/sockstate: Fix sockets ending up in blocking mode when we monitor them for disconnects.
  As documented in os, calling *os.File.Fd() will put the socket into blocking mode, makes SetDeadline methods stop working, etc. This syscall to SetNonblocking restores desired functionality.
  This was discovered when testing clustering control plane operations in Dolt, which rely on the timely ability to terminate all client connections by calling Close() on them.
  We were able to reproduce the issue on macOS by doing the same File() behavior there, despite not having an implementation to actually use the fd for external monitoring of the connection state. To keep as much behavioral parity going forward, I left the fd translation in, since we've observed that it can radically change behavior.

Closed Issues

• 4430: Feature request: add a progress bar to dolt sql < file.sql that shows the progress of a SQL load
• 4518: dolt_remotes system table not accessible when connecting with a branch string
• 4270: Diff shows rows that have no diffs when a column has been added in the past.
• 4211: Inserting large JSON object in a prepared statement causes panic
• 4420: Dolt allows me to create an unique index that violates uniqueness
• 1331: CreateTable: DEFAULT CHARACTER SET missing
• 945: Client hangs if go-mysql-server takes too long to return query results

Latency