Debian Codegraph @

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

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