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

April 12, 2021

Get future release notes emailed to you:

Thanks!

Downloads

Docker image

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

Enterprise edition changes

• The WITH avro_schema_prefix option for Avro changefeeds now sets schema.namespace #61734
• CockroachDB now fails fast when Change Data Capture writes are blocked. #62756

SQL language changes

Multi-region SQL changes

• Users can now use a multi-region ALTER DATABASE command if:

  • The user is an admin user
  • The user is the owner of the database.
  • The user has CREATE privileges on the database. #62528

• Availability zones are now ordered when using the SHOW REGIONS set of commands. #62619

General SQL changes

• Added the stub_catalog_tables session variable, which is enabled by default. If disabled, querying an unimplemented pg_catalog table will result in an error, as is the case in v20.2 and earlier. Otherwise, the query will simply return no rows. #62621

DB Console changes

• The Statements page now shows internal statements when the all filter option is selected. #62677

Bug fixes

• Fixed a bug that in rare circumstances could cause an implicitly committed (STAGING) transaction to be uncommitted if any unresolved intents were removed by a range clear (e.g. when cleaning up a dropped table). This bug fix is only effective with separated intents, which are disabled by default. #62376
• Added a DuplicateObject error code for when a user attempts to ADD REGION to a database where the region already exists. #62491
• Fixed an internal error that could occur during planning for queries involving tables with many columns and at least one inverted index. The error, "estimated distinct count must be non-zero", was caused by an invalid pointer access in the cardinality estimation code. This has now been fixed. #62545
• Writing files to userfile would sometimes result in an error claiming that the userfile table already exists. This is now fixed. #62544
• When adding/dropping regions from a multi-region database, the user must now have privileges on all regional-by-row tables as these are implicitly re-partitioned under the hood. #62612
• Fixed an internal error caused by comparing collation names that had different upper/lower case characters. #62637
• Fixed a bug whereby ENUM types which have large numbers of values would cause unexpected errors when attempting to read from tables with columns using that ENUM type. #62210
• Fixed a bug introduced in earlier v21.1 alpha releases which could cause panics when dropping indexes on tables partitioned by user-defined types. #62725
• Fixed a bug from earlier v21.1 alpha releases whereby dropping an index on a table partitioned by a user-defined type and then dropping the table and then dropping the type before the GC TTL for the index has expired could result in a crash. #62725

Performance improvements

• Improved the performance of the vectorized engine when scanning fewer than 1024 rows at a time. #62365
• Improved logic in determining the configuration for data to avoid expensive work when there are a large number of user-defined schemas. #62577
• Addressed a performance regression from a past change regarding read-triggered compactions. #62676

Contributors

This release includes 37 merged PRs by 23 authors.

Was this page helpful?

Yes No