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 -- disable_query_log
17 -- disable_result_log
18 ANALYZE TABLE t1;
19 -- enable_result_log
20 -- enable_query_log
21
22 ## EXPLAIN SELECT for one single row
23 EXPLAIN SELECT COUNT(*) <> 1 FROM t1 WHERE f_int1 = 3;
24
25 ## Check SELECT for one single row
26 let $success= 1;
27 if ($no_debug)
28 {
29 --disable_query_log
30 }
31 SELECT COUNT(*) <> 1 INTO @aux FROM t1 WHERE f_int1 = 3;
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_int1 = 3;
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 eval SELECT COUNT(*) <> @max_row INTO @aux FROM t1;
49 --enable_query_log
50 let $run= `SELECT @aux`;
51 if ($run)
52 {
53 --echo # Unexpected result on SELECT
54 eval SELECT COUNT(*) <> @max_row FROM t1;
55 let $success= 0;
56 }
57 --echo # check read all success: $success
58
59 ## Read all existing records row by row
60 let $success= 1;
61 let $num= `SELECT @max_row`;
62 while ($num)
63 {
64 if ($no_debug)
65 {
66 --disable_query_log
67 }
68 eval SELECT COUNT(*) <> 1 INTO @aux FROM t1
69 WHERE f_int1 = 3;
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