diff options
author | unknown <msvensson@pilot.blaudden> | 2007-02-24 08:18:57 +0100 |
---|---|---|
committer | unknown <msvensson@pilot.blaudden> | 2007-02-24 08:18:57 +0100 |
commit | f80babd61720298f8e3862f21b1851203cbcf871 (patch) | |
tree | 69650fc4b246ec36bb9f6d4f2e7e3659551fbc56 /mysql-test/t/trigger-grant.test | |
parent | d1351a6dd8de5b50d8c031658570f2654983411c (diff) | |
download | mariadb-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.test | 16 |
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 |