Debian Codegraph @

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

raw
1 ################################################################################
2 # inc/partition_trigg1.inc #
3 # #
4 # Purpose: #
5 # Auxiliary script, only useful when sourced by inc/partition_check.inc. #
6 # One trigger uses new values (--> event UPDATE, INSERT only) #
7 # One trigger uses old values (--> event UPDATE, DELETE only) #
8 # #
9 # 1. Create a trigger #
10 # 2. Execute a statement, which activates the trigger #
11 # 3. Check the results of the trigger activity #
12 # 4. Revert the modifications #
13 # #
14 #------------------------------------------------------------------------------#
15 # Original Author: mleich #
16 # Original Date: 2006-03-05 #
17 # Change Author: #
18 # Change Date: #
19 # Change: #
20 ################################################################################
21
22 # Test for operations, which have new values (INSERT+UPDATE, but not DELETE)
23 if ($no_debug)
24 {
25 --disable_query_log
26 }
27 --disable_cursor_protocol
28 eval SELECT INSTR('$statement','DELETE') = 0 INTO @aux;
29 --enable_cursor_protocol
30 let $run1= `SELECT @aux`;
31 --enable_query_log
32 if ($run1)
33 {
34 # Insert three records which are only needed for UPDATE TRIGGER test
35 eval INSERT INTO $tab_has_trigg(f_int1,f_int2,f_char1,f_char2,f_charbig)
36 SELECT -f_int1,-f_int1,CAST(-f_int1 AS CHAR),CAST(-f_int1 AS CHAR),
37 'just inserted' FROM t0_template
38 WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1;
39 delimiter |;
40 eval CREATE TRIGGER trg_1 $event ON $tab_has_trigg FOR EACH ROW
41 BEGIN
42 UPDATE $tab_in_trigg SET f_int1 = -f_int1, f_int2 = -f_int2,
43 f_charbig = 'updated by trigger'
44 WHERE f_int1 = new.f_int1;
45 END|
46 delimiter ;|
47
48 eval $statement;
49
50 # Check of preceding statement via Select
51 if ($no_debug)
52 {
53 --disable_query_log
54 }
55 eval SELECT '# check trigger-$num success: ' AS "", COUNT(*) = 3 AS ""
56 FROM $tab_in_trigg
57 WHERE f_int1 = f_int2 AND CAST(f_char1 AS SIGNED INT) = -f_int1;
58 --enable_query_log
59
60 DROP TRIGGER trg_1;
61
62 # Revert the changes
63 eval UPDATE $tab_in_trigg SET f_int1 = CAST(f_char1 AS SIGNED INT),
64 f_int2 = CAST(f_char1 AS SIGNED INT),
65 f_charbig = 'just inserted'
66 WHERE f_int1 <> CAST(f_char1 AS SIGNED INT);
67 eval DELETE FROM $tab_has_trigg
68 WHERE ABS(f_int1) BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1;
69 inc $num;
70 }
71
72 # Test for operations, which have old values (UPDATE+DELETE, but not INSERT)
73 if ($no_debug)
74 {
75 --disable_query_log
76 }
77 --disable_cursor_protocol
78 eval SELECT INSTR('$statement','INSERT') = 0 INTO @aux;
79 --enable_cursor_protocol
80 let $run1= `SELECT @aux`;
81 --enable_query_log
82 if ($run1)
83 {
84 # Insert three records which are only needed for UPDATE/DELETE TRIGGER test
85 eval INSERT INTO $tab_has_trigg(f_int1,f_int2,f_char1,f_char2,f_charbig)
86 SELECT -f_int1,-f_int1,CAST(-f_int1 AS CHAR),CAST(-f_int1 AS CHAR),
87 'just inserted' FROM t0_template
88 WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1;
89
90 delimiter |;
91 eval CREATE TRIGGER trg_1 $event ON $tab_has_trigg FOR EACH ROW
92 BEGIN
93 UPDATE $tab_in_trigg SET f_int1 = -f_int1, f_int2 = -f_int2,
94 f_charbig = 'updated by trigger'
95 WHERE f_int1 = - old.f_int1;
96 END|
97 delimiter ;|
98
99 eval $statement;
100
101 # Check of preceding statement via Select
102 if ($no_debug)
103 {
104 --disable_query_log
105 }
106 eval SELECT '# check trigger-$num success: ' AS "", COUNT(*) = 3 AS ""
107 FROM $tab_in_trigg
108 WHERE f_int1 = f_int2 AND CAST(f_char1 AS SIGNED INT) = -f_int1;
109 --enable_query_log
110 DROP TRIGGER trg_1;
111 # Revert the changes
112 eval UPDATE $tab_in_trigg SET f_int1 = CAST(f_char1 AS SIGNED INT),
113 f_int2 = CAST(f_char1 AS SIGNED INT),
114 f_charbig = 'just inserted'
115 WHERE f_int1 <> CAST(f_char1 AS SIGNED INT);
116 eval DELETE FROM $tab_has_trigg
117 WHERE ABS(f_int1) BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1;
118 inc $num;
119 }