← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/suite/parts/inc/partition_trigg2.inc

  • Committer: brian
  • Date: 2008-06-29 12:50:19 UTC
  • mfrom: (12.1.4 drizzle)
  • Revision ID: brian@localhost.localdomain-20080629125019-qxk9qma8esphwwus
Committing merge

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/parts/inc/partition_trigg2.inc
1
 
################################################################################
2
 
# inc/partition_trigg2.inc                                                     #
3
 
#                                                                              #
4
 
# Purpose:                                                                     #
5
 
#   Auxiliary script, only useful when sourced by inc/partition_check.inc.     #
6
 
#   The trigger uses new values (--> event UPDATE, INSERT only)                #
7
 
#                                                                              #
8
 
# 1. Create a trigger                                                          #
9
 
# 2. Execute a statement, which activates the trigger                          #
10
 
# 3. Check the results of the trigger activity                                 #
11
 
# 4. Revert the modifications                                                  #
12
 
#                                                                              #
13
 
#------------------------------------------------------------------------------#
14
 
# Original Author: mleich                                                      #
15
 
# Original Date: 2006-03-05                                                    #
16
 
# Change Author:                                                               #
17
 
# Change Date:                                                                 #
18
 
# Change:                                                                      #
19
 
################################################################################
20
 
 
21
 
delimiter |;
22
 
eval CREATE TRIGGER trg_2 $event ON t1 FOR EACH ROW
23
 
BEGIN
24
 
   SET new.f_int1 = $source.f_int1 + @max_row,
25
 
       new.f_int2 = $source.f_int2 - @max_row,
26
 
       new.f_charbig = '####updated per update trigger####';
27
 
END|
28
 
delimiter ;|
29
 
eval $statement;
30
 
#      Check of preceding statement via Select
31
 
if ($no_debug)
32
 
{
33
 
  --disable_query_log
34
 
}
35
 
eval SELECT '# check trigger-$num success: ' AS "", COUNT(*) = 0 AS "" FROM t1
36
 
WHERE f_int1 - CAST(f_char1 AS SIGNED INT) NOT IN (@max_row, 2 * @max_row)
37
 
   OR f_int2 - CAST(f_char1 AS SIGNED INT) NOT IN (-@max_row, - 2 * @max_row)
38
 
   OR f_charbig <> '####updated per update trigger####';
39
 
--enable_query_log
40
 
DROP TRIGGER trg_2;
41
 
# Revert the changes
42
 
eval UPDATE t1 SET f_int1 = CAST(f_char1 AS SIGNED INT),
43
 
              f_int2 = CAST(f_char1 AS SIGNED INT),
44
 
              f_charbig = CONCAT('===',f_char1,'===');
45
 
inc $num;