~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/suite/funcs_1/triggers/triggers_03e_transaction.inc

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
40
40
        select current_user;
41
41
        use priv_db;
42
42
        set autocommit=0;
43
 
        create definer=current_user trigger trg1_1 
 
43
        create definer=current_user trigger trg1_1
44
44
                before INSERT on t1 for each row
45
45
                set new.f1 = 'trig 1_1-yes';
46
46
        rollback work;
56
56
        commit work;
57
57
        drop trigger trg1_1;
58
58
        rollback work;
59
 
        --error 1360
 
59
        --error ER_TRG_DOES_NOT_EXIST
60
60
        drop trigger trg1_1;
61
61
        drop trigger trg1_2;
62
62
        commit work;
74
74
        --enable_warnings
75
75
 
76
76
 
77
 
# general Cleanup 
 
77
# general Cleanup
78
78
        --disable_warnings
79
79
        drop database if exists priv_db;
80
80
        drop user test_yesprivs@localhost;