title | toc | summary |
---|---|---|
What's New in beta-20161103 |
false |
Additions and changes in CockroachDB version beta-20161103. |
Get future release notes emailed to you:
<script>
hbspt.forms.create({
css: '',
cssClass: 'install-form',
portalId: '1753393',
formId: '39686297-81d2-45e7-a73f-55a596a8d5ff',
formInstanceId: 1,
target: '.install-form-1'
});
</script>
- Users (other than
root
) must now be created with theCREATE USER
statement orcockroach user set
command before they can be used for TLS certificate- or password-based authentication. #9794 - The
ambiguous result
error message introduced inbeta-20161027
is now simplyresult is ambiguous
since it may be returned outside of transactions. #10279
- Password-based authentication is now supported. Clients can authenticate with either a TLS certificate or a password. Documentation coming soon.#9794
- The
SHOW USERS
statement is now supported. #10088 - The
pg_catalog.pg_type
,pg_catalog.pg_database
,pg_catalog.pg_views
,pg_catalog.pg_proc
, andpg_catalog.pg_am
tables are now supported. #10209, #10284, #10276, #10217, #10363 - The
information_schema.statistics
andinformation_schema.views
tables are now supported. #10220, #10288 SHOW TABLES
now adds a(dropped)
suffix to tables that are being dropped. #10063SHOW CREATE VIEW
now only requires permissions on the view, not the underlying tables. #10270
- When entering a transaction in the built-in sql shell, the statements are not sent to the server until there is either a
COMMIT
,ROLLBACK
, or two blank lines. This minimizes the lifetime of the transaction and therefore the risk of conflicts. #10187
- Queries that span multiple ranges are now executed across those ranges in parallel. #9197
- Time series data (used in the admin UI) is now loaded in parallel. #10250
- Rebalancing now reaches an equilibrium faster. #10330
- Memory usage of SQL queries is now monitored, and queries that use too much will fail rather than exhaust the server's memory. #9259
- Fixed a problem with snapshot error handling that could cause the cluster to be unable to make progress after node failure.
- Computing the
log()
of a very large number no longer causes the server to hang. #10221 - Decimal numbers are now parsed correctly in
AS OF SYSTEM TIME
queries. #10242 concat_ws()
with no arguments no longer crashes the server. #10309- Fixed a bug when a command was executed after its client had disconnected. #10279
- Clarified and expanded the
transactions
overview documentation, and completed docs on transaction-specific statements: #672 - Added language-specific examples for
INSERT
statements withRETURNING
. #813 - Updated the SQL Feature Support page to reflect support for views (SQL standard) and interleaved tables (CockroachDB extensions).
This release includes 68 merged PRs by 24 authors. We would like to thank the following contributors from the CockroachDB community, including first-time contributors Johan Brandhorst and MaBo.
- Johan Brandhorst
- MaBo
- Yan Long
- songhao