diff options
author | msvensson@neptunus.(none) <> | 2006-01-27 10:49:07 +0100 |
---|---|---|
committer | msvensson@neptunus.(none) <> | 2006-01-27 10:49:07 +0100 |
commit | 54af4e6d0caeff51b7d7541af18c06d1a99be974 (patch) | |
tree | ef0edf4b9c14460884d85ebaa6212e67e892a336 /mysql-test/r/trigger-compat.result | |
parent | a98ede7edc48812113619ccf21389994e58b8332 (diff) | |
parent | 9304785c10c8cbf168b07e41c149f9f938c30428 (diff) | |
download | mariadb-git-54af4e6d0caeff51b7d7541af18c06d1a99be974.tar.gz |
Merge neptunus.(none):/home/msvensson/mysql/mysqltestrun_check_testcases/my50-mysqltestrun_check_testcases
into neptunus.(none):/home/msvensson/mysql/mysqltest_var/my50-mysqltest_var-integration
Diffstat (limited to 'mysql-test/r/trigger-compat.result')
-rw-r--r-- | mysql-test/r/trigger-compat.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/trigger-compat.result b/mysql-test/r/trigger-compat.result index 7721a55449b..6839cacab43 100644 --- a/mysql-test/r/trigger-compat.result +++ b/mysql-test/r/trigger-compat.result @@ -36,3 +36,13 @@ SELECT * FROM INFORMATION_SCHEMA.TRIGGERS ORDER BY 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 NULL mysqltest_db1 wl2818_trg1 INSERT NULL mysqltest_db1 t1 0 NULL INSERT INTO t2 VALUES(CURRENT_USER()) ROW BEFORE NULL NULL OLD NEW NULL NULL mysqltest_db1 wl2818_trg2 INSERT NULL mysqltest_db1 t1 0 NULL INSERT INTO t2 VALUES(CURRENT_USER()) ROW AFTER NULL NULL OLD NEW NULL mysqltest_dfn@localhost +DROP TRIGGER wl2818_trg1; +Warnings: +Warning 1454 No definer attribute for trigger 'mysqltest_db1'.'wl2818_trg1'. The trigger will be activated under the authorization of the invoker, which may have insufficient privileges. Please recreate the trigger. +DROP TRIGGER wl2818_trg2; +use mysqltest_db1; +DROP TABLE t1; +DROP TABLE t2; +DROP USER mysqltest_dfn@localhost; +DROP USER mysqltest_inv@localhost; +DROP DATABASE mysqltest_db1; |