Debian Codegraph @

mysql-test/suite/ndb/r/ndb_err899.result

raw
1 check COMMIT behaviour with out-of-order signals and single delete
2 record DBTUP resource usage before test
3 CREATE TABLE test.t1 (a int primary key, b int) engine=ndb;
4 INSERT INTO test.t1 values (101,101), (202,202);
5 BEGIN;
6 SELECT * FROM test.t1 where a=101 FOR UPDATE;
7 a b
8 101 101
9 UPDATE test.t1 SET b=101 where a=101;
10 DELETE FROM test.t1 where a=101;
11 COMMIT;
12 drop table test.t1;
13 compare current DBTUP resource usage w/usage before test to check for leaks
14 check COMMIT behaviour with out-of-order signals and multiple deletes
15 record DBTUP resource usage before test
16 CREATE TABLE test.t1 (a int primary key, b int) engine=ndb;
17 INSERT INTO test.t1 values (101,101), (202,202);
18 BEGIN;
19 SELECT * FROM test.t1 where a=101 FOR UPDATE;
20 a b
21 101 101
22 DELETE FROM test.t1 where a=101;
23 INSERT INTO test.t1 values (101,102);
24 UPDATE test.t1 SET b=101 where a=101;
25 DELETE FROM test.t1 where a=101;
26 COMMIT;
27 drop table test.t1;
28 compare current DBTUP resource usage w/usage before test to check for leaks
29 check COMMIT behaviour with concurrent reads
30 record DBTUP resource usage before test
31 CREATE TABLE test.t1 (a int primary key, b int) engine=ndb;
32 INSERT INTO test.t1 values (101,101), (202,202);
33 create procedure work(total int)
34 begin
35 set @x = 0;
36 repeat
37 select * from test.t1 where a=101;
38 set @x = @x + 1;
39 until @x = total
40 end repeat;
41 end%
42 call work(10000);;
43 BEGIN;
44 SELECT * FROM test.t1 where a=101 FOR UPDATE;
45 a b
46 101 101
47 DELETE FROM test.t1 where a=101;
48 INSERT INTO test.t1 values (101,102);
49 UPDATE test.t1 SET b=101 where a=101;
50 DELETE FROM test.t1 where a=101;
51 COMMIT;
52 drop procedure work;
53 drop table test.t1;
54 compare current DBTUP resource usage w/usage before test to check for leaks
55 check ABORT behaviour with out-of-order signals
56 record DBTUP resource usage before test
57 CREATE TABLE test.t1 (a int primary key, b int) engine=ndb;
58 INSERT INTO test.t1 values (101,101), (202,202);
59 BEGIN;
60 SELECT * FROM test.t1 where a=101 FOR UPDATE;
61 a b
62 101 101
63 DELETE FROM test.t1 where a=101;
64 INSERT INTO test.t1 values (101,102);
65 UPDATE test.t1 SET b=101 where a=101;
66 DELETE FROM test.t1 where a=101;
67 INSERT INTO test.t1 values (101,102);
68 ROLLBACK;
69 drop table test.t1;
70 compare current DBTUP resource usage w/usage before test to check for leaks
71