What's New in v2.1.2

December 10, 2018

Get future release notes emailed to you:

Thanks!

Downloads

Docker image

$ docker pull cockroachdb/cockroach:v2.1.2

Backward-incompatible changes

• The CHANGEFEED experimental-avro option has been renamed experimental_avro. #32235

SQL language changes

• The IMPORT format (file) syntax is deprecated in favor of IMPORT format file. Similarly, IMPORT TABLE ... FROM format (file) is deprecated in favor of IMPORT TABLE ... FROM format file. #31301
• CockroachDB now accepts ordinary string values for placeholders of type BPCHAR, for compatibility with PostgreSQL clients that use them. #32661

Command-line changes

• The cockroach workload command now includes the kv load generator. #32756

Bug fixes

• Fixed a panic on UPDATE ... RETURNING * during a schema change. #32591
• Fixed a panic on UPSERT in the middle of a schema change adding a non-nullable column. #32730
• Fixed a bug that prevents adding computed columns with the NOT NULL constraint. #32730
• Fixed a deadlock when using ALTER TABLE ... VALIDATE CONSTRAINT in a transaction with a schema change. #32850
• Prevented a performance degradation related to overly aggressive Raft log truncations that could occur during RESTORE or IMPORT operations.
• Prevented a stall in the processing of Raft snapshots when many snapshots are requested at the same time. #32414
• CHANGEFEEDs now escape Kafka topic names, when necessary. #32235
• CHANGEFEEDs now spend dramatically less time flushing Kafka writes. #32235
• CHANGEFEEDs with the experimental_avro option now work with column WIDTHs and PRECISIONs. #32484
• Fixed a bug where Raft proposals could get stuck if forwarded to a leader who could not itself append a new entry to its log. #32600
• Fixed a bug where calling CREATE STATISTICS on a large table could cause the server to crash due to running out of memory. #32635
• Fixed a bug that could cause data loss bug when a disk becomes temporarily full. #32633
• CockroachDB now reports an unimplemented error when a WHERE clause is used after INSERT ... ON CONFLICT. #32558
• CockroachDB now properly handles foreign key cascading actions SET DEFAULT and SET NULL in SHOW CREATE and cockroach dump. #32630
• Fixed a crash that could occur during or after a data import on Windows. #32666
• Lookup joins now properly preserve ordering for outer joins. Previously, under specific conditions, LEFT JOIN queries could produce results that did not respect the ORDER BY clause. #32678
• CockroachDB once again enables admin users, including root, to list all user sessions besides their own. #32709
• CockroachDB now properly rejects queries that use an invalid function (e.g., an aggregation) in the SET clause of an UPDATE statement. #32506
• Dates no longer have a time component in their text encoding over the wire. #32661
• Corrected binary decimal encoding for NaN. #32661
• Prevented a panic when encountering an internal error related to invalid entries in the output of SHOW SESSIONS. #32742
• Prevented a panic when running certain subqueries that get planned in a distributed fashion. #32670
• CHANGEFEEDs emitting into Kafka more quickly notice new partitions. #32757
• CockroachDB now properly records statistics for sessions where the value of application_name is given by the client during initialization instead of SET. #32755
• CockroachDB now properly evaluates CHECK constraints after a row conflict in INSERT ... ON CONFLICT when the CHECK constraint depends on a column not assigned by DO UPDATE SET. #32780
• The cockroach workload run subcommand no longer applies to data-only generators. #32827
• Fixed a bug where metadata about contended keys was inadvertently ignored, in rare cases allowing for a failure in transaction cycle detection and transaction deadlocks. #32853

Performance improvements

• Changed the default value for the kv.transaction.write_pipelining_max_batch_size cluster setting to 128. This speeds up bulk write operations. #32621

Doc updates

• Documented the cockroach workload command, which provides built-in load generators for simulating different types of client workloads, and updated various tutorials to use these workloads. #4087
• Expanded the cockroach demo documentation to explain the use of built-in datasets. #4087
• Added a secure version of the Performance Tuning tutorial. #4123
• Clarified that primary key columns cannot be stored with a secondary index. #4098
  
• Clarified when to use DELETE vs. TRUNCATE. #4094
• Added important considerations when setting up clock synchronization.
• Clarified the documentation on automatic transaction retries. #4044

Contributors

This release includes 41 merged PRs by 15 authors.

Was this helpful?