Debian Codegraph @

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

raw
1 # Helper for checking cost of statement
2 # execution
3 # Parameters
4 # $tablename
5 # $valCol1
6 # $valCol2
7 # $sql_statement
8
9 # Preparation
10 --disable_query_log
11 --disable_result_log
12 eval delete from $tablename;
13
14 if (!$valCol2)
15 {
16 --let $short_ins = repeat("B",20)
17 --let $long_ins = repeat("J", 5000)
18 }
19 if ($valCol2)
20 {
21 --let $short_ins = repeat("C",20), repeat("T", 20)
22 --let $long_ins = repeat("S", 5000), repeat("G", 5000)
23 }
24 eval insert into $tablename values
25 ("Short1", $short_ins),
26 ("Short2", $short_ins),
27 ("Short3", $short_ins),
28 ("Long1", $long_ins),
29 ("Long2", $long_ins),
30 ("Long3", $long_ins);
31
32 --enable_query_log
33 --enable_result_log
34
35 # Now run the statement
36 --source suite/ndb/include/ndb_init_api_counts.inc
37 --eval $sql_statement
38 --source suite/ndb/include/ndb_diff_api_counts.inc
39
40 --disable_query_log
41 --disable_result_log
42 commit;
43 --enable_query_log
44 --enable_result_log