Adding upstream version 1:10.11.6.upstream/1%10.11.6

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 45 insertions, 0 deletions

diff --git a/mysql-test/suite/parts/inc/partition_trigg2.inc b/mysql-test/suite/parts/inc/partition_trigg2.inc
new file mode 100644
index 00000000..2849ca21
--- /dev/null
+++ b/mysql-test/suite/parts/inc/partition_trigg2.inc
@@ -0,0 +1,45 @@
+################################################################################
+# inc/partition_trigg2.inc                                                     #
+#                                                                              #
+# Purpose:                                                                     #
+#   Auxiliary script, only useful when sourced by inc/partition_check.inc.     #
+#   The trigger uses new values (--> event UPDATE, INSERT only)                #
+#                                                                              #
+# 1. Create a trigger                                                          #
+# 2. Execute a statement, which activates the trigger                          #
+# 3. Check the results of the trigger activity                                 #
+# 4. Revert the modifications                                                  #
+#                                                                              #
+#------------------------------------------------------------------------------#
+# Original Author: mleich                                                      #
+# Original Date: 2006-03-05                                                    #
+# Change Author:                                                               #
+# Change Date:                                                                 #
+# Change:                                                                      #
+################################################################################
+
+delimiter |;
+eval CREATE TRIGGER trg_2 $event ON t1 FOR EACH ROW
+BEGIN
+   SET new.f_int1 = $source.f_int1 + @max_row,
+       new.f_int2 = $source.f_int2 - @max_row,
+       new.f_charbig = '####updated per update trigger####';
+END|
+delimiter ;|
+eval $statement;
+#      Check of preceding statement via Select
+if ($no_debug)
+{
+  --disable_query_log
+}
+eval SELECT '# check trigger-$num success: ' AS "", COUNT(*) = 0 AS "" FROM t1
+WHERE f_int1 - CAST(f_char1 AS SIGNED INT) NOT IN (@max_row, 2 * @max_row)
+   OR f_int2 - CAST(f_char1 AS SIGNED INT) NOT IN (-@max_row, - 2 * @max_row)
+   OR f_charbig <> '####updated per update trigger####';
+--enable_query_log
+DROP TRIGGER trg_2;
+# Revert the changes
+eval UPDATE t1 SET f_int1 = CAST(f_char1 AS SIGNED INT),
+              f_int2 = CAST(f_char1 AS SIGNED INT),
+              f_charbig = CONCAT('===',f_char1,'===');
+inc $num;