Debian Codegraph @

mysql-test/suite/ndb/t/ndb_dbug_tc_select_1.inc

raw
1
2 eval create table t1(
3 a $type1,
4 b $type2,
5 c int,
6 primary key(a),
7 unique(b)
8 ) charset latin1 engine ndb;
9 --exec $NDB_MGM -e "all error 8072" >> $NDB_TOOLS_OUTPUT
10
11 --echo # verify tc select on insert using simple int key
12 --disable_query_log
13 --disable_result_log
14 let $i= 100;
15 let $j= 1;
16 while ($i)
17 {
18 --eval insert into t1 values ("$i","$j",0)
19 dec $i;
20 inc $j;
21 }
22 --enable_query_log
23 --enable_result_log
24
25 --echo # verify tc select on select using simple pk int key
26 --disable_query_log
27 --disable_result_log
28 let $i= 100;
29 while ($i)
30 {
31 --eval select * from t1 where a="$i"
32 dec $i;
33 }
34
35 --enable_query_log
36 --enable_result_log
37
38 --echo # verify tc select on select using simple unique int key
39 --disable_query_log
40 --disable_result_log
41 let $i= 100;
42 while ($i)
43 {
44 --eval select * from t1 where b="$i"
45 dec $i;
46 }
47 --enable_query_log
48 --enable_result_log
49
50 --echo # verify tc select on update using simple pk int key
51 --disable_query_log
52 --disable_result_log
53 let $i= 100;
54 while ($i)
55 {
56 --eval update t1 set c="10" where a="$i"
57 dec $i;
58 }
59 --enable_query_log
60 --enable_result_log
61
62 --echo # verify tc select on update using simple unique int key
63 --disable_query_log
64 --disable_result_log
65 let $i= 100;
66 while ($i)
67 {
68 --eval update t1 set c="11" where b="$i"
69 dec $i;
70 }
71 --enable_query_log
72 --enable_result_log
73
74 --echo # verify tc select on delete using simple pk int key
75 --disable_query_log
76 --disable_result_log
77 let $i= 40;
78 while ($i)
79 {
80 --eval delete from t1 where a="$i"
81 dec $i;
82 }
83 --enable_query_log
84 --enable_result_log
85
86 --echo # verify tc select on delete using simple unique int key
87 --disable_query_log
88 --disable_result_log
89 let $i= 40;
90 while ($i)
91 {
92 --eval delete from t1 where b="$i"
93 dec $i;
94 }
95 --enable_query_log
96 --enable_result_log
97
98 --echo # Cleanup
99 --exec $NDB_MGM -e "all error 0" >> $NDB_TOOLS_OUTPUT
100 drop table t1;