Debian Codegraph @

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

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