DECIMAL
type will need to be deleted and created from scratch. Columns of this type were encoded incorrectly in older beta releases. (Again! We apologize for the inconvenience.) #5994transaction_timestamp_unique
has been removed in favor of the newcluster_logical_timestamp
function described below.ALTER TABLE
supports several new operations: ADD COLUMN
with a default value (#5759),ALTER COLUMN SET DEFAULT
, ALTER COLUMN DROP DEFAULT
, and ALTER COLUMN DROP NOT NULL
(#5947)TIMESTAMPTZ
type is now accepted as an alias for TIMESTAMP
for compatibility with PostgreSQL; ourTIMESTAMP
type already supports time zones in the same way as PostgreSQL’s TIMESTAMPTZ
. #5893STRING
type now accepts a length parameter (e.g., STRING(50)
), similar to CHAR
and VARCHAR
. #5918LIMIT
clause now accepts placeholders. #5977RETURNING
clause of INSERT
, DELETE
, and UPDATE
statements now accepts placeholders. #5934cockroach sql
tool via stdin
, a terminating semicolon is not required and instructions for interactive mode are no longer printed (similar to the existing behavior of -e
). #5988experimental_uuid_v4()
SQL function has been renamed to uuid_v4()
. The old name remains as a deprecated alias. #5886now
, current_timestamp
, statement_timestamp
,statement_timestamp
) now use the clock of the node that executed them instead of a timestamp derived from the internal hybrid logical clock. This means that these functions are less likely to produce duplicate values, but it is more likely for one transaction to see a timestamp that is less than a timestamp already seen in another transaction. Applications that require a globally monotonic timestamp-like value can use the new function cluster_logical_timestamp
instead. #5805/debug/metrics
exposes internal metric data in JSON format. #5894stderr
by default, only to the logs
subdirectory of the data directory. #5979This release includes 58 merged PRs by 18 authors. We would like to thank the following contributors from the CockroachDB community, especially first-time contributor Andrey Shinkevich.