Debian Codegraph @

mysql-test/suite/parts/inc/partition_check_read2.inc

raw
1 ################################################################################
2 # inc/partition_check_read2.inc #
3 # #
4 # Purpose: #
5 # Read rows from table t1 in different ways #
6 # This routine is only useful for the partition_<feature>_<engine> tests. #
7 # #
8 #------------------------------------------------------------------------------#
9 # Original Author: mleich #
10 # Original Date: 2006-04-11 #
11 # Change Author: #
12 # Change Date: #
13 # Change: #
14 ################################################################################
15
16 ## EXPLAIN PARTITIONS SELECT for one single row
17 EXPLAIN PARTITIONS SELECT COUNT(*) <> 1 FROM t1 WHERE f_int1 = 3;
18
19 ## Check SELECT for one single row
20 let $success= 1;
21 if ($no_debug)
22 {
23 --disable_query_log
24 }
25 --disable_cursor_protocol
26 SELECT COUNT(*) <> 1 INTO @aux FROM t1 WHERE f_int1 = 3;
27 --enable_cursor_protocol
28 --enable_query_log
29 let $run= `SELECT @aux`;
30 if ($run)
31 {
32 --echo # Unexpected result on SELECT
33 eval SELECT COUNT(*) <> 1 FROM t1 WHERE f_int1 = 3;
34 let $success= 0;
35 }
36 --echo # check read single success: $success
37
38 ## Read all existing records in one step
39 let $success= 1;
40 if ($no_debug)
41 {
42 --disable_query_log
43 }
44 --disable_cursor_protocol
45 eval SELECT COUNT(*) <> @max_row INTO @aux FROM t1;
46 --enable_cursor_protocol
47 --enable_query_log
48 let $run= `SELECT @aux`;
49 if ($run)
50 {
51 --echo # Unexpected result on SELECT
52 eval SELECT COUNT(*) <> @max_row FROM t1;
53 let $success= 0;
54 }
55 --echo # check read all success: $success
56
57 ## Read all existing records row by row
58 let $success= 1;
59 let $num= `SELECT @max_row`;
60 while ($num)
61 {
62 if ($no_debug)
63 {
64 --disable_query_log
65 }
66 --disable_cursor_protocol
67 eval SELECT COUNT(*) <> 1 INTO @aux FROM t1
68 WHERE f_int1 = 3;
69 --enable_cursor_protocol
70 --enable_query_log
71 let $run= `SELECT @aux`;
72 if ($run)
73 {
74 --echo # Unexpected result on SELECT
75 eval SELECT COUNT(*) <> 1 FROM t1
76 WHERE f_int1 = 3;
77 let $success= 0;
78 }
79 dec $num;
80 }
81 --echo # check read row by row success: $success