Merged PRs

dolt

go-mysql-server

• 2625: Bug fix: the timestamp function should convert to a datetime type
  MySQL's timestamp function, despite its name, actually returns a datetime type and not a timestamp type.
  MySQL example:

  mysql -uroot --protocol TCP -e "select timestamp('1000-01-01 00:00:00');" --column-type-info
  Field   1:  `timestamp('1000-01-01 00:00:00')`
  Catalog:    `def`
  Database:   ``
  Table:      ``
  Org_table:  ``
  Type:       DATETIME
  Collation:  binary (63)
  Length:     19
  Max_length: 19
  Decimals:   0
  Flags:      BINARY
  +----------------------------------+
  | timestamp('1000-01-01 00:00:00') |
  +----------------------------------+
  | 1000-01-01 00:00:00              |
  +----------------------------------+

  Note: We still need to add support for the second, optional parameter to timestamp().
  Customer issue: #8236
• 2624: Use ctx.Done() as a faster check for ctx.Err()
  The err call is noticeable for queries that read a lot of rows.
• 2623: Fix anti-join correctess bug
  We had some strange logic for accepting a join anti-match, ripped it out and everything seems to be working correctly now.
• 2621: implement icu_version function
  MySQL Docs: https://dev.mysql.com/doc/refman/8.4/en/information-functions.html#function_icu-version
• 2619: Assume text index comparisons are exact
  We currently do not eliminate filters of the form column(VARCHAR) = text literal (longtext) when pushing filters into index lookups. The safety check is necessary at least for datetimes, spatial/fulltext and partial TEXT indexes. It's not clear whether it is necessary for full varchar indexes.
  dolt side seems OK: #8218

Closed Issues