diff options
| author | unknown <guilhem@mysql.com> | 2004-03-26 19:25:22 +0100 |
|---|---|---|
| committer | unknown <guilhem@mysql.com> | 2004-03-26 19:25:22 +0100 |
| commit | ab8c3d89b8c7c10ccf2b006ea279637e382909a1 (patch) | |
| tree | d2669c9c03a864d659be52cf9badd23f11b884f1 /mysql-test/r/rpl_temporary.result | |
| parent | 11bea84e431101c03ed0f0ccdc57815dd1359d77 (diff) | |
| download | mariadb-git-ab8c3d89b8c7c10ccf2b006ea279637e382909a1.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.
mysql-test/r/rpl_temporary.result:
result update
mysql-test/t/rpl_temporary.test:
adding test for privileges for SET SQL_LOG_BIN
sql/log.cc:
don't need to check SUPER
sql/set_var.cc:
refuse SET SQL_LOG_BIN if not SUPER
sql/sql_insert.cc:
Don't need to check SUPER
Diffstat (limited to 'mysql-test/r/rpl_temporary.result')
| -rw-r--r-- | mysql-test/r/rpl_temporary.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/rpl_temporary.result b/mysql-test/r/rpl_temporary.result index e7b64066c37..97561aa1218 100644 --- a/mysql-test/r/rpl_temporary.result +++ b/mysql-test/r/rpl_temporary.result @@ -7,6 +7,12 @@ start slave; reset master; SET @@session.pseudo_thread_id=100; ERROR HY000: Access denied. You need the SUPER privilege for this operation +SET @@session.sql_log_bin=0; +ERROR HY000: Access denied. You need the SUPER privilege for this operation +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; drop table if exists t1,t2; create table t1(f int); create table t2(f int); |