44 个场景候选
反引号标识符backtick_quoting · minor · pendingCHECK TABLE 管理语句check_table · major · pending列 DEFAULT 表达式兼容差异column_default_expression · critical · pendingMySQL HANDLER 低层表访问语句handler_statement · critical · pendingUSE / FORCE / IGNORE INDEX 索引提示index_hints · minor · pendingINSERT IGNORE 容错插入insert_ignore · major · pendingJOIN ON 中的相关子查询join_on_correlated_subquery · critical · pendingJSON 列 -> 取 JSON 操作符json_arrow_operator.json_value · minor · documentedJSON 列 ->> 取文本操作符json_arrow_operator.text_value · minor · professionalMySQL LATERAL 派生表lateral_derived_table · critical · pendingLIMIT offset, count 逗号写法limit_comma_syntax · minor · professionalLOAD DATA [LOCAL] INFILE 批量装载load_data_infile · major · pendingLOCK TABLES / UNLOCK TABLESlock_tables · major · pendingDELETE ORDER BY / LIMITmysql_delete_order_limit · major · pendingGROUP BY 后缀式 WITH ROLLUPmysql_group_by_with_rollup · major · pendingMySQL 多表 DELETEmysql_multi_table_delete · critical · pendingMySQL 多表 UPDATEmysql_multi_table_update · critical · pending/*+ ... */ 优化器提示（MySQL 8.0 风格）mysql_optimizer_hint · minor · pendingUPDATE ORDER BY / LIMITmysql_update_order_limit · major · pendingMySQL 兼容检查：DB2 MATERIALIZEDoma.mysql.db2-materialized · critical · professionalMySQL 兼容检查：DB2 MERGE INTOoma.mysql.db2-merge-into · critical · professionalMySQL 兼容检查：DB2 OVERLAPSoma.mysql.db2-overlaps · critical · professionalMySQL 兼容检查：DB2 QUERY OPTIMIZEoma.mysql.db2-query-optimize · critical · professionalMySQL 兼容检查：DB2 RANDOM SORToma.mysql.db2-random-sort · critical · professionalMySQL 兼容检查：DB2 RETURNS ROWoma.mysql.db2-returns-row · critical · professionalMySQL 兼容检查：DB2 WITH NO DATAoma.mysql.db2-with-no-data · critical · professionalMySQL 兼容检查：LOAD XMLoma.mysql.load-xml · critical · professionalMySQL 兼容检查：NATURAL JOINoma.mysql.natural-join · critical · professionalMySQL 兼容检查：RLIKE REGEXPoma.mysql.rlike-regexp · critical · professionalMySQL 兼容检查：SUBQUERY IN WHILEoma.mysql.subquery-in-while · critical · professionalMySQL 兼容检查：WITH AS CTEoma.mysql.with-as-cte · critical · professionalINSERT ... ON DUPLICATE KEY UPDATEon_duplicate_key · major · pending显式分区选择（FROM t PARTITION (p)）partition_selection · minor · pendingREPAIR TABLE 管理语句repair_table · major · pendingREPLACE INTO 语句replace_into · major · pendingSELECT ... FOR SHAREselect_for_share · critical · pending遗留 LOCK IN SHARE MODE 锁定读select_for_share.lock_in_share_mode · critical · pendingSELECT ... INTO OUTFILE / DUMPFILEselect_into_outfile · major · pendingSELECT ... INTO @用户变量select_into_user_variable · critical · pendingSET GLOBAL/SESSION 变量与 sql_modeset_session_variables · major · pendingSHOW 元数据语句show_statements · minor · pendingSTRAIGHT_JOIN 连接顺序固定straight_join · minor · pending系统变量 @@var 读取system_variables · minor · pending用户变量 @varuser_variables · major · pending