This topic describes the keywords that are reserved in an ApsaraDB RDS for MySQL instance. Do not use these reserved keywords when you create user-defined functions (UDFs).
ApsaraDB RDS provides a few more reserved keywords in addition to the reserved keywords
that are provided by open source MySQL. The following table lists the new reserved
keywords that are provided by ApsaraDB RDS. For more information about the reserved
keywords that are provided by open source MySQL, see the following topics:
MySQL version | Reserved keyword | Description |
---|---|---|
8.0 | NEXTVAL | An operator that is used to access the value of a sequence in SQL statements. If a
UDF has the same name as the NEXTVAL operator, the priorities of the UDF and the NEXTVAL
operator vary based on the minor engine version of your RDS instance.
|
CURRVAL | An operator that is used to access the value of a sequence in SQL statements. If a
UDF has the same name as the CURRVAL operator, the priorities of the UDF and the CURRVAL
operator vary based on the minor engine version of your RDS instance.
|
|
5.7 | NEXTVAL | An operator that is used to access the value of a sequence in SQL statements. If a
UDF has the same name as the NEXTVAL operator, the priorities of the UDF and the NEXTVAL
operator vary based on the minor engine version of your RDS instance.
|
CURRVAL | An operator that is used to access the value of a sequence in SQL statements. If a
UDF has the same name as the CURRVAL operator, the priorities of the UDF and the CURRVAL
operator vary based on the minor engine version of your RDS instance.
|
|
RDS_AUDIT | None. | |
5.6 | ASYNC_COMMIT | None. |
CACHED | None. | |
CLUSTERING | None. | |
FORCE_UPDATE_PLAN_CACHE | None. | |
NO_PLAN_CACHE | None. |