MySQL 5.6.14 Source Code Document
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Groups Pages
part_supported_sql_funcs_delete.inc
1 ################################################################################
2 # t/part_supported_sql_funcs_delete.inc #
3 # #
4 # Purpose: #
5 # Delete access of the tests frame for allowed sql functions #
6 # #
7 # #
8 #------------------------------------------------------------------------------#
9 # Original Author: HH #
10 # Original Date: 2006-11-22 #
11 # Change Author: #
12 # Change Date: #
13 # Change: #
14 ################################################################################
15 --echo -------------------------------------------------------------------------
16 --echo --- Delete rows and partitions of tables with $sqlfunc
17 --echo -------------------------------------------------------------------------
18 
19 eval delete from $t1 where col1=$val2;
20 eval delete from $t2 where col1=$val2;
21 eval delete from $t3 where col1=$val2;
22 eval delete from $t4 where col1=$val2;
23 eval delete from $t5 where col1=$val2;
24 eval delete from $t6 where col1=$val2;
25 
26 eval select * from $t1 order by col1;
27 eval select * from $t2 order by col1;
28 eval select * from $t3 order by col1;
29 eval select * from $t4 order by colint;
30 eval select * from $t5 order by colint;
31 
32 eval insert into $t1 values ($val2);
33 eval insert into $t2 values ($val2);
34 eval insert into $t3 values ($val2);
35 eval insert into $t4 values (60,$val2);
36 eval insert into $t5 values (60,$val2);
37 eval insert into $t6 values (60,$val2);
38 
39 eval select * from $t1 order by col1;
40 eval select * from $t2 order by col1;
41 eval select * from $t3 order by col1;
42 eval select * from $t4 order by colint;
43 eval select * from $t5 order by colint;
44 eval select * from $t6 order by colint;
45 
46 if (!$drop_partition_not_supported)
47 {
48 eval alter table $t1 drop partition p0;
49 eval alter table $t2 drop partition p0;
50 eval alter table $t4 drop partition p0;
51 eval alter table $t5 drop partition p0;
52 eval alter table $t6 drop partition p0;
53 
54 eval select * from $t1 order by col1;
55 eval select * from $t2 order by col1;
56 eval select * from $t3 order by col1;
57 eval select * from $t4 order by colint;
58 eval select * from $t5 order by colint;
59 eval select * from $t6 order by colint;
60 }