SQL_MODE values:

ClustrixDB provides support for the following values for SQL_MODE:

Setting SQL_MODE

SQL_MODE can be set via a variable for a session (affects only the current client), or globally (which affects new sessions). For more information, see Global Variables. The global variable for SQL_MODE can capture multiple modes:

sql> set sql_mode = "STRICT_ALL_TABLES,STRICT_TRANS_TABLES";

Caveats for SQL_MODE:

See also warning below about unsupported values. 

Unsupported SQL_MODES:

Attempting to set SQL_MODE to an unsupported value will result in a NULL value being set. ClustrixDB does not warn on unsupported values for SQL_MODE

Clustrix does not support the following values for SQL_MODE: