Debian Codegraph @

mysql-test/suite/galera/r/MDEV-33828.result

raw
1 connection node_2;
2 connection node_1;
3 SET AUTOCOMMIT=ON;
4 SELECT @@autocommit;
5 @@autocommit
6 1
7 SET LOCAL enforce_storage_engine=InnoDB;
8 CREATE TABLE t1(id int not null primary key auto_increment, name varchar(64)) ENGINE=InnoDB;
9 INSERT INTO t1(name) VALUES ('name1'),('name3'),('name6'),('name2');
10 CREATE PROCEDURE sel_proc()
11 BEGIN
12 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
13 SELECT * FROM t1;
14 END|
15 CREATE PROCEDURE ins_proc()
16 BEGIN
17 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
18 INSERT INTO t1 VALUES ('name_proc');
19 END|
20 SET AUTOCOMMIT=OFF;
21 SELECT @@autocommit;
22 @@autocommit
23 0
24 START TRANSACTION;
25 insert into t1(name) values('name10');
26 select param_list, returns, db, type from mysql.proc where name='sel_proc';
27 param_list returns db type
28 test PROCEDURE
29 call ins_proc();
30 COMMIT;
31 SET AUTOCOMMIT=ON;
32 SELECT * FROM t1;
33 id name
34 1 name1
35 3 name3
36 5 name6
37 7 name2
38 9 name10
39 DROP TABLE t1;
40 DROP PROCEDURE sel_proc;
41 DROP PROCEDURE ins_proc;