title	toc	summary
What's New in v1.2-alpha.20171211	false	Additions and changes in CockroachDB version v1.2-alpha.20171211

Dec 11, 2017

Get future release notes emailed to you:

Alpha and beta releases are now published as Docker images under the name cockroachdb/cockroach-unstable. #20331

The protocol statement tag for CREATE TABLE ... AS ... is now SELECT, like in PostgreSQL. #20268
OIDs can now be compared with inequality operators. #20367
The CANCEL JOB statement now supports canceling IMPORT jobs. #20343
PAUSE JOB/RESUME JOB/CANCEL JOB statements can now be used within SQL transactions. #20185
Added a cache for the internal system.table_statistics table. #20212
The intervalstyle session variable is now supported for PostgreSQL compatibility. #20274
The SHOW [KV] TRACE statement now properly extracts file/line number information when analyzing traces produced in debug mode. Also, the new SHOW COMPACT [KV] TRACE statement provides a more compact view on the same data. #20093
Some queries using IS NOT NULL conditions are now better optimized. #20436
Views now support LIMIT and ORDER BY. #20246

Reduced temporary disk space usage for the cockroach debug compact command. #20460
The cockroach node status and cockroach node ls commands now support a timeout. #20308

The Admin UI now sets the Last-Modified header when serving assets to permit browser caching. This improves page load times, especially on slow connections #20429.

Removed the possibility for OOM errors during distributed IMPORT from csv. #20506
Fixed a crash triggered by some corner-case queries containing ORDER BY. #20489
Added missing Distributed SQL flows to the exported sql.distsql.flows.active and sql.distsql.flows.total metrics and the "Active Flows for Distributed SQL Queries" admin UI graph. #20503
Fixed an issue with stale buffer data when using the binary format for ARRAY values. #20461
The cockroach sql shell now better reports the number of rows inserted by a CREATE TABLE ... AS ... statement. Note, however, that the result are still formatted incorrectly if the CREATE TABLE ... AS ... statement creates zero rows in the new table. #20268
Self-referencing tables can now reference a non-primary index without manually adding an index on the referencing column. #20325
Fixed an issue where spans for descending indexes were displaying incorrectly and updated NOT NULL tokens from # to !NULL. #20318
Fixed BACKUP jobs to correctly resume in all conditions. #20185
Fix various race conditions with jobs. #20185
It is no longer possible to use conflicting AS OF SYSTEM TIME clauses in different parts of a query. #20267
Fixed a panic caused by dependency cycles with cockroach dump. #20255
Prevented context cancellation during lease acquisition from leaking to coalesced requests. #20424

Improved handling of IS NULL conditions. #20366
Improved p99 latencies for garbage collection of previous versions of a key, when there are many versions. #20373
Smoothed out disk usage under very write heavy workloads by syncing to disk more frequently. #20352
Improved garbage collection of very large transactions and large volumes of abandoned write intents. #20396
Improved table scans and seeks on interleaved parent tables by skipping interleaved children rows at the end of a scan. #20235
Replaced the interval tree structure in TimestampCache with arena-backed concurrent skiplist. This reduces global locking and garbage collection pressure, improving average and tail latencies. #20300

Added an introduction to CockroachDB video. #2234
Clarified that we have tested the PostgreSQL-compatible drivers and ORMs featured in our documentation enough to claim beta-level support. This means that applications using advanced or obscure features of a driver or ORM may encounter incompatibilities. If you encounter problems, please open an issue with details to help us make progress toward full support. #2235

Provide feedback