Debian Codegraph @

mysql-test/suite/ndb/t/ndb_fully_replicated_triggers.test

raw
1 ### This test checks whether limiting the number of concurrent ###
2 ### trigger operations with fully replicated trigers ###
3
4 -- source include/have_ndb.inc
5
6 ## Test fully replicated triggers
7
8 CREATE TABLE t1 (
9 a char(10) NOT NULL primary key,
10 b int not null,
11 unique (b)
12 ) comment='NDB_TABLE=FULLY_REPLICATED=1' ENGINE=ndbcluster;
13
14 let $max_rows = 1000;
15
16 --echo Fill tables
17 --disable_query_log
18 let $loops = $max_rows;
19 while ($loops)
20 {
21 eval insert into t1 values ($loops, $loops);
22 dec $loops;
23 }
24 --enable_query_log
25
26 eval update t1 set b=b+$max_rows;
27 select count(*) from t1;
28
29 delete from t1;
30 select count(*) from t1;
31
32 drop table t1;
33