diff options
Diffstat (limited to 'mysql-test/suite/funcs_1/r/is_triggers.result')
| -rw-r--r-- | mysql-test/suite/funcs_1/r/is_triggers.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/suite/funcs_1/r/is_triggers.result b/mysql-test/suite/funcs_1/r/is_triggers.result index d9ba88cba5a..6cfcd1718fe 100644 --- a/mysql-test/suite/funcs_1/r/is_triggers.result +++ b/mysql-test/suite/funcs_1/r/is_triggers.result @@ -110,6 +110,16 @@ ORDER BY trigger_schema, trigger_name; TRIGGER_CATALOG TRIGGER_SCHEMA TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_CATALOG EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_ORDER ACTION_CONDITION ACTION_STATEMENT ACTION_ORIENTATION ACTION_TIMING ACTION_REFERENCE_OLD_TABLE ACTION_REFERENCE_NEW_TABLE ACTION_REFERENCE_OLD_ROW ACTION_REFERENCE_NEW_ROW CREATED SQL_MODE DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION def mtr gs_insert INSERT def mtr global_suppressions 1 NULL BEGIN DECLARE dummy INT; SELECT "" REGEXP NEW.pattern INTO dummy; END ROW BEFORE NULL NULL OLD NEW # root@localhost latin1 latin1_swedish_ci latin1_swedish_ci def mtr ts_insert INSERT def mtr test_suppressions 1 NULL BEGIN DECLARE dummy INT; SELECT "" REGEXP NEW.pattern INTO dummy; END ROW BEFORE NULL NULL OLD NEW # root@localhost latin1 latin1_swedish_ci latin1_swedish_ci +def sys sys_config_insert_set_user INSERT def sys sys_config 1 NULL BEGIN + IF @sys.ignore_sys_config_triggers != true AND NEW.set_by IS NULL THEN + SET NEW.set_by = USER(); + END IF; +END ROW BEFORE NULL NULL OLD NEW # root@localhost utf8 utf8_general_ci utf8_general_ci +def sys sys_config_update_set_user UPDATE def sys sys_config 1 NULL BEGIN + IF @sys.ignore_sys_config_triggers != true AND NEW.set_by IS NULL THEN + SET NEW.set_by = USER(); + END IF; +END ROW BEFORE NULL NULL OLD NEW # root@localhost utf8 utf8_general_ci utf8_general_ci ################################################################################## # Testcase 3.2.18.2 + 3.2.18.3: INFORMATION_SCHEMA.TRIGGERS accessible information ################################################################################## |