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 -- disable_query_log
21 -- disable_result_log
22 ANALYZE TABLE t1;
23 -- enable_result_log
24 -- enable_query_log
25
26 ## EXPLAIN SELECT for one single row
27 EXPLAIN SELECT COUNT(*) FROM t1 WHERE f_date = '1000-02-10';
28
29 ## Check SELECT for one single row
30 let $success= 1;
31 if ($no_debug)
32 {
33 --disable_query_log
34 }
35 SELECT COUNT(*) <> 1 INTO @aux FROM t1 WHERE f_date = '1000-02-10';
36 --enable_query_log
37 let $run= `SELECT @aux`;
38 if ($run)
39 {
40 --echo # Unexpected result on SELECT
41 eval SELECT COUNT(*) <> 1 FROM t1 WHERE f_date = '1000-02-10';
42 let $success= 0;
43 }
44 --echo # check read single success: $success
45
46 ## Read all existing records in one step
47 let $success= 1;
48 if ($no_debug)
49 {
50 --disable_query_log
51 }
52 eval SELECT COUNT(*) <> @exp_row_count INTO @aux FROM t1;
53 --enable_query_log
54 let $run= `SELECT @aux`;
55 if ($run)
56 {
57 --echo # Unexpected result on SELECT
58 eval SELECT COUNT(*) <> @exp_row_count FROM t1;
59 let $success= 0;
60 }
61 --echo # check read all success: $success
62
63 ## Read all existing records row by row
64 let $success= 1;
65 let $num= `SELECT @exp_row_count`;
66 while ($num)
67 {
68 if ($no_debug)
69 {
70 --disable_query_log
71 }
72 eval SELECT COUNT(*) <> 1 INTO @aux FROM t1
73 WHERE f_date = CONCAT(CAST(999 + $num AS CHAR),'-02-10');
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