Debian Codegraph @

mysql-test/suite/gcol_ndb/r/gcol_trigger_sp_ndb.result

raw
1 SET @@session.default_storage_engine = 'ndbcluster';
2 create table t1 (a int,
3 b int generated always as (a/10) virtual,
4 c int generated always as (a/10) stored);
5 create table t2 (a timestamp);
6 create trigger trg1 before insert on t1 for each row
7 begin
8 if (new.b < 10) then
9 set new.a:= 100;
10 set new.b:= 9;
11 set new.c:= 9;
12 end if;
13 if (new.c > 50) then
14 set new.a:= 500;
15 end if;
16 end|
17 create trigger trg2 after insert on t1 for each row
18 begin
19 if (new.b >= 60) then
20 insert into t2 values (now());
21 end if;
22 end|
23 create function f1()
24 returns int
25 begin
26 declare sum1 int default '0';
27 declare cur1 cursor for select sum(b) from t1;
28 open cur1;
29 fetch cur1 into sum1;
30 close cur1;
31 return sum1;
32 end|
33 set sql_warnings = 1;
34 insert into t1 (a) values (200);
35 select * from t1;
36 a b c
37 200 20 20
38 select * from t2;
39 a
40 insert into t1 (a) values (10);
41 select * from t1;
42 a b c
43 100 10 10
44 200 20 20
45 select * from t2;
46 a
47 insert into t1 (a) values (600);
48 select * from t1;
49 a b c
50 100 10 10
51 200 20 20
52 500 50 50
53 select * from t2;
54 a
55 select f1();
56 f1()
57 80
58 set sql_warnings = 0;
59 drop trigger trg1;
60 drop trigger trg2;
61 drop table t2;
62 create procedure p1()
63 begin
64 declare i int default '0';
65 create table t2 like t1;
66 insert into t2 (a) values (100), (200);
67 begin
68 declare cur1 cursor for select sum(c) from t2;
69 open cur1;
70 fetch cur1 into i;
71 close cur1;
72 if (i=30) then
73 insert into t1 values (300,default,default);
74 end if;
75 end;
76 end|
77 delete from t1;
78 call p1();
79 select * from t2;
80 a b c
81 100 10 10
82 200 20 20
83 select * from t1;
84 a b c
85 300 30 30
86 drop table t1,t2;
87 drop procedure p1;
88 DROP VIEW IF EXISTS v1,v2;
89 DROP TABLE IF EXISTS t1,t2,t3;
90 DROP PROCEDURE IF EXISTS p1;
91 DROP FUNCTION IF EXISTS f1;
92 DROP TRIGGER IF EXISTS trg1;
93 DROP TRIGGER IF EXISTS trg2;
94 set sql_warnings = 0;