GUC Parameters of GaussDB (Oracle-Compatible Mode)
For GaussDB databases compatible with Oracle syntax, you can set the GUC parameters to enhance the compatibility. For details, see Table 1.
GaussDB provides many operation parameters. Configurations of these parameters affect the behavior of the database system. Before changing these parameters, learn the impact of these parameters on the database. Otherwise, unexpected results may occur. For details, see GUC Parameter Usage.
Oracle-Compatible Configuration Item |
Compatibility Configuration Item |
Compatibility Configuration Item Name |
Supported Database |
Enable |
Description |
---|---|---|---|---|---|
behavior_compat_options |
display_leading_zero |
Specifies how floating point numbers are displayed. 0 before the decimal point is displayed |
Centralized/Distributed |
Yes |
Centralized: GUC Parameters. Distributed: Parameter Details |
end_month_calculate |
Specifies the calculation logic of the add_months function. |
Centralized/Distributed |
Yes |
||
bind_procedure_searchpath |
Specifies the search path of the database object in a stored procedure for which no schema name is specified. |
Centralized/Distributed |
Yes |
||
correct_to_number |
Specifies the compatibility of the to_number() result. |
Centralized/Distributed |
Yes |
||
unbind_divide_bound |
Specifies the range check on the result of integer division. |
Centralized/Distributed |
Yes |
||
convert_string_digit_to_numeric |
Determines whether to convert numeric constants of the character string type to those of the numeric type before these two types are compared. |
Centralized/Distributed |
Yes |
||
return_null_string |
Specifies how to display the empty result (empty string '') of the lpad() and rpad() functions. |
Centralized/Distributed |
Yes |
||
merge_update_multi |
Controls the UPDATE behavior if a piece of target data in the target table conflicts with multiple pieces of source data When MERGE INTO ... WHEN MATCHED THEN UPDATE and INSERT ... ON DUPLICATE KEY UPDATE are used. |
Centralized/Distributed |
Yes |
||
plstmt_implicit_savepoint |
Determines whether the execution of an UPDATE statement in a stored procedure has an independent subtransaction. |
Centralized/Distributed |
Yes |
||
hide_tailing_zero |
Controls configuration item for numeric display. |
Centralized/Distributed |
Yes |
||
rownum_type_compat |
Specifies the ROWNUM type. |
Centralized |
Yes |
||
aformat_null_test |
Specifies the logic for checking whether the row type is not null. |
Centralized/Distributed |
Yes |
||
aformat_regexp_match |
Determines the matching behavior of regular expression functions. |
Centralized/Distributed |
Yes |
||
compat_cursor |
Determines the compatibility behavior of implicit cursor states. |
Centralized |
Yes |
||
proc_outparam_override |
Determines the overloading of output parameters of a stored procedure. |
Centralized/Distributed |
Yes |
||
proc_implicit_for_loop_variable |
Controls the behavior of the FOR_LOOP query statement in a stored procedure. |
Centralized |
Yes |
||
allow_procedure_compile_check |
Controls the compilation check of the SELECT and OPEN CURSOR statements in a stored procedure. |
Centralized |
Yes |
||
plsql_security_definer |
Determines whether the definer permission is used by default when a stored procedure is created. |
Centralized/Distributed |
Yes |
||
plpgsql_dependency |
Determines whether a function, stored procedure, or package containing undefined objects can be created. |
Centralized |
Yes |
||
plsql_compile_check_options |
plsql_expression_check |
If the plsql_expression_check parameter is enabled, the plpgsql_dependency parameter must also be enabled. |
Centralized 503.1 |
Yes |
|
a_format_version |
10c |
Specifies database platform compatibility configuration items. |
Centralized/Distributed |
Yes |
|
a_format_dev_version |
s1 |
Specifies the compatible minor version of the database platform. |
Centralized/Distributed 503.0 |
Yes |
|
s2 |
Specifies the compatible minor version of the database platform. |
Centralized/Distributed 503.1 |
Yes |
||
s3 |
Specifies the compatible minor version of the database platform. |
Centralized/Distributed 503.2 |
Yes |
||
s4 |
Specifies the compatible minor version of the database platform. |
Centralized/Distributed 505.0 |
Yes |
||
s5 |
Specifies the compatible minor version of the database platform. |
Centralized/Distributed 505.1 |
Yes |
||
s6 |
Specifies the compatible minor version of the database platform. |
Centralized/Distributed 505.2 |
Yes |
||
sql_beta_feature |
a_style_coerce |
Affects the decode function. |
Centralized/Distributed |
Yes |
Set the a_format_dev_version parameter as follows:
- For GaussDB V2.0-3.1 Enterprise Edition, set the value to s1.
- For GaussDB V2.0-3.2 Enterprise Edition, set the value to s2.
- For GaussDB V2.0-3.3 Enterprise Edition, set the value to s3.
- For GaussDB V2.0-8.0 Enterprise Edition, set the value to s4.
- For GaussDB V2.0-8.100 Enterprise Edition, set the value to s5.
- For GaussDB V2.0-8.200 Enterprise Edition and GaussDB V2.0-9.0 Enterprise Edition, set the value to s6.
For details about the versions, see What Is the Mapping Between the GaussDB Versions Displayed on the UGO Console and Self-built GaussDB Versions?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot