summaryrefslogtreecommitdiff
path: root/mysql-test/t/trigger-grant.test
diff options
context:
space:
mode:
authorunknown <msvensson@pilot.blaudden>2007-02-24 08:18:57 +0100
committerunknown <msvensson@pilot.blaudden>2007-02-24 08:18:57 +0100
commitf80babd61720298f8e3862f21b1851203cbcf871 (patch)
tree69650fc4b246ec36bb9f6d4f2e7e3659551fbc56 /mysql-test/t/trigger-grant.test
parentd1351a6dd8de5b50d8c031658570f2654983411c (diff)
downloadmariadb-git-f80babd61720298f8e3862f21b1851203cbcf871.tar.gz
Replace non portable system commmands in trigger-grant
Diffstat (limited to 'mysql-test/t/trigger-grant.test')
-rw-r--r--mysql-test/t/trigger-grant.test16
1 files changed, 13 insertions, 3 deletions
diff --git a/mysql-test/t/trigger-grant.test b/mysql-test/t/trigger-grant.test
index 12b929898a8..53062dbc270 100644
--- a/mysql-test/t/trigger-grant.test
+++ b/mysql-test/t/trigger-grant.test
@@ -232,9 +232,19 @@ CREATE TRIGGER trg5 BEFORE DELETE ON t1
FOR EACH ROW
SET @a = 5;
---system grep -v '^definers=' $MYSQLTEST_VARDIR/master-data/mysqltest_db1/t1.TRG > $MYSQLTEST_VARDIR/tmp/t1.TRG
---system echo "definers='' '@' '@abc@def@@' '@hostname' '@abcdef@@@hostname'" >> $MYSQLTEST_VARDIR/tmp/t1.TRG
---system mv $MYSQLTEST_VARDIR/tmp/t1.TRG $MYSQLTEST_VARDIR/master-data/mysqltest_db1/t1.TRG
+# Replace definers with the "weird" definers
+perl;
+use strict;
+use warnings;
+my $fname= "$ENV{'MYSQLTEST_VARDIR'}/master-data/mysqltest_db1/t1.TRG";
+open(FILE, "<", $fname) or die;
+my @content= grep($_ !~ /^definers=/, <FILE>);
+close FILE;
+open(FILE, ">", $fname) or die;
+print FILE @content;
+print FILE "definers='' '\@' '\@abc\@def\@\@' '\@hostname' '\@abcdef\@\@\@hostname'\n";
+close FILE;
+EOF
--echo