Updated on 2024-11-07 GMT+08:00

Checking GUC Parameters

This check item is displayed when the target database type is GaussDB 3.1 or later and the source database type is Oracle, Microsoft SQL Server, or MySQL. Check whether GUC parameters are configured. For details, see Table 1.
  • The GUC parameter check is performed based on the target database version you selected during evaluation project creation, instead of the target database version that is actually connected.
  • If the target database type is GaussDB Primary/Standby (M-compatible mode), GUC parameters cannot be checked.
Table 1 GUC parameter check items

Source DB Type

Target DB Version

Check Item

MySQL

GaussDB Primary/Standby 3.1 Enterprise Edition

-

GaussDB Primary/Standby 3.2 Enterprise Edition

b_format_behavior_compat_options

GaussDB Distributed 3.2 Enterprise Edition

-

GaussDB Primary/Standby 3.3 Enterprise Edition

b_format_behavior_compat_options

GaussDB Primary/Standby 8.0 Enterprise Edition

b_format_version,b_format_dev_version

GaussDB Distributed 8.0 Enterprise Edition

b_format_version,b_format_dev_version

GaussDB Primary/Standby 8.100 Enterprise Edition

b_format_version,b_format_dev_version

GaussDB Distributed 8.100 Enterprise Edition

b_format_version,b_format_dev_version

Oracle

GaussDB Primary/Standby 3.1 Enterprise Edition

behavior_compat_options,sql_beta_feature,a_format_version,a_format_dev_version

GaussDB Distributed 3.1 Enterprise Edition

behavior_compat_options,sql_beta_feature,a_format_version,a_format_dev_version

GaussDB Primary/Standby 3.2 Enterprise Edition

behavior_compat_options,plsql_compile_check_options,sql_beta_feature,a_format_version,a_format_dev_version

GaussDB Distributed 3.2 Enterprise Edition

behavior_compat_options,sql_beta_feature,a_format_version,a_format_dev_version

GaussDB Primary/Standby 3.3 Enterprise Edition

behavior_compat_options,plsql_compile_check_options,sql_beta_feature,IntervalStyle,a_format_version,a_format_dev_version

GaussDB Distributed 3.3 Enterprise Edition

behavior_compat_options,sql_beta_feature,IntervalStyle,a_format_version,a_format_dev_version

GaussDB Primary/Standby 8.0 Enterprise Edition

behavior_compat_options,plsql_compile_check_options,sql_beta_feature,IntervalStyle,a_format_version,a_format_dev_version

GaussDB Distributed 8.0 Enterprise Edition

behavior_compat_options,sql_beta_feature,IntervalStyle,a_format_version,a_format_dev_version

GaussDB Primary/Standby 8.100 Enterprise Edition

behavior_compat_options,plsql_compile_check_options,sql_beta_feature,IntervalStyle,a_format_version,a_format_dev_version

GaussDB Distributed 8.100 Enterprise Edition

behavior_compat_options,sql_beta_feature,IntervalStyle,a_format_version,a_format_dev_version

Microsoft SQL Server

GaussDB Primary/Standby 3.1 Enterprise Edition

behavior_compat_options,sql_beta_feature,a_format_version,a_format_dev_version

GaussDB Distributed 3.1 Enterprise Edition

behavior_compat_options,sql_beta_feature,a_format_version,a_format_dev_version

GaussDB Primary/Standby 3.2 Enterprise Edition

behavior_compat_options,plsql_compile_check_options,sql_beta_feature,a_format_version,a_format_dev_version

GaussDB Distributed 3.2 Enterprise Edition

behavior_compat_options,sql_beta_feature,a_format_version,a_format_dev_version

GaussDB Primary/Standby 3.3 Enterprise Edition

behavior_compat_options,plsql_compile_check_options,sql_beta_feature,a_format_version,a_format_dev_version

GaussDB Distributed 3.3 Enterprise Edition

behavior_compat_options,sql_beta_feature,a_format_version,a_format_dev_version

GaussDB Primary/Standby 8.0 Enterprise Edition

behavior_compat_options,plsql_compile_check_options,sql_beta_feature,a_format_version,a_format_dev_version

GaussDB Distributed 8.0 Enterprise Edition

behavior_compat_options,sql_beta_feature,a_format_version,a_format_dev_version

GaussDB Primary/Standby 8.100 Enterprise Edition

behavior_compat_options,plsql_compile_check_options,sql_beta_feature,a_format_version,a_format_dev_version

GaussDB Distributed 8.100 Enterprise Edition

behavior_compat_options,sql_beta_feature,a_format_version,a_format_dev_version