Known Issues

This section provides a summary of issues identified at the release of NuoDB 3.2. Where known issues have been reported, the associated Zendesk reference number is displayed. For example, (4706).

Issue description Workaround

A SELECT statement, which fetches a BLOB column type, returns only the decimal value for each character in the BLOB. (4706)

None.
NuoDB converts string literals to UTC timestamps (or DateTime types) and ignores timezone information. Provide timestamps and date-time values in the absolute (UTC timezone) value.
There are issues associated with creating an index on a table with concurrent writes to the same table. Ensure that the CREATE INDEX statement and concurrent writes are sent to the same Transaction Engine (TE). Alternatively, use the CREATE INDEX statement during a period of low activity or during a maintenance window.

The type declarations TIME (precision) and TIMESTAMP (precision) ignore the specified value for precision. Values with this type use the precision with which they were created (default is 6). (8523)

None.

When working with updatable cursors (cursors created using the FOR UPDATE clause), there is an issue with connection resets.

Do not reference rows after they have been deleted.
Unexpected results occur when working with updatable cursors. Update rows immediately after fetching them.
Columns named HELP may pick up leading spaces from the query used to create them. Use single quotes around the name HELP, or use an alternative name for the column.

An error is not returned when attempting to alter a sequence which sets the start value to less than that of the ceiling.

None. (While no error is returned, the operation does not change the start value.)

Using the nuosql command line, you cannot create tables with different cases, for example MyTable and mytable.

Use another client to create tables with an identical name but using a different case. Alternatively, create tables with different names.

A Can't follow the specified Use_Index hint(s) error is returned when quoted table or index names in index hints are not defined completely in upper case.

None.
When a schema that does not exist is dropped, no error message is returned. None.
Custom data types created with CREATE DOMAIN cannot be referenced by stored procedures. None.
Temporary tables are incorrectly listed in the SYSTEM schema but cannot be accessed using the SYSTEM schema. Temporary tables must be accessed using the USER schema.
When using multiple statements in a single call, the TRUNCATE command can be used only if it is the first statement in the call. None.
The ALTER TABLE command is not supported when working with temporary tables. (6363) Create a permanent table for any table that may require altering.
Renaming of triggers and indexes is not supported. (6359) Drop a trigger or index and recreate the trigger or index with a new name.
When dropping a domain, the same case (as was used to create the domain) for the domain name must be used. Otherwise, the domain is left in the DOMAINS system table. Recreate the domain and drop the domain using the same case that was used to create it.
The ALTER TABLE statement can create only one unnamed check constraint. Either add the unnamed check constraints when using the CREATE TABLE statement or use named check constraints.

DDL statements are not supported in stored procedures, except when using dynamic SQL. (6313)

DDL statements can be accessed in separate stored procedures which are executed after DDL stored procedures have been executed.

The trailing spaces in string values (stored in a covering index) get trimmed.

None.
SELECT statements, with extra parentheses around a subquery, return an error. Remove the extra set of parentheses.
When a storage group is removed from a Storage Manager (SM), the on-disk files for the data removed are not automatically deleted. Use NuoDB Check to remove on-disk files.

In Linux environments, NuoDB does not support the NO PAD collation option. As a result, unexpected results occur when comparing two strings where one is a substring of the other. For example:

"abc" = "abc"
"abc" > "abcX", where X is a non-printing character with value less than ASCII 32 (SPACE) (6854)

None.

If a database process, for example a TE or a SM, does not connect to an agent process, it cannot be stopped or restarted. If this happens, the database process is shown as UNREACHABLE.

Manually stop the database process using {kill -6 <pid>} in the command line, and remove the entry using the NuoDB Manager's domainstate removeprocess id <id> command. Then contact NuoDB Support to provide details of the core file obtained by the KILL command.
The following system tables are case sensitive: SYSTEM.DEPENDENCIES, SYSTEM.PRIVILEGES, SYSTEM.PROCEDURES, SYSTEM.PARTITIONEDTABLES, SYSTEM.PARTITIONIDS, SYSTEM.PARTITIONCRITERIA, and SYSTEM.LOCALATOMSEQUENCES. None.

NuoDB Loader does not support the loading of binary values cast into binary columns.

None.

The XA DataSource does not support statement and connection caching like the regular DataSource.

None.

Global temporary tables are not supported. (6942)

None.
Altering column data types does not change the values stored in tables; only field metadata is changed. (6955, 7244) None.
DDL statements are executed in separate system transactions and are not part of the user transaction. As a result, the DDL statement's changes are immediately visible under READ COMMITTED transaction isolation and are not rolled back. None.
The NuoDB JDBC driver does not support scrollable cursors. None.
NuoDB Manager's capture command does not store altAddress values if advertiseAlt is set to true. The local DNS IP address is used instead.

NuoDB does not support recursive DDL triggers.

None.
The JDBC driver does not support the setNetworkTimeout property. (7430, 7865) None.
The following host properties are not displayed by the NuoDB Manager command:
agentPeerTimeout, binDir, log, regionBalancerLocalFallback, requireConnectKey, and trackprocessOnReconnect.
None.
It is not possible to change the TABLE GENERATED clause syntax after a table has been created. None.
The return type of DATE_ADD and DATE_SUB functions with STRING arguments is dependent on the format of the string. To avoid inconsistent results, do not use the DATE_ADD and DATE_SUB functions with STRING data type columns
If an expression calls a user-defined-function, the supplied DEFAULTexpression is not checked to ensure it matches the type of the column it applies to. None.
NuoDB does not support the NULLS FIRST ordering clause. None.
The incorrect F ailed to apply license: Error applying license: failed to set configuration: default.license error is returned when there is no raft leader among the brokers. (8234) Ensure that all brokers in the raft membership are started and that there are no connectivity issues.
Point-in-time restore does not allow you to restore all available committed transactions. Instead, you must restore the database state to a specified transaction ID. As a result, the effects of other concurrent transactions (with different transaction IDs), may not be restored. None.
A column cannot be made to be the primary key of a table if that column was added to an existing table. (8748) None.
TEs use the system locale settings to define the character encoding used by the TE. If the system locale is different across the database nodes, this can result in unexpected behavior. For example, a TE may report data conversion errors on startup (bootstrap) if it is using a locale that is different from the existing TEs in the database. Ensure that all systems to be use for the database have the same locale setting.
Operations resulting in NUMERIC data types may have variable scale and precision depending on the operation and its operand types. Workaround: Explicitly cast the results to set the specific scale and precision. Explicitly cast the results to set the specific scale and precision.
It is not possible to use the same cursor name twice inside a stored procedure, even after closing that cursor. None.
The use of BINARY literal values as partitioning keys for STRING type columns, in CREATE TABLE statements, is not supported. None.
It is possible to create invalid table partitions when using case insensitive columns. This can result incorrect partition selection and returning data from the incorrect partition. Do not create partitions on a column that is case insensitive.
If two or more SMs enter a SYNCING state concurrently, on occasion, they may not transition out of that SYNCING state (as indicated by NuoDB Manager's show domain summary" command). The log messages of a SM stuck in the SYNCING state will include a SYNC: <number>: STARTED message but not have a corresponding SYNC: <number>: COMPLETED message. (8679) Kill one of these SMs to allow the other one to transition out the SYNCING state. Generally, try not to start two or more SMs concurrently. Instead, start SMs one at time after they have been synchronized.
Creating a table with TEXT column with a DEFAULT clause throws the Conversion to type "clob" is not implemented error. Either avoid using the DEFAULT clause or use a different data type.
Table partitioning does not support partitions based on sub-second precision. Do not create table partitions with sub-second partitions.
Occasionally (when a Storage Manager is under memory pressure), transactions may hang. Check whether transactions have hung by querying the SYSTEMS.CONNECTIONS table to see how long transactions have been running. For example:

SQL> select nodeid, transid, connid, created from system.connections where transid is not null;

Where transactions have hung, close the connection using the kill connid command. If that doesn't resolve the issue, restart Storage Managers one at a time until the hung transactions have been cleared from the system.
The information provided with the –help or -h options in NuoDB SQL has not been updated. Refer to support documentation in the Using NuoDB SQL Command Line section of NuoDB's online documentation