Overview of B-compatible Mode

B-compatible Mode compares GaussDB in B-compatible mode (that is, when sql_compatibility is set to 'B', b_format_version is set to '5.7', and b_format_dev_version is set to 's1') with MySQL 5.7. Only compatibility features added later than GaussDB Kernel 503.0.0 are described. You are advised to view the specifications and restrictions of the features in Developer Guide.

Currently, the implementation logic of B-compatible mode (sql_compatibility set to 'B') is similar to that of the MYSQL-compatible mode (sql_compatibility set to 'MYSQL') in the distributed mode.

The B-compatible mode here matches the MYSQL-compatible mode in the distributed GaussDB. For details, see "Overview > Overview of MYSQL-compatible Mode" in the distributed MySQL Compatibility Description.

GaussDB is compatible with MySQL in terms of data types, SQL functions, and database objects.

GaussDB and MySQL implement different underlying frameworks. Therefore, there are still some differences between GaussDB and MySQL.