Merged PRs

dolt

• 4189: Deprecate git-dolt and git-dolt-smudge
  Versioning a Dolt repository in a Git repository does not make much sense in our current product conceit. These products were lacking features and unmaintained. So, we're deprecating them.
• 4181: Migrate TEXT, BLOB index keys by converting them VARCHAR, VARBINARY
• 4163: adding missing test cases for prepared tests
  Companion PR:
  • dolthub/go-mysql-server#1207
    Adds skipped tests for Queries that don't yet work Prepared

go-mysql-server

• 1213: Show all currently-implemented charsets with default collations
• 1211: fix str_to_date to returns time or date or datetime type results
  STR_TO_DATE() returns result type depending on Date given in the query. If only date parts like year, month and/or day was defined in Date argument, then the result is only Date type without time parts. If Date defined is date with time, then Datetime type is returned.
  Currently, STR_TO_DATE allows zero-date.
• 1207: fix some filters being dropped from history tables
  Changes:
  • run pruneTables in prePreparedSelector, to transfer projections correctly
  • added Filters() getter into sql.FilteredTables interface
  • transferProjections also copies over table filters
    Test PR:
  • #4163
• 1183: index lookup refactor
  New implementation divides lookup management into analysis and exec components. During analysis, *plan.IndexedTableAccess embeds an IndexedTable. The IndexLookup itself is static, dynamic lookups will be passed multiple lookup objects at exec time.

  type IndexLookup struct {
  fmt.Stringer
  Index  Index
  Ranges RangeCollection
  }
  type IndexAddressable interface {
  // AsIndexedAccess returns a table that can perform scans constrained to an IndexLookup
  AsIndexedAccess(Index) IndexedTable
  // GetIndexes returns an array of this table's Indexes
  GetIndexes(ctx *Context) ([]Index, error)
  }
  type IndexAddressableTable interface {
  Table
  IndexAddressable
  }
  type IndexedTable interface {
  Table
  // LookupPartitions returns partitions scanned by the given IndexLookup
  LookupPartitions(*Context, IndexLookup) (PartitionIter, error)
  }

  Minimal changes to DriverIndexedLookup and ForeignKeyUpdater to accommodate changes.

Closed Issues

• 4128: STR_TO_DATE() returns DATETIME even when just DATE is expected
• 3086: support HEAD~ ref syntax for connection string / USE statements
• 4149: Dolt commands output success logs to stderr
• 4178: Support SHOW CHARACTER SET
• 4025: [Feature Request] use a recursive cte result in an update
• 4126: Support for RANK() and DENSE_RANK() window functions
• 2163: Support JSON_TABLE() function
• 2170: Missing indexes when join condition uses extra conditions
• 1613: Git-Dolt: Multiple invocations of git dolt install should not re-append to files
• 1612: Git-Dolt: git dolt update should use the dolt HEAD revision by default
• 163: dolt blame should provide an option to ignore schema changes in the history that did not affect the final row state.
• 427: Dolt commit doesn't work with sublime as $EDITOR
• 991: Excel Query Broken
• 1028: [Bug Report] Segfault When Cloning Repo From Self-Compiled Dolt on Raspberry Pi
• 1235: panic: star is just a placeholder node, but Eval was called - 0.22.8
• 1846: Bit type doesn't render on Tableplus
• 2123: dolt add . regression related to license file
• 2039: diffs displayed incorrectly
• 2099: SQL column names should not be case sensitive
• 2209: Row History command fails on db
• 2246: dolt checkout will stomp uncommitted changes on another branch
• 2668: Autocommit blocks access to conflict resolution table
• 2905: Investigate Statement Level atomicity for the import path
• 2976: Support DEFAULT CHARACTER SET in CREATE TABLE statements
• 3049: Support the following SHOW statements
• 3088: Inserting into foreign key table causes crash
• 3156: Retry failed clone / pull operations using already cached information
• 3162: Remove db.Rebase() from dsess.StartTransaction
• 3212: dolt sql -q gives different results from dolt sql --file
• 3292: Color bug is back after latest release
• 3227: Dolt sql csv output ignores filename case
• 3373: Globally distinct auto increment keys in server
• 3416: Confused by renaming to a previously used name.
• 3795: CLI commands should be equivalent of starting a new session, running equivalent stored procedure, and closing session
• 3940: dolt panic when using cli from dbs directory
• 1144: tagname containing dots not supported
• 4141: Window function ORDER BY should be optional when frame specification doesn't require it
• 1153: proposal: Refactor Indexed Table Access