Debian Codegraph @

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

raw
1 ################################################################################
2 # inc/partition_check_read1.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 # The parameter #
9 # @exp_row_count -- expected number of rows within t1 #
10 # must be set before sourcing this routine. #
11 # #
12 #------------------------------------------------------------------------------#
13 # Original Author: mleich #
14 # Original Date: 2006-04-11 #
15 # Change Author: #
16 # Change Date: #
17 # Change: #
18 ################################################################################
19
20 ## EXPLAIN PARTITIONS SELECT for one single row
21 EXPLAIN PARTITIONS SELECT COUNT(*) FROM t1 WHERE f_date = '1000-02-10';
22
23 ## Check SELECT for one single row
24 let $success= 1;
25 if ($no_debug)
26 {
27 --disable_query_log
28 }
29 --disable_cursor_protocol
30 SELECT COUNT(*) <> 1 INTO @aux FROM t1 WHERE f_date = '1000-02-10';
31 --enable_cursor_protocol
32 --enable_query_log
33 let $run= `SELECT @aux`;
34 if ($run)
35 {
36 --echo # Unexpected result on SELECT
37 eval SELECT COUNT(*) <> 1 FROM t1 WHERE f_date = '1000-02-10';
38 let $success= 0;
39 }
40 --echo # check read single success: $success
41
42 ## Read all existing records in one step
43 let $success= 1;
44 if ($no_debug)
45 {
46 --disable_query_log
47 }
48 --disable_cursor_protocol
49 eval SELECT COUNT(*) <> @exp_row_count INTO @aux FROM t1;
50 --enable_cursor_protocol
51 --enable_query_log
52 let $run= `SELECT @aux`;
53 if ($run)
54 {
55 --echo # Unexpected result on SELECT
56 eval SELECT COUNT(*) <> @exp_row_count FROM t1;
57 let $success= 0;
58 }
59 --echo # check read all success: $success
60
61 ## Read all existing records row by row
62 let $success= 1;
63 let $num= `SELECT @exp_row_count`;
64 while ($num)
65 {
66 if ($no_debug)
67 {
68 --disable_query_log
69 }
70 --disable_cursor_protocol
71 eval SELECT COUNT(*) <> 1 INTO @aux FROM t1
72 WHERE f_date = CONCAT(CAST(999 + $num AS CHAR),'-02-10');
73 --enable_cursor_protocol
74 --enable_query_log
75 let $run= `SELECT @aux`;
76 if ($run)
77 {
78 --echo # Unexpected result on SELECT
79 eval SELECT COUNT(*) <> 1 FROM t1
80 WHERE f_date = CONCAT(CAST(999 + $num AS CHAR),'-02-10');
81 let $success= 0;
82 }
83 dec $num;
84 }
85 --echo # check read row by row success: $success