Skip to main content
Version: 3.13
Features and pricing

ScalarDB SQL Error Codes

This page provides a list of error codes in ScalarDB SQL.

Error code classes and descriptions​

ClassDescription
SQL-1xxxxErrors for the user error category

SQL-1xxxx status codes​

SQL-10000​

Message

The namespace does not exist. Namespace: %s

SQL-10001​

Message

The table does not exist. Table: %s

SQL-10002​

Message

The column %s does not exist

SQL-10003​

Message

The column does not exist. Table: %s; Column: %s

SQL-10004​

Message

The column index is out of bounds. Index: %d; Size: %d

SQL-10005​

Message

A positional bind marker is not allowed when binding named values

SQL-10006​

Message

A named bind marker is not allowed when binding positional values

SQL-10007​

Message

Cannot convert BLOB values to SQL. Please use a bind marker for a BLOB value and bind it separately

SQL-10008​

Message

No namespace name has been specified. Set a default namespace name, or explicitly specify a namespace name

SQL-10009​

Message

Zero bytes may not occur in string parameters

SQL-10010​

Message

Mixing positional values and named values is not allowed

SQL-10011​

Message

Preparing a transaction is supported only in two-phase commit transaction mode

SQL-10012​

Message

Validating a transaction is supported only in two-phase commit transaction mode

SQL-10013​

Message

The previous transaction is still in progress. Commit, roll back, or suspend the previous transaction first

SQL-10014​

Message

This SQL session has already been closed

SQL-10015​

Message

A transaction has not begun

SQL-10016​

Message

The type %s is not supported

SQL-10017​

Message

No connection mode implementations are found. Please add a connection mode implementation to the classpath

SQL-10018​

Message

The connection mode is not specified, but multiple connection mode implementations are found. Specify one of the following connection modes: %s

SQL-10019​

Message

The connection mode '%s' is not found. Specify one of the following connection modes: %s

SQL-10020​

Message

Access denied: You need the %s privilege for the namespace %s to execute this operation

SQL-10021​

Message

Access denied: You need the %s privilege for the table %s to execute this operation

SQL-10022​

Message

Access denied: You can't grant the %s privilege because you don't have the same privilege for the table %s

SQL-10023​

Message

Access denied: You can't grant the %s privilege because you don't have the same privilege for the namespace %s

SQL-10024​

Message

Access denied: You can't revoke the %s privilege because you don't have the same privilege for the table %s

SQL-10025​

Message

Access denied: You can't revoke the %s privilege because you don't have the same privilege for the namespace %s

SQL-10026​

Message

Syntax error. Line %d:%d %s

SQL-10027​

Message

Syntax error. Multiple PRIMARY KEYs specified (exactly one required)

SQL-10028​

Message

Cannot grant the INSERT privilege if the user doesn't have the UPDATE privilege

SQL-10029​

Message

Cannot grant the UPDATE privilege if the user doesn't have the INSERT privilege

SQL-10030​

Message

Cannot grant the UPDATE privilege if the user doesn't have the SELECT privilege

SQL-10031​

Message

Cannot grant the DELETE privilege if the user doesn't have the SELECT privilege

SQL-10032​

Message

Cannot revoke the SELECT privilege if the user has the UPDATE privilege

SQL-10033​

Message

Cannot revoke the SELECT privilege if the user has the DELETE privilege

SQL-10034​

Message

Cannot revoke the INSERT privilege if the user has the UPDATE privilege

SQL-10035​

Message

Cannot revoke the UPDATE privilege if the user has the INSERT privilege

SQL-10036​

Message

A non-clustering-key column is specified in the CLUSTERING ORDER directive. Column: %s

SQL-10037​

Message

The order of the columns in the CLUSTERING ORDER directive must match the order for the clustering key (%s must appear before %s)

SQL-10038​

Message

The CLUSTERING ORDER is missing for the column %s

SQL-10039​

Message

Empty SQL is specified

SQL-10040​

Message

Multiple SQLs are not allowed

SQL-10041​

Message

The column %s is ambiguous

SQL-10042​

Message

The column %s cannot be specified in the %s clause. Only the columns in the table %s can be specified in the %s clause

SQL-10043​

Message

An unbound bind marker is still in the escape character of the LIKE predicate for the column %s

SQL-10044​

Message

The escape character must be a TEXT value for the LIKE predicate for the column %s

SQL-10045​

Message

The value of the predicate must not be null unless the operator is 'IS NULL' or 'IS NOT NULL'. Predicate: %s

SQL-10046​

Message

An unbound bind marker is still in the LIMIT clause

SQL-10047​

Message

The LIMIT must be an INT value

SQL-10048​

Message

Unmatched column names or values

SQL-10049​

Message

The column %s is specified twice

SQL-10050​

Message

All primary key columns must be specified in the INSERT or UPSERT statement

SQL-10051​

Message

An unbound bind marker is still in the value of the column %s

SQL-10052​

Message

Unmatched column type. The type of the column %s should be %s, but a boolean value (BOOLEAN) is specified

SQL-10053​

Message

Unmatched column type. The type of the column %s should be %s, but a decimal number (INT or BIGINT) is specified

SQL-10054​

Message

Unmatched column type. The type of the column %s should be %s, but a floating point number (FLOAT or DOUBLE) is specified

SQL-10055​

Message

Unmatched column type. The type of the column %s should be %s, but a string (TEXT) is specified

SQL-10056​

Message

Unmatched column type. The type of the column %s should be %s, but a BOOLEAN value is specified

SQL-10057​

Message

Unmatched column type. The type of the column %s should be %s, but an INT value is specified

SQL-10058​

Message

Unmatched column type. The type of the column %s should be %s, but a BIGINT value is specified

SQL-10059​

Message

Unmatched column type. The type of the column %s should be %s, but a FLOAT value is specified

SQL-10060​

Message

Unmatched column type. The type of the column %s should be %s, but a DOUBLE value is specified

SQL-10061​

Message

Unmatched column type. The type of the column %s should be %s, but a TEXT value is specified

SQL-10062​

Message

Unmatched column type. The type of the column %s should be %s, but a BLOB value is specified

SQL-10063​

Message

RIGHT OUTER JOIN can only be specified as the first join

SQL-10064​

Message

The JOIN predicate is not specified properly. Predicate: %s

SQL-10065​

Message

The data types of the columns in the JOIN predicate do not match. Predicate: %s

SQL-10066​

Message

The column %s is specified twice in the JOIN predicates. Predicates: %s

SQL-10067​

Message

Either all primary key columns or an indexed column for the table %s must be specified in the JOIN predicates. Predicates: %s

SQL-10068​

Message

Cannot issue mutation DML SQLs such as INSERT, UPDATE or DELETE with executeQuery()

SQL-10069​

Message

Cannot issue SELECT SQLs with executeUpdate()

SQL-10070​

Message

The TWO_PHASE_COMMIT_TRANSACTION mode is not supported in the current transaction manager