MySQL · 事务、并发与运行语义

浏览 MySQL 迁移中的 事务、并发与运行语义 场景;每条详情保留来源状态、正向示例、跨目标结论与验证边界。

59 个场景候选

CHECK 约束执行与静默忽略差异check_constraint · critical · pendingCHECKSUM TABLE 校验语句checksum_table · major · pendingMySQL 位异或 ^mysql_bitwise_xor · major · pendingMySQL 逻辑 XORmysql_boolean_xor · major · pendingMySQL CONCAT 函数mysql_concat_function · major · pendingCONCAT_WS 分隔拼接的 NULL 语义mysql_concat_ws_function · major · pendingCONNECTION_ID/USER/SYSTEM_USER 会话身份mysql_connection_identity_functions · critical · pendingMySQL CURDATE 函数mysql_curdate_function · major · pendingMySQL DATABASE/SCHEMA 当前库函数mysql_current_database_function · major · pendingCURTIME/SYSDATE 当前时间语义mysql_current_time_functions · critical · pendingDAYNAME/MONTHNAME 本地化名称mysql_date_name_functions · major · pendingDATEDIFF 整日边界差mysql_datediff_function · critical · professionalDELETE IGNORE 错误降级mysql_delete_ignore · critical · pendingMySQL 除法零除语义mysql_division_by_zero_semantics · critical · pendingDIV 整数除法运算符mysql_integer_division_operator · major · pendingMySQL LENGTH 字节长度语义mysql_length_byte_semantics · critical · pendingMySQL MAKETIME 时长/时间构造mysql_maketime_duration · major · pendingMySQL 取模零除语义mysql_modulo_zero_semantics · critical · pendingMySQL NULL 安全等号 <=>mysql_null_safe_equality · major · pendingMySQL || 受 PIPES_AS_CONCAT 影响mysql_pipes_sql_mode · critical · pendingMySQL REGEXP/RLIKE 操作符mysql_regexp_operator · major · pendingROW_COUNT 上一语句影响行数mysql_row_count_function · critical · pendingSLEEP 数据库会话阻塞mysql_sleep_function · critical · pendingSOUNDS LIKE 英文语音比较mysql_sounds_like · major · pendingSTRCMP 三值字符串比较mysql_strcmp_function · critical · pendingADDTIME/SUBTIME/TIMEDIFF 时间算术mysql_time_arithmetic_functions · critical · pendingSEC_TO_TIME/TIME_TO_SEC 时长换算mysql_time_seconds_functions · critical · pendingTIMESTAMPADD/TIMESTAMPDIFF 单位截断语义mysql_timestamp_interval_functions · blocker · professionalUPDATE IGNORE 错误降级mysql_update_ignore · critical · pendingUUID_SHORT 64 位拓扑相关标识mysql_uuid_short · blocker · pendingWEEK/WEEKOFYEAR/WEEKDAY 周序模式mysql_week_functions · blocker · pendingWEIGHT_STRING/COLLATION 排序权重依赖mysql_weight_collation_functions · blocker · pendingMySQL 兼容检查:GET DIAGNOSTICS CONDITIONoma.mysql.get-diagnostics-condition · critical · professionalMySQL SQL 治理检查:BUILTIN PRIOR BACKUP CHECKperf_static_risk.bb.mysql.builtin_prior_backup_check · major · professionalMySQL SQL 治理检查:BUILTIN WALK THROUGH CHECKperf_static_risk.bb.mysql.builtin_walk_through_check · major · professionalMySQL SQL 治理检查:STATEMENT ADD COLUMN WITHOUT POSITIONperf_static_risk.bb.mysql.statement_add_column_without_position · major · professionalMySQL SQL 治理检查:STATEMENT DISALLOW COMMITperf_static_risk.bb.mysql.statement_disallow_commit · major · professionalMySQL SQL 治理检查:STATEMENT DISALLOW LIMITperf_static_risk.bb.mysql.statement_disallow_limit · major · professionalMySQL SQL 治理检查:STATEMENT DISALLOW ORDER BYperf_static_risk.bb.mysql.statement_disallow_order_by · major · professionalMySQL SQL 治理检查:STATEMENT DISALLOW TRUNCATEperf_static_risk.bb.mysql.statement_disallow_truncate · major · professionalMySQL SQL 治理检查:STATEMENT DML DRY RUNperf_static_risk.bb.mysql.statement_dml_dry_run · major · professionalMySQL SQL 治理检查:STATEMENT INSERT DISALLOW ORDER BY RANDperf_static_risk.bb.mysql.statement_insert_disallow_order_by_rand · major · professionalMySQL SQL 治理检查:STATEMENT INSERT MUST SPECIFY COLUMNperf_static_risk.bb.mysql.statement_insert_must_specify_column · major · professionalMySQL SQL 治理检查:STATEMENT MAX EXECUTION TIMEperf_static_risk.bb.mysql.statement_max_execution_time · major · professionalMySQL SQL 治理检查:STATEMENT MAXIMUM STATEMENTS IN TRANSACTIONperf_static_risk.bb.mysql.statement_maximum_statements_in_transaction · major · professionalMySQL SQL 治理检查:STATEMENT MERGE ALTER TABLEperf_static_risk.bb.mysql.statement_merge_alter_table · major · professionalMySQL SQL 治理检查:STATEMENT REQUIRE ALGORITHM OR LOCK OPTIONperf_static_risk.bb.mysql.statement_require_algorithm_or_lock_option · major · professionalMySQL SQL 治理检查:STATEMENT WHERE NO EQUAL NULLperf_static_risk.bb.mysql.statement_where_no_equal_null · major · professionalMySQL SQL 治理检查:STATEMENT WHERE REQUIRE SELECTperf_static_risk.bb.mysql.statement_where_require_select · major · professionalMySQL SQL 治理检查:STATEMENT WHERE REQUIRE UPDATE DELETEperf_static_risk.bb.mysql.statement_where_require_update_delete · major · professionalMySQL SQL 治理检查:SYSTEM CHARSET ALLOWLISTperf_static_risk.bb.mysql.system_charset_allowlist · major · professionalMySQL SQL 治理检查:SYSTEM COLLATION ALLOWLISTperf_static_risk.bb.mysql.system_collation_allowlist · major · professionalOceanBase SQL 治理检查:STATEMENT DISALLOW OFFLINE DDLperf_static_risk.bb.oceanbase.statement_disallow_offline_ddl · major · professionalSELECT ... FOR UPDATE SKIP LOCKEDskip_locked · critical · pendingREAD UNCOMMITTED/SERIALIZABLE 隔离级别差异transaction_isolation_level · critical · pendingSET TRANSACTION READ ONLY 只读事务契约transaction_read_only_semantics · critical · pendingRR 下 UPDATE 子查询快照差异update_subquery_rr_snapshot · critical · pendingMySQL XA 事务语句xa_statement · blocker · pendingMySQL 零日期字面量zero_date_literal · critical · pending