← Back to branch summary

~vkolesnikov/pbxt/pbxt-preload-test-bug

« back to all changes in this revision

Viewing changes to pbxt/mysql-test-update/mysql-test/r/trigger-compat.result

  • Committer: paul-mccullagh
  • Date: 2008-03-10 11:36:34 UTC
  • Revision ID: paul-mccullagh-417ebf175a9c8ee6e5b3777d9e2398e1fb197391
Implemented full durability

Show diffs side-by-side

added added

removed removed

Lines of Context:
pbxt/mysql-test-update/mysql-test/r/trigger-compat.result
32
32
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.
33
33
 
34
34
SELECT * FROM INFORMATION_SCHEMA.TRIGGERS ORDER BY trigger_name;
35
 
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
36
 
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            
37
 
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
 
35
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
 
36
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                    latin1  latin1_swedish_ci       latin1_swedish_ci
 
37
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 latin1  latin1_swedish_ci       latin1_swedish_ci
38
38
DROP TRIGGER wl2818_trg1;
39
39
Warnings:
40
40
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.