2022-12-02 mysql列存储引擎-trigger插入数据错误-记录

摘要:

mysql列存储引擎-trigger插入数据错误-记录

关联ISSUE: https://github.com/stoneatom/stonedb/issues/581

DDL:

表结构:

drop table t1,t2;

create table t1 (id int primary key, copy int) engine=tianmu;
 
create table t2 (id int primary key, data int) engine=tianmu;

create table t1 (id int, copy int) engine=tianmu;
 
create table t2 (id int, data int) engine=tianmu;

创建trigger:

create trigger t1_bi before insert on t1 for each row
  set new.copy= (select data from t2 where id = new.id);
 
create trigger t1_bu before update on t1 for each row
  set new.copy= (select data from t2 where id