Debian Codegraph @

mysql-test/suite/rpl_ndb/r/rpl_ndb_sp003.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 DROP PROCEDURE IF EXISTS test.p1;
7 DROP PROCEDURE IF EXISTS test.p2;
8 DROP TABLE IF EXISTS test.t1;
9 CREATE TABLE test.t1(a INT,PRIMARY KEY(a))ENGINE=NDBCLUSTER;
10 CREATE PROCEDURE test.p1()
11 BEGIN
12 INSERT INTO test.t1 VALUES (4);
13 SELECT get_lock("test", 100);
14 UPDATE test.t1 set a=a+4 WHERE a=4;
15 END|
16 CREATE PROCEDURE test.p2()
17 BEGIN
18 UPDATE test.t1 SET a=a+1;
19 END|
20 SELECT get_lock("test", 200);
21 get_lock("test", 200)
22 1
23 CALL test.p1();
24 CALL test.p2();
25 SELECT release_lock("test");
26 release_lock("test")
27 1
28 get_lock("test", 100)
29 1
30 SELECT release_lock("test");
31 release_lock("test")
32 1
33 SELECT * FROM test.t1;
34 a
35 5
36 include/sync_slave_sql_with_master.inc
37 SELECT * FROM test.t1;
38 a
39 5
40 DROP TABLE IF EXISTS test.t1;
41 CREATE TABLE test.t1(a INT,PRIMARY KEY(a))ENGINE=NDBCLUSTER;
42 CALL test.p2();
43 CALL test.p1();
44 get_lock("test", 100)
45 1
46 SELECT release_lock("test");
47 release_lock("test")
48 1
49 SELECT * FROM test.t1;
50 a
51 8
52 include/sync_slave_sql_with_master.inc
53 SELECT * FROM test.t1;
54 a
55 8
56 DROP PROCEDURE IF EXISTS test.p1;
57 DROP PROCEDURE IF EXISTS test.p2;
58 DROP TABLE IF EXISTS test.t1;
59 include/sync_slave_sql_with_master.inc
60 include/rpl_end.inc