1. 类型与值域
full 0partial 0none 0unknown 23
十章工程目录
2. DDL 与数据库对象
full 0partial 0none 0unknown 95
3. 查询与结果语义
full 0partial 0none 0unknown 14
4. DML 与数据写入
full 0partial 0none 0unknown 1
5. 函数与表达式
full 0partial 0none 0unknown 35
6. 事务与并发
full 0partial 0none 0unknown 23
7. PL/SQL 与存储程序
full 0partial 0none 0unknown 21
8. 序列、同义词与触发器
full 0partial 0none 0unknown 2
9. 性能与分布式架构
full 0partial 0none 0unknown 13
10. 驱动与应用层
full 0partial 0none 0unknown 0
优先核对的高风险场景
既有改造点明细
GET_LOCK / RELEASE_LOCK 咨询锁函数unknown · major · my.func.advisory_locksALTER TABLE ALGORITHM= / LOCK= 在线 DDL 子句unknown · minor · my.ddl.alter_algorithmALTER TABLE 增删主键限制unknown · critical · my.ddl.alter_primary_keyAUTO_INCREMENT 自增列unknown · minor · my.ddl.auto_increment反引号标识符unknown · minor · my.syntax.backtickMySQL BINARY/VARBINARY 类型unknown · major · my.type.binary_varbinaryMySQL BIT 类型unknown · major · my.type.bit表/列级 CHARSET 与 COLLATE 子句unknown · major · my.ddl.charset_collationCHECK 约束执行与静默忽略差异unknown · critical · my.ddl.check_constraintCHECK TABLE 管理语句unknown · major · my.admin.check_tableCHECKSUM TABLE 校验语句unknown · major · my.admin.checksum_table列 DEFAULT 表达式兼容差异unknown · critical · my.ddl.default_expressionDECLARE ... HANDLER 条件处理器unknown · major · my.proc.handlerCONVERT(expr USING charset) 字符集转换unknown · minor · my.func.convert_usingMySQL CREATE TABLE ... AS SELECTunknown · major · my.ddl.create_table_as_selectDATE_ADD / DATE_SUB / ADDDATE / SUBDATE 日期运算函数unknown · minor · my.func.date_add_intervalDATE_FORMAT 函数（% 格式符体系）unknown · minor · my.func.date_formatMySQL DATETIME/TIMESTAMP 类型语义unknown · critical · my.type.datetime_timestampDEFINER 定义者权限子句unknown · minor · my.proc.definerMySQL 降序索引列unknown · major · my.index.descendingENGINE= 存储引擎子句unknown · minor · my.ddl.engine_clauseENUM 枚举类型unknown · major · my.type.enum事件调度器（CREATE EVENT / ON SCHEDULE）unknown · major · my.proc.eventMySQL ExtractValue XML 函数unknown · major · my.func.extractvalueMySQL 外键约束unknown · critical · my.ddl.foreign_key全文索引（FULLTEXT / MATCH AGAINST）unknown · major · my.ddl.fulltext生成列（GENERATED ALWAYS AS ... VIRTUAL/STORED）unknown · major · my.ddl.generated_columnGROUP_CONCAT 聚合函数unknown · minor · my.func.group_concatMySQL HANDLER 低层表访问语句unknown · critical · my.syntax.handlerIF(expr, v1, v2) 流程控制函数unknown · minor · my.func.ifIFNULL 函数unknown · minor · my.func.ifnullUSE / FORCE / IGNORE INDEX 索引提示unknown · minor · my.syntax.index_hintsINSERT IGNORE 容错插入unknown · major · my.syntax.insert_ignore整数显示宽度 INT(n)unknown · minor · my.type.int_display_widthJOIN ON 中的相关子查询unknown · critical · my.subquery.join_on_correlatedJSON 列 -> 取 JSON 操作符unknown · minor · my.syntax.json_arrowJSON 列 ->> 取文本操作符unknown · minor · my.syntax.json_arrow_textJSON_* 函数族unknown · major · my.func.json_familyLAST_INSERT_ID 函数unknown · major · my.func.last_insert_idMySQL LATERAL 派生表unknown · critical · my.syntax.lateral_derivedLIMIT offset, count 逗号写法unknown · minor · my.syntax.limit_commaLOAD DATA [LOCAL] INFILE 批量装载unknown · major · my.syntax.load_dataMySQL LOAD_FILE 函数unknown · critical · my.func.load_fileLOCK TABLES / UNLOCK TABLESunknown · major · my.syntax.lock_tablesMySQL MASTER_POS_WAIT 复制等待unknown · blocker · my.func.master_pos_waitMySQL MEDIUMINT 类型unknown · major · my.type.mediumintMySQL 多值索引unknown · critical · my.index.multi_valuedAES_ENCRYPT/AES_DECRYPT 密文兼容unknown · blocker · my.func.aes_cryptoMySQL Enterprise 非对称加密函数族unknown · blocker · my.func.asymmetric_cryptoFROM_BASE64/TO_BASE64 编码细节unknown · major · my.func.base64BIN/BIT_COUNT 位字符串辅助函数unknown · major · my.func.bit_helpersMySQL 位异或 ^unknown · major · my.op.bitwise_xorMySQL BLOB 基础类型unknown · major · my.type.blob_baseMySQL BOOLEAN/BOOL 类型unknown · minor · my.type.booleanMySQL 逻辑 XORunknown · major · my.op.boolean_xorDAY/DAYOFWEEK/DAYOFYEAR 日序函数族unknown · critical · my.func.calendar_dayLCASE/UCASE 大小写别名unknown · major · my.func.case_aliasCHAR 数值序列转字符unknown · critical · my.func.char_codeMySQL CHAR/VARCHAR 类型unknown · minor · my.type.character_baseCOMPRESS/UNCOMPRESS 二进制格式unknown · critical · my.func.compressionMySQL CONCAT 函数unknown · major · my.func.concatCONCAT_WS 分隔拼接的 NULL 语义unknown · major · my.func.concat_wsCONNECTION_ID/USER/SYSTEM_USER 会话身份unknown · critical · my.func.connection_identityMySQL CONVERT_TZ 时区转换unknown · critical · my.func.convert_tzCREATE TABLE ... LIKE 克隆表结构unknown · major · my.ddl.create_table_likeMySQL CURDATE 函数unknown · major · my.func.curdateMySQL DATABASE/SCHEMA 当前库函数unknown · major · my.func.current_databaseCURTIME/SYSDATE 当前时间语义unknown · critical · my.func.current_timeDAYNAME/MONTHNAME 本地化名称unknown · major · my.func.date_nameMySQL DATE 类型unknown · minor · my.type.date_baseDATEDIFF 整日边界差unknown · critical · my.func.datediffDELETE IGNORE 错误降级unknown · critical · my.dml.delete_ignoreDELETE ORDER BY / LIMITunknown · major · my.dml.delete_order_limitMySQL 除法零除语义unknown · critical · my.op.division_zero_semanticsMySQL bare DOUBLE 类型别名unknown · major · my.type.double_aliasFIELD/ELT 位置与取值函数unknown · major · my.func.field_eltFIND_IN_SET 逗号集合查找unknown · critical · my.func.find_in_setMySQL FIXED 定点数别名unknown · minor · my.type.fixed_aliasGROUP BY 后缀式 WITH ROLLUPunknown · major · my.syntax.group_by_with_rollupHEX/UNHEX 二进制与文本转换unknown · critical · my.func.hex_helpers
上线前验证清单
- 精确版本、模式、参数、字符集、时区与驱动元数据
- DDL 建删、数据值域、事务回滚、并发冲突与异常行为
- 执行计划、统计信息、分片键、跨分片事务与热点写入
- 改造前后结果集、性能基线、回退条件与复扫闭环