1
################################################################################
2
# t/part_supported_sql_funcs_delete.inc #
5
# Delete access of the tests frame for allowed sql functions #
8
#------------------------------------------------------------------------------#
9
# Original Author: HH #
10
# Original Date: 2006-11-22 #
14
################################################################################
15
--echo -------------------------------------------------------------------------
16
--echo --- Delete rows and partitions of tables with $sqlfunc
17
--echo -------------------------------------------------------------------------
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;
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;
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);
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;
46
if (!$drop_partition_not_supported)
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;
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;