diff options
author | unknown <msvensson@pilot.mysql.com> | 2006-12-22 00:39:08 +0100 |
---|---|---|
committer | unknown <msvensson@pilot.mysql.com> | 2006-12-22 00:39:08 +0100 |
commit | 1acf0e78d7c477220c9b04fe6a79b1ae506a3262 (patch) | |
tree | 07c5b5c424845f49a432c1931fce67e856a590d0 /mysql-test/t/trigger.test | |
parent | af47c2806b01b89d6443ee565155bfdc6f838815 (diff) | |
parent | b461c41cd3f2b6ff6a5ce757b5d708916be85959 (diff) | |
download | mariadb-git-1acf0e78d7c477220c9b04fe6a79b1ae506a3262.tar.gz |
Merge pilot.mysql.com:/home/msvensson/mysql/mysql-5.0-maint
into pilot.mysql.com:/home/msvensson/mysql/mysql-5.1-new-maint
include/mysql_h.ic:
Auto merged
mysql-test/t/mysqltest.test:
Auto merged
mysql-test/t/rpl_rotate_logs.test:
Auto merged
mysql-test/t/trigger.test:
Auto merged
vio/viossl.c:
Auto merged
Diffstat (limited to 'mysql-test/t/trigger.test')
-rw-r--r-- | mysql-test/t/trigger.test | 14 |
1 files changed, 10 insertions, 4 deletions
diff --git a/mysql-test/t/trigger.test b/mysql-test/t/trigger.test index 12262894e5b..4d5479a51c9 100644 --- a/mysql-test/t/trigger.test +++ b/mysql-test/t/trigger.test @@ -1,3 +1,7 @@ +# This test uses chmod, can't be run with root permissions +-- source include/not_as_root.inc + + # # Basic triggers test # @@ -1138,8 +1142,10 @@ select trigger_schema, trigger_name, event_object_schema, event_object_table, action_statement from information_schema.triggers where event_object_schema = 'test'; # Trick which makes update of second .TRN file impossible -system echo dummy >$MYSQLTEST_VARDIR/master-data/test/t1_ai.TRN~; -system chmod 000 $MYSQLTEST_VARDIR/master-data/test/t1_ai.TRN~; +write_file $MYSQLTEST_VARDIR/master-data/test/t1_ai.TRN~; +dummy +EOF +chmod 0000 $MYSQLTEST_VARDIR/master-data/test/t1_ai.TRN~; --error 1 rename table t1 to t2; # 't1' should be still there and triggers should work correctly @@ -1148,8 +1154,8 @@ select @a, @b; select trigger_schema, trigger_name, event_object_schema, event_object_table, action_statement from information_schema.triggers where event_object_schema = 'test'; -system chmod 600 $MYSQLTEST_VARDIR/master-data/test/t1_ai.TRN~; -system rm $MYSQLTEST_VARDIR/master-data/test/t1_ai.TRN~; +chmod 0600 $MYSQLTEST_VARDIR/master-data/test/t1_ai.TRN~; +remove_file $MYSQLTEST_VARDIR/master-data/test/t1_ai.TRN~; # Let us check that updates to .TRN files were rolled back too drop trigger t1_bi; drop trigger t1_ai; |