Cookies op Tweakers

Tweakers maakt gebruik van cookies, onder andere om de website te analyseren, het gebruiksgemak te vergroten en advertenties te tonen. Door gebruik te maken van deze website, of door op 'Ga verder' te klikken, geef je toestemming voor het gebruik van cookies. Wil je meer informatie over cookies en hoe ze worden gebruikt, bekijk dan ons cookiebeleid.

Meer informatie

Software-update: CockroachDB 2.1.1

Het team achter CockroachDB heeft versie 2.1.1 uitgebracht. Dit is een opensourcedatabase die uitermate geschikt is voor cloudomgevingen en die verschillende opties voor het opvangen van problemen biedt, dankzij de verspreide opzet. Voor meer informatie verwijzen we naar deze pagina, waar de meest gestelde vragen worden beantwoord. De lijst met veranderingen ziet er als volgt uit:

What's New in v2.1.1

SQL language changes
  • Renamed the first column name returned by SHOW STATISTICS to statistics_name. #32045
  • CockroachDB now de-correlates and successfully executes many queries containing correlated EXISTS subqueries. Previously, these queries caused a de-correlation error. #32026
  • If diagnostics reporting is enabled, attempts to use CREATE/DROP SCHEMA, DEFERRABLE, CREATE TABLE (LIKE ...), CREATE TABLE ... WITH, and the "fetch limit" parameter (e.g., via JDBC) will now be collected as telemetry to gauge demand for these currently unsupported features. Also, the name of SQL built-in functions will be collected upon evaluation errors. #31638
Bug fixes
  • Fixed a small memory leak when running distributed queries. #31759
  • The confkey column of pg_catalog.pg_constraint no longer includes columns that were not involved in the foreign key reference. #31895
  • The cost-based optimizer no longer chooses the wrong index for a scan because of incorrect selectivity estimation. #32011
  • Fixed a bug that caused transactions to unnecessarily return a "too large" error. #31821
  • Fixed rare deadlocks during IMPORT, RESTORE, and BACKUP. #32016
  • Fixed a panic caused by incorrectly encoded Azure credentials. #32016
  • Fixed a bug in the cost-based optimizer that sometimes prevented passing ordering requirements through aggregations. #32089
  • Fixed a bug that sometimes caused invalid results or an "incorrectly ordered stream" error with streaming aggregations. #32097
  • Fixed a bug that caused some queries with DISTINCT ON and ORDER BY with descending columns to return an error incorrectly. #32175
  • Fixed a bug that caused queries with GROUP BY or DISTINCT ON to return incorrect results or an "incorrectly ordered stream" error. Also improved performance of some aggregations by utilizing streaming aggregation in more cases. #32175
  • Fixed a panic caused by an incorrect assumption in the SQL optimizer code that ROWS FROM clauses contain only functions. #32168
  • Fix an error returned by cockroach node status after a new node is added to the cluster at a previous node's address. #32198
  • Fixed a mismatch between lookup join planning and execution, which could cause queries to fail with the error "X lookup columns specified, expecting at most Y". #31896
  • Fixed a bug that caused transactions to appear partially committed. CockroachDB was sometimes claiming to have failed to commit a transaction when some (or all) of its writes were actually persisted. #32220
  • Prevented long stalls that can occur in contended transactions. #32217
  • Non-superusers can no longer see other users' sessions and queries via the ListSessions and ListLocalSessions status server API methods. #32284
  • The graphite metrics sender now collects and sends only the latest data point instead of all data points since startup. #31888
Performance improvements
  • Improved the performance of AS OF SYSTEM TIME queries by letting them use the table descriptor cache. #31756
  • The cost-based optimizer can now determine more keys in certain cases involving unique indexes, potentially resulting in better plans. #32044
  • Within a transaction, when performing a schema change after the table descriptor has been modified, accessing the descriptor should be faster. #31756
Doc updates
  • Corrected the flow control logic of the transaction code sample in the Build a Java App with CockroachDB tutorial. #4047
  • Expanded the Running in a DaemonSet instruction to cover both insecure and secure deployments. #4037
  • Made it easier to find and link to specific installation methods, and updated the Homebrew instructions to note potential conflicts in cases where CockroachDB was previously installed using a different method. #4032, #4036
  • Updated the IMPORT documentation to cover importing CockroachDB dump files. #4029
Versienummer 2.1.1
Releasestatus Final
Besturingssystemen Windows 7, Linux, macOS, Windows Server 2012, Windows 8, Windows 10, Windows Server 2016
Website Cockroach Labs
Download https://www.cockroachlabs.com/docs/releases/v2.1.1.html
Licentietype Voorwaarden (GNU/BSD/etc.)

Door Japke Rosink

Meukposter

20-11-2018 • 15:48

0 Linkedin Google+

Bron: Cockroach Labs

Reacties


Er zijn nog geen reacties geplaatst

Op dit item kan niet meer gereageerd worden.


Apple iPhone 11 Nintendo Switch Lite LG OLED C9 Google Pixel 4 FIFA 20 Samsung Galaxy S10 Sony PlayStation 5 Elektrische auto

'14 '15 '16 '17 2018

Tweakers vormt samen met Hardware Info, AutoTrack, Gaspedaal.nl, Nationale Vacaturebank, Intermediair en Independer DPG Online Services B.V.
Alle rechten voorbehouden © 1998 - 2019 Hosting door True