Release Notes for v1.1-alpha.20170803

August 3, 2017

Backwards-Incompatible Changes

  • Table and column names in double quotes are now case-sensitive (same as in PostgreSQL). #16884
  • The SHOW SESSION TRACE statement is now SHOW TRACE FOR SESSION. The SET/SHOW TRACE statements are now SET/SHOW TRACING. #17033

Build Changes

  • It is now possible to build CockroachDB Enterprise Edition for Windows. #17035
  • make help in a source checkout now prints documentation for the available build targets. #17056
  • CockroachDB now uses gRPC version 1.5.0. #17166

SQL Language Changes

  • New statement CANCEL QUERY can be used to cancel a query in progress. #17003
  • A limited form of one-dimensional ARRAY columns are now supported. #16764 #17231
  • OUTER JOIN statements now use the distributed SQL execution engine. #17017
  • Some new syntactic forms for table references with aliases are now supported. #17031
  • Strings within arrays are now formatted consistently with PostgreSQL. #17069
  • Transactions can now see their own changes to table schemas. #16988

Command-Line Interface Changes

  • A new cockroach init command can be used in place of starting one node without the --join flag. #16371

Bug Fixes

  • The first statement (or batch of statements) in a transaction can no longer return "retry transaction" errors; the server will retry the statement automatically. #16874
  • Fixed a race condition that could lead to serializability violations when requests race with a lease transfer. #17109
  • Fixed a potential raft election issue during range splits. #17051
  • Fixed a use-after-close for parallelized statements. #17126

Performance Improvements

  • The TRUNCATE statement now works by renaming the table and asynchronously garbage collecting the data, so it is much faster but no longer transactional (similar to PostgreSQL). #17045
  • Fixed a memory leak in the HTTP layer. #17080
  • Raft log truncations are now more efficient. #16993
  • Fixed a regression that caused a node to talk to itself over the network. #17196
  • Improved networking efficiency when tracing is disabled. #17185
  • Reduced redundant trace messages. #17182
  • Added a fast path for committing read-only transactions. #17128
  • Memory footprints of various internal structures have been reduced. #17089 #17106 #17138 #17137 #17152
  • Table descriptors are now passed by reference instead of value. #17100

Doc Updates

  • New RFCs: web session authentication (#16829), buffering hash router (#17105
  • Corrected information about how TIMESTAMP WITH TIME ZONE works. Previous versions incorrectly said that they stored timestamps; they do not. Instead they simply display timestamps in the client's session time zone.
  • CockroachDB in Comparison was redesigned.

Enterprise Edition Changes

  • Replayed commands during a RESTORE are now more efficient. #17079
  • Backup jobs now checkpoint their progress every minutes. #17070
  • Streamlined concurrency of RESTORE operations, removing most tunable constants. #17163
  • RESTORE now rate-limits its disk I/O, reducing its impact on other traffic and improving performance on cloud platforms that throttle disk access. #17239
  • The enterprise.enabled setting has been removed. #17224