Overview
This topic describes the RDS MySQL 5.7 parameters of apsaradb for ONLY_FULL_GROUP_BY.
Background information
Alibaba Cloud reminds you that:
- When you perform operations that have risks, such as modifying instance configurations or data, check the disaster recovery and fault tolerance capabilities of the instances to ensure data security.
- Before you modify the configurations and data of instances including but not limited to ECS and RDS instances, we recommend that you create snapshots or enable RDS log backup.
- If you have authorized or submitted security information such as the logon account and password in the Alibaba Cloud Management console, we recommend that you modify such information in a timely manner.
- View the SQL Mode contained in sql_mode through the relevant configuration, as shown below, to confirm that no syntax is supported ONLY_FULL_GROUP_BY set.
sql_mode=REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,NO_UNSIGNED_SUBTRACTION,NO_DIR_ IN_CREATE,POSTGRESQL,ORACLE,MSSQL,DB2,MAXDB,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,MYSQL 323,MYSQL40,ANSI,NO_AUTO_VALUE_ON_ZERO,NO_BACKSLASH_ESCAPES,STRICT_TRANS_TABLES,STRICT_ALL_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,HIGH_NOT _PRECEDENCE,NO_ENGINE_SUBSTITUTION,PAD_CHAR_TO_FULL_LENGTH
- Execution
select @@global.sql_modeSQL statement on the server. Confirm that the parameter still contains ONLY_FULL_GROUP_BY. - The preceding sql_mode contains ANSI parameters, while the ONLY_FULL_GROUP_BY is a subset of ANSI. As a result, sql_mode is automatically set to ONLY_FULL_GROUP_BY.
Application scope
-
ApsaraDB for RDS