Compatibility
This section describes the compatibility of GaussDB in Oracle-compatible mode with the native Oracle database, and that of GaussDB in MySQL-compatible mode with the native MySQL database.
Compatibility with Oracle Database
GaussDB is basically compatible with Oracle Database in terms of basic functions (such as data types, SQL statements, and database objects) and PL/SQL. However, due to architecture design differences, there are still some incompatible items. For details about the differences between GaussDB in Oracle-compatible mode and Oracle Database 19c, see the following sections:
Compatibility with MySQL
GaussDB is compatible with MySQL in terms of data types, SQL functions, and database objects. Due to differences in the underlying framework implementations, there are still some distinctions between GaussDB and MySQL.
- For details about the differences between GaussDB in MySQL-compatible mode (with sql_compatibility set to 'MYSQL', b_format_version set to '5.7', and b_format_dev_version set to 's1') and MySQL 5.7, see the following sections:
- For details about the differences between GaussDB in MySQL-compatible mode (with sql_compatibility set to 'M') and MySQL 5.7, see the following sections:
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
