summaryrefslogtreecommitdiff
path: root/mysql-test/t/rpl_temporary.test
diff options
context:
space:
mode:
authorguilhem@mysql.com <>2004-03-26 19:25:22 +0100
committerguilhem@mysql.com <>2004-03-26 19:25:22 +0100
commit8066c2ce758eb65b09879701e3c5ed540560d40a (patch)
treed2669c9c03a864d659be52cf9badd23f11b884f1 /mysql-test/t/rpl_temporary.test
parent90a5e244bed4d136a292efe72b217a929587e79b (diff)
downloadmariadb-git-8066c2ce758eb65b09879701e3c5ed540560d40a.tar.gz
Changing SET SQL_LOG_BIN so that it explicitely throws an error if
user is not SUPER, instead of setting the value but ignoring it silently internally.
Diffstat (limited to 'mysql-test/t/rpl_temporary.test')
-rw-r--r--mysql-test/t/rpl_temporary.test10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/rpl_temporary.test b/mysql-test/t/rpl_temporary.test
index 0df8ceb6377..c456562f0e5 100644
--- a/mysql-test/t/rpl_temporary.test
+++ b/mysql-test/t/rpl_temporary.test
@@ -30,7 +30,17 @@ connect (con3,localhost,zedjzlcsjhd,,);
connection con3;
--error 1227
SET @@session.pseudo_thread_id=100;
+# While we are here we also test that SQL_LOG_BIN can't be set
+--error 1227
+SET @@session.sql_log_bin=0;
+# Now as root, to be sure it works
+connection con2;
+SET @@session.pseudo_thread_id=100;
+SET @@session.pseudo_thread_id=connection_id();
+SET @@session.sql_log_bin=0;
+SET @@session.sql_log_bin=1;
+connection con3;
let $VERSION=`select version()`;
--disable_warnings