summaryrefslogtreecommitdiff
path: root/mysql-test/t/user_var.test
diff options
context:
space:
mode:
authorunknown <gluh@eagle.intranet.mysql.r18.ru>2005-04-06 14:13:06 +0500
committerunknown <gluh@eagle.intranet.mysql.r18.ru>2005-04-06 14:13:06 +0500
commit31d15c3f76f84e3ebf6d6158cff7a454c5a8d222 (patch)
treebf70521aa94f8a83460fbdf835c8e3512f98f9d6 /mysql-test/t/user_var.test
parentbb4cc70d53e70239fe8524f33432a9963df9b254 (diff)
downloadmariadb-git-31d15c3f76f84e3ebf6d6158cff7a454c5a8d222.tar.gz
Fix for bug #9286: SESSION/GLOBAL should be disallowed for user variables
BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
Diffstat (limited to 'mysql-test/t/user_var.test')
-rw-r--r--mysql-test/t/user_var.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/user_var.test b/mysql-test/t/user_var.test
index b907f21056c..a288b7ef708 100644
--- a/mysql-test/t/user_var.test
+++ b/mysql-test/t/user_var.test
@@ -111,3 +111,11 @@ select FIELD( @var,'1it','Hit') as my_column;
select @v, coercibility(@v);
set @v1=null, @v2=1, @v3=1.1, @v4=now();
select coercibility(@v1),coercibility(@v2),coercibility(@v3),coercibility(@v4);
+
+#
+# Bug #9286 SESSION/GLOBAL should be disallowed for user variables
+#
+--error 1064
+set session @honk=99;
+--error 1105
+set one_shot @honk=99;