Debian Codegraph @

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

raw
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 begin;
20 eval delete from $t1 where col1=$val2;
21 eval delete from $t2 where col1=$val2;
22 eval delete from $t3 where col1=$val2;
23 eval delete from $t4 where col1=$val2;
24 eval delete from $t5 where col1=$val2;
25 eval delete from $t6 where col1=$val2;
26 commit;
27
28 eval select * from $t1 order by col1;
29 eval select * from $t2 order by col1;
30 eval select * from $t3 order by col1;
31 eval select * from $t4 order by colint;
32 eval select * from $t5 order by colint;
33
34 begin;
35 eval insert into $t1 values ($val2);
36 eval insert into $t2 values ($val2);
37 eval insert into $t3 values ($val2);
38 eval insert into $t4 values (60,$val2);
39 eval insert into $t5 values (60,$val2);
40 eval insert into $t6 values (60,$val2);
41 commit;
42
43 eval select * from $t1 order by col1;
44 eval select * from $t2 order by col1;
45 eval select * from $t3 order by col1;
46 eval select * from $t4 order by colint;
47 eval select * from $t5 order by colint;
48 eval select * from $t6 order by colint;
49
50 if (!$drop_partition_not_supported)
51 {
52 eval alter table $t1 drop partition p0;
53 eval alter table $t2 drop partition p0;
54 eval alter table $t4 drop partition p0;
55 eval alter table $t5 drop partition p0;
56 eval alter table $t6 drop partition p0;
57
58 eval select * from $t1 order by col1;
59 eval select * from $t2 order by col1;
60 eval select * from $t3 order by col1;
61 eval select * from $t4 order by colint;
62 eval select * from $t5 order by colint;
63 eval select * from $t6 order by colint;
64 }