UPDATEstatements may now set columns which are part of the primary key. #6043
CHECKconstraints can now be defined when creating tables and will be enforced for
INSERTstatements (but not yet for
DECIMALvalues no longer lose precision. #6170
cockroach sqlshell, the special command
\!can now be used to execute a system command and display its output.
\|executes a system command and runs its output as a SQL statement. #5961
SHOW CREATE TABLE. #6158
INSERTstatements can now refer to tables by aliases defined with
RESTRICTkeywords in the
ALTER TABLE DROP COLUMN, and
ALTER TABLE DROP CONSTRAINTstatements. These keywords relate to features we have not yet implemented, so they do nothing, but this change improves compatibility with frameworks that like to send these keywords. #5957
This release includes 74 merged PRs by 21 authors. We would like to thank the following contributors from the CockroachDB community, especially first-time contributor Andrew NS Yeow.