INSERT
statement now accepts an ON CONFLICT
clause, for a more flexible alternative to UPSERT
.#6591EXPLAIN (TYPES)
subcommand prints information about the types of expressions in a statement.#6482BOOL_AND()
and BOOL_OR()
. #6535SUM(INT)
and AVG(INT)
now return DECIMAL
instead of INT
and FLOAT
respectively. #6532--raft-tick-interval
allows the raft heartbeat frequency to be changed in high-latency deployments. #6615TIMESTAMP
values can now be cast to type STRING
. #6605CREATE DATABASE
statement now accepts an ENCODING
option for compatibility with PostgreSQL, although UTF8
is the only supported encoding. #6614INSERT
statement inserts multiple values for the same primary key. #6564SNAPSHOT
isolation used the internalDeleteRange
operation. #6548transport: http2Server received 4294965918-bytes
. #6567INTERVAL
from a TIMESTAMP WITH TIME ZONE
returns a TIMESTAMP WITH TIME ZONE
instead of one without a time zone. #6540CREATE TABLE
, ALTER TABLE
, and DROP INDEX
now do more validation of their arguments. #6492This release includes 87 merged PRs by 18 authors. We would like to thank the following contributor from the CockroachDB community: