Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

Statement/Type-Related Parameters

The following are parameters related to SQL statements and data types supported by CUBRID. The type and value range for each parameter are as follows:

Parameter Name

Type

Default Value

ansi_quotes

bool

yes

block_ddl_statement

bool

no

block_nowhere_statement

bool

no

compat_numeric_division_scale

bool

no

intl_mbs_support

bool

no

oracle_style_empty_string

bool

no

only_full_group_by

bool

no

pipes_as_concat

bool

yes

ansi_quotes

ansi_quotes is a parameter that enclose symbols and character string to handle identifiers. The default value is yes. If this parameter value is set to yes, double quotations are handled as identifier symbols and single quotations are handled as character string symbols. If it is set to no, double quotations are handled as character string symbols.

block_ddl_statement

block_ddl_statement is a parameter that restricts the execution of DDL (Data Definition Language) statements by the client. If the parameter is configured to no, the given client is allowed to execute DDL statements. If it is configured to yes, the client is not permitted to execute DDL statements. The default value is no.

block_nowhere_statement

block_nowhere_statement is a parameter that restricts the execution of UPDATE/DELETE statements without a condition clause (WHERE) by the client. If the parameter is configured to no, the given client is allowed to execute UPDATE/DELETE statements without a condition clause. If it is configured to yes, the client is not permitted to execute UPDATE/DELETE statements without a condition clause. The default value is no.

compact_numeric_division_scale

compat_numeric_division_scale is a parameter that configures the scale to be displayed in the result (quotient) of a division operation. If the parameter is configured to no, the scale of the quotient is 9 if it is configured to yes, the scale is determined by that of the operand. The default value is no.

intl_mbs_support

intl_mbs_support is a parameter that specifies whether or not to support multi-byte character set. If the parameter is configured to no, a multi-byte character set is not allowed if it is configured to yes, a multi-byte character set is allowed. To improve performance, it is recommended to configure the intl_mbs_support parameter to no and use alphabets for table and column names because operation cost for supporting multi-byte character set is high.

oracle_style_empty_string

oracle_style_empty_string is a parameter that improves compatibility with other DBMS (Database Management Systems) and specifies whether or not to process empty strings as NULL as in Oracle DBMS. If the oracle_style_empty_string parameter is configured to no, the character string is processed as a valid string if it is configured to yes, the empty string is processed as NULL.

only_full_group_by

only_full_group_by is a parameter that specifies whether extended syntax about using GROUP BY statement is used or not.

If this parameter value is set to no, an extended syntax is applied thus, a column that is not specified in the GROUP BY statement can be specified in the SELECT column list. If it is set to yes, a column that is only specified in the GROUP BY statement can be the SELECT column list.

The default value is no. Therefore, specify the only_full_group_by parameter value to yes to execute queries by SQL standards. Because the extended syntax is not applied in this case, an error below is displayed.

ERROR: Attributes exposed in aggregate queries must also appear in the group by clause.

pipes_as_concat

pipes_as_concat is a parameter about using a double pipe symbol. The default value is yes. If this parameter value is set to yes, a double pipe symbol is handled as a concatenation operator if no, it is handled as the OR operator.