We are excited to announce the release of Dolt 0.17.0!

Dolt now supports the main index statements, that is CREATE INDEX, DROP INDEX, and all ALTER TABLE commands involving an index. Some less common types of index types that are not supported are PARTIAL, UNIQUE, SPATIAL, and FULLTEXT. Finally, SHOW INDEX is not yet supported.

As usual, please file an issue if you find any bugs, or have a feature request.

Merged PRs

• 676: Db/tester fix
• 674: SELECT comparisons and BETWEEN now use indexes
  SELECT <, <=, >, >=, and BETWEEN all now use indexes. Previously, only = used indexes or primary keys, so this should be a pretty huge win.
• 673: Andy/baseball databank fix
  Baseball databank was breaking the previous migration because it has null values in primary keys
  (see table allstarfull)
• 671: Fix issue with renaming temp files across volumes
• 668: Added partial key lookups for indexes and primary keys
• 665: Zachmu/case insensitive
  Updated tests for new case-insensitivity improvements in go-mysql-server. Relies on dolthub/go-mysql-server#102, which is not on master yet.
• 664: hotfix
  not sure why Jenkins didn't catch these on #658 but it's fixed
• 663: Verify System Table Tag Constants
  Tags for Dolt system tables are defined with const definitions and need to be consistent across Dolt versions. Using iota within const definitions can lead to unexpected results:

  const (
  name = "Andy"
  mood = "ugh"
  a = iota + 1
  b
  c
  )
  func main() {
  fmt.Println(a)
  fmt.Println(b)
  fmt.Println(c)
  }
  

  3
  4
  5
  

  These unit tests lock these constants in place.
• 662: Updated version for release of version 0.16.4
• 103: Zachmu/user privileges
  Adds an empty user_privileges table to the information_schema database. This is necessary for the latest version of datagrip.
  Stacked on top of #102.
• 102: Zachmu/case sensitivity
  Better (but not perfect) case insensitivity for table, alias and column names. Better enforcement of unique table / alias names in queries.

Closed Issues

• 672: Installation script quietly fails