What's New in v21.1.0-beta.4

April 19, 2021

Get future release notes emailed to you:

Thanks!

Downloads

Docker image

$ docker pull cockroachdb/cockroach-unstable:v21.1.0-beta.4

General changes

• Removed experimental feature UNIQUE WITHOUT INDEX from the documentation. #63499

SQL language changes

• The pg_get_partkeydef builtin function is now implemented by always returning NULL. #63149
• CockroachDB now collects execution stats for all statements when seen for the first time. To disable this behavior, set the sql.txn_stats.sample_rate cluster setting to 0, which will disable all execution stats collection. #63325
• CockroachDB will now block the ability to set the initial PRIMARY REGION of a database if any multi-region fields on any zone configs in the database have been set. #63354
• CockroachDB now introduces a pgcode when attempting to DROP REGION when the region being dropped is the PRIMARY REGION. #63354
• Replaced the word "tuple" with its more user-friendly synonym "row" in vectorized stats outputs. #62956
• Changed BACKUP of interleaved tables to require the include_deprecated_interleaves option as interleaved table backups will not be able to be restored in future versions of CockroachDB. #63501

Operational changes

• RESTORE now can't restore BACKUPs made by newer versions of CockroachDB. #62398

DB Console changes

The following statements now render correctly as events in the DB Console #63141: - ALTER DATABASE ADD REGION - ALTER DATABASE SET PRIMARY REGION - ALTER DATABASE ... SURVIVE ... FAILURE - ALTER DATABASE DROP REGION - CREATE TYPE - ALTER TYPE - DROP TYPE

Bug fixes

• Fixed a bug present in earlier 21.1 versions where BACKUPs would produce an error when they should be able to backup the underlying data. #63095
• Dropping a foreign key that was added in the same transaction no longer triggers an internal error. This bug has been present since at least version 20.1. #62879
• Fixed a bug where an ALTER TABLE ... ADD COLUMN ... UNIQUE statement would cause an error if the table had a PARTITION ALL BY or REGIONAL BY ROW definition. #63189
• Fixed a bug in earlier 21.1 versions where CREATE TABLE LIKE would copy a VIRTUAL column from the source table as a STORED column in the destination table. #63172
• CockroachDB now returns an error when trying to perform a backup of a cluster that was taken on another tenant. #63223
• Fixed a bug where index backfill data may have been missed by BACKUP in incremental backups. #63221
• Fixed a bug where REGIONAL BY ROW zone configs were dropped before REGIONAL BY ROW changes are finalized. This caused a bug when the REGIONAL BY ROW transformation fail. #63274
• Fixed a case where implicitly partitioned columns (e.g. from REGIONAL BY ROW tables and hash-sharded indexes) previously showed as implicit = false when using SHOW INDEXES or querying information_schema.pg_indexes. #63275
• Fixed an error that could occur when performing an UPSERT on a REGIONAL BY ROW table with no secondary indexes or foreign keys. The error, 'missing "crdb_region" primary key column', has now been fixed. #63257
• Fixed a bug where tables that were created by CockroachDB 19.x or older that included foreign key constraints and were backed up with the revision_history option would be malformed when restored by a CockroachDB 20.x cluster if the RESTORE used the AS OF SYSTEM TIME option. #63267
• Fixed a bug in user-defined schemas where the dropping of any schema would prevent creation of schemas with the name of the database and would corrupt already existing schemas of that name. #63395
• Fixed a bug in previous CockroachDB 21.1 releases where CockroachDB would sometimes return the output in an incorrect order if a query containing hash-aggregation was executed via the vectorized execution engine and spilled to temporary storage. #63408
• Fixed a bug where incremental cluster backups may have missed data written to tables while they were OFFLINE. In practice this could have occurred if a RESTORE or IMPORT was running across incremental backups. #63304
• CockroachDB now includes more anonymized data from SQL statements in telemetry updates and crash reports. #63482
• Fixed a rare issue that caused replica divergence. If this occurred the divergence was reported by the replica consistency checker, typically within 24 hours of occurrence, and caused the nodes to terminate. #63473

Performance improvements

• Improved performance of reverting IMPORT INTO jobs that IMPORT INTO empty tables. #63220

Miscellaneous improvements

• Made the Kafka library used in changefeeds configurable using the kafka_sink_config option to enable latency versus throughput configurations. #63361
• Connected the changefeed memory monitor to the parent SQL monitor to ensure that changefeeds do not try to use more memory than is available to the SQL server. #63409

Contributors

This release includes 50 merged PRs by 20 authors.

Was this page helpful?

Yes No