New Features

Hibernate 6 generated JOIN group syntax that wraps join predicates in parentheses was not supported in NuoDB. For example, Hibernate 6 generated SQL query such as, SELECT * FROM a JOIN (b JOIN c on x) on y, is now supported.

For more information, see Execution Plan Operators.

For more information, see Execution Plan Operators and Supported Spill to Disk Operations.

See the example on Connection Properties.

SQL queries that include variables are now recompiled to generate a more optimized execution plan, resulting in better performance and faster execution times.

For more information, see SELECT and RIGHT OUTER Join Operations.

SQL queries that include a variable in the LIKE operator are now considered for reoptimization by the v3 optimizer.

The optimizer will consider more 'Bitmap intersections' than before, providing additional opportunities to find an optimal access path. In particular, if a specific index is chosen to satisfy a property such as a join predicate or ordering, it will now check if that index can be further improved by intersecting it with additional indices.

For more information, see Setting nuoadmin.conf Properties.

The EXPLAIN (ANALYZE_GRAPH {ON|OFF}) option displays the Graphviz representation of the explain plan. Use any Graphviz viewer to produce a graphical representation of the explain plan to aid in debugging and troubleshooting complex query plans.

For more information, see EXPLAIN.

When executing a SQL query that includes a comparison operation of a string or a timestamp to a date literal, a performance optimization has been added by converting the operand opposite the date literal to a date.

For more information, see Using Optimizer Hints.

For more information, see WITH.

For more information, see Execution Plan Operators.

For more information on Optimizer v3, see Optimizer v3.

To change the default optimizer setting for the current connection, use the queryoptimizer connection property. To change the default optimizer setting for the Transaction Engine (TE), use the optimizer-version database option.

For more information, see Execution Plan Operators.

SQL runtime performance has been improved in higher network latency environments or if a connection runs thousands or millions of short-running SQL statements when using the JDBC driver. For more information, see NuoDB JDBC Driver.

The SQL queries SELECT * FROM SYSTEM.CONNECTIONS and SELECT * FROM SYSTEM.LOCALCONNECTIONS now return the SQL engine and optimizer type in the SQLENGINE field. For more information, see CONNECTIONS and LOCALCONNECTIONS.

For more information, see LASTSTATEMENT.

Clients with non-root certificates can now be restricted using the authorizedDomains property. For more information, see Host Properties (nuoadmin.conf).

To check if a database is ready to accept client connections, use the nuocmd check sql-connection subcommand. For more information, see nuocmd check sql-connection.

During a DELETE, INSERT, REPLACE, or UPDATE operation on a table, if the format of the newly updated or created record does not match the format of the database table, an error is reported. To correct the format issue, use the new ALTER TABLE REBUILD FORMAT command. For more information, see ALTER TABLE.

To interpret parameters in a LIKE expression as escape characters, use the ESCAPE keyword and specify the parameter.
For examples, see Examples using LIKE with the ESCAPE clause.

For more information, see System Requirements.

For more information, see System Requirements.

The modified KAA consensus override logic now ensures that when APs are scaled up, they will rejoin the domain without a Raft state through the existing Raft leader to prevent any Raft state divergence.

In cases such as in EXPLAIN plan or error messages, the values of data type Date and Time appearing in the display output are now enclosed in single quotes ('). This makes it easy to copy the statement and execute it on a NuoDB database without editing.

When requesting a database hot copy, NuoDB Admin (nuoadmin) will verify that all database SGs are included in the archive selection, by default. To skip the verification and create a backup that includes partial SGs, use the --partial-storage-groups flag in nuocmd hotcopy database and nuocmd backup database. For more information, see Redundant Hot Copy with Storage Groups, nuocmd hotcopy database, and nuocmd backup database.

For more information, see NuoDB Node.js Driver.

The release build timestamp is now available as the builddate field in $NUODB_HOME/etc/Version.json. For more information, see Environment Variables.

The following new properties and parameter are added:

The logs displayed on stdout using kubectl logs <AP_pod_name> or docker logs <AP_container_name> can now be configured using logging.consoleLogLevels, without affecting log entries in nuoadmin.log. For more information, see Host Properties (nuoadmin.conf).

For more information, see Drivers in the NuoDB Client Package and NuoDB Hibernate Driver.