Release Notes for CockroachDB v2.0.1 and v1.1.8


(Swati Kumar) #1

April 23, 2018

Happy Monday!

This week, we had two releases - CockroachDB v2.0.1 and CockroachDB v1.1.8.
Upgrade your version of CockroachDB here and let us know what you think!
 
Cheers,

The Cockroach Labs Team


CockroachDB v2.0.1

General Changes

  • The new server.clock.persist_upper_bound_interval cluster setting can be used to guarantees monotonic wall time across server restarts. #24624
  • The new server.clock.forward_jump_check_enabled cluster setting can be used to cause nodes to panic on clock jumps. #24606
  • Prevented execution errors reporting a missing libtinfo.so.5 on Linux systems. #24531

Enterprise Edition Changes

  • It is now possible to RESTORE views when using the into_db option. #24590
  • The new jobs.registry.leniency cluster setting can be used to allow long-running IMPORT jobs to survive temporary node saturation. #24505
  • Relaxed the limitation on using BACKUP in a mixed version cluster. #24515

SQL Language Changes

  • Improved the error message returned on object creation when no current database is set or only invalid schemas are in the search_path. #24812
  • The current_schema() and current_schemas() built-in functions now only consider valid schemas, like PostgreSQL does. #24758
  • The experimental SQL features SHOW TESTING_RANGES and ALTER ... TESTING_RELOCATE have been renamed SHOW EXPERIMENTAL_RANGES and ALTER ... EXPERIMENTAL_RELOCATE. #24699
  • ROLE, VIRTUAL, and WORK are no longer reserved keywords and can again be used as unrestricted names. #24665 #24549

Command-Line Changes

  • When cockroach gen haproxy is run, if an haproxy.cfg file already exists in the current directory, it now gets fully overwritten instead of potentially resulting in an unusable config. #24336

Bug Fixes

  • Fixed a bug when using fractional units (e.g., 0.5GiB) for the --cache and --sql-max-memory flags of cockroach start. #24388
  • Fixed the handling of role membership lookups within transactions. #24334
  • Fixed a bug causing some lookup join queries to report incorrect type errors. #24825
  • ALTER INDEX ... RENAME can now be used on the primary index. #24777
  • Fixed a panic involving inverted index queries using the -> operator. #24596
  • Fix a panic involving inverted index queries over NULL. #24566
  • Fixed a bug preventing inverted index queries that have a root with a single entry or element but multiple children overall. #24376
  • JSONB values can now be cast to STRING values. #24553
  • Prevented executing distributed SQL operations on draining nodes. #23916
  • Fixed a panic caused by a WHERE condition that requires a column to equal a specific value and at the same time equal another column. #24517
  • Fixed a panic caused by passing a Name type to has_database_privilege(). #24270
  • Fixed a bug causing index backfills to fail in a loop after exceeding the GC TTL of their source table. #24427
  • Fixed a panic caused by null config zones in diagnostics reporting. #24526

Performance Improvements

  • Some SELECTs with limits no longer require a second low-level scan, resulting in much faster execution. #24796

Contributors

This release includes 39 merged PRs by 16 authors. Special thanks to Vijay Karthik from the CockroachDB community.


CockroachDB v1.1.8

Bug Fixes

  • Fixed potential cluster unavailability after Raft logs grow too large. #24889
  • ALTER INDEX ... RENAME can now be used on the primary index. #24779
  • Fixed "dangling rows" left over by transactions including both a schema change and ROLLBACK TO SAVEPOINT. #24888

Contributors

This release includes 6 merged PRs by 4 authors.