not support dml with trigger sql

[Lxuty]

No description provided.

[Lxuty]

can not flash original table

[mark-neil-wang]

给个表结构，和样例数据，以及使用的mysql版本

[Lxuty]

Server version: 5.7.27-log MySQL Community Server (GPL) create database flash;use flash; CREATE TABLE `a` (   `id` int(11) DEFAULT NULL ) ENGINE=InnoDB; CREATE TABLE `b` (   `id` int(11) DEFAULT NULL ) ENGINE=InnoDB; delimiter ;;  CREATE  trigger t_test after delete on a for each row begin insert into b  values(old.id) ; end;; delimiter ; INSERT INTO `a` VALUES (1),(2),(3); reset master; delete from a; 闪回命令：mysqlbinlog --base64-output=decode-rows -vv binlog_output_base.flashback    只能解析到b表的记录，a表的无法解析。

…

------------------&nbsp;原始邮件&nbsp;------------------ 发件人: "mark-neil-wang"<[email protected]&gt;; 发送时间: 2021年1月21日(星期四) 下午4:34 收件人: "Meituan-Dianping/MyFlash"<[email protected]&gt;; 抄送: "许天云"<[email protected]&gt;; "Author"<[email protected]&gt;; 主题: Re: [Meituan-Dianping/MyFlash] not support dml with trigger sql (#14) 给个表结构，和样例数据，以及使用的mysql版本 — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or unsubscribe.