shangyanwen

### Describe the problem ``` create table t1 (i int)engine=tianmu; insert into t1 values (1),(2),(3),(4); create trigger trg after update on t1 for each row set @total_change:=@total_change + new.i -...

bug: incorrect result set.Before delete trigger,Does not take effect

1

### Describe the problem ``` create table t1 (i int)engine=tianmu; insert into t1 values (1),(2),(3),(4); create trigger trg before delete on t1 for each row set @del_sum:= @del_sum + old.i;...

bug: incorrect result set.After delete trigger,Does not take effect

1

### Describe the problem ``` create table t1 (i int)engine=tianmu; insert into t1 values (1),(2),(3),(4); create trigger trg after delete on t1 for each row set @del:= 1; set @del:=...

### Describe the problem ``` create table t1 (id int primary key, fk_t2 int)engine=tianmu; create table t2 (id int primary key, fk_t3 int)engine=tianmu; create table t3 (id int primary key)engine=tianmu;...

### Describe the problem ``` create table t1 (id int primary key, copy int)engine=tianmu; create table t2 (id int primary key, data int)engine=tianmu; insert into t2 values (1,1), (2,2); create...

### Describe the problem ``` SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; CREATE TABLE t1 ( id int NOT NULL DEFAULT '0', a varchar(10) NOT NULL, b varchar(10), c varchar(10), d timestamp NOT...

### Describe the problem ``` CREATE TABLE t1 (a INT, b INT DEFAULT 150)engine=tianmu; delimiter | CREATE TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW BEGIN CREATE TEMPORARY TABLE...

### Describe the problem ``` create table t1 (f1 int)engine=tianmu; create table t2 (ff1 int unique, ff2 int default 1)engine=tianmu; insert into t1 values (1),(1),(2); insert into t2(ff1) select f1...

**Is your feature request related to a problem? Please describe.** **Describe the solution you'd like** **Describe alternatives you've considered** **Additional context**

Do you intend to add a full test workflow for StoneDB? (install StoneDB, run test, etc.)

3

https://github.com/stoneatom/stonedb