MYSQL 迁移 oceanbase 4.3 mysql 模式 改造清单

GET_LOCK / RELEASE_LOCK 咨询锁函数partial · major · my.func.advisory_locks ALTER TABLE ALGORITHM= / LOCK= 在线 DDL 子句none · minor · my.ddl.alter_algorithm 表/列级 CHARSET 与 COLLATE 子句partial · major · my.ddl.charset_collation DECLARE ... HANDLER 条件处理器partial · major · my.proc.handler DEFINER 定义者权限子句partial · minor · my.proc.definer ENGINE= 存储引擎子句partial · minor · my.ddl.engine_clause ENUM 枚举类型partial · major · my.type.enum 事件调度器(CREATE EVENT / ON SCHEDULE)partial · major · my.proc.event 全文索引(FULLTEXT / MATCH AGAINST)partial · major · my.ddl.fulltext 生成列(GENERATED ALWAYS AS ... VIRTUAL/STORED)partial · major · my.ddl.generated_column USE / FORCE / IGNORE INDEX 索引提示partial · minor · my.syntax.index_hints JSON 列 -> / ->> 操作符partial · minor · my.syntax.json_arrow JSON_* 函数族partial · major · my.func.json_family LOAD DATA [LOCAL] INFILE 批量装载partial · major · my.syntax.load_data LOCK TABLES / UNLOCK TABLESpartial · major · my.syntax.lock_tables /*+ ... */ 优化器提示(MySQL 8.0 风格)partial · minor · my.syntax.optimizer_hint ON UPDATE CURRENT_TIMESTAMP 自动更新时间戳partial · major · my.ddl.on_update_timestamp PARTITION BY HASH / KEY / LIST 分区partial · minor · my.ddl.partition_hash_list_key SELECT ... INTO OUTFILE / DUMPFILEpartial · major · my.syntax.into_outfile SET GLOBAL/SESSION 变量与 sql_modepartial · major · my.syntax.set_variables SET 集合类型partial · major · my.type.set SHOW 元数据语句partial · minor · my.syntax.show_statements SIGNAL / RESIGNAL 抛出条件partial · major · my.proc.signal 空间类型与空间索引(GEOMETRY / SPATIAL INDEX)partial · major · my.ddl.spatial SQL_CALC_FOUND_ROWS / FOUND_ROWS 分页计数partial · major · my.func.found_rows 存储函数(CREATE FUNCTION)partial · major · my.proc.stored_function 存储过程(CREATE PROCEDURE)partial · major · my.proc.stored_procedure STRAIGHT_JOIN 连接顺序固定partial · minor · my.syntax.straight_join 系统变量 @@var 读取partial · minor · my.syntax.system_variables 触发器(CREATE TRIGGER)partial · major · my.proc.trigger