summaryrefslogtreecommitdiff
path: root/mysql-test/t/grant.test
diff options
context:
space:
mode:
authorunknown <bar@mysql.com>2005-08-04 15:25:03 +0500
committerunknown <bar@mysql.com>2005-08-04 15:25:03 +0500
commit9e3562d77326dd81103428a243869c84f84551b3 (patch)
tree4f5621330b6475f621be708c12d20328161f6a37 /mysql-test/t/grant.test
parent357ebcc284c9d5c5e18c6badc419001831a108db (diff)
downloadmariadb-git-9e3562d77326dd81103428a243869c84f84551b3.tar.gz
grant.result, grant.test:
fixing tests accordingly item.cc: Bug #10892 user variables not auto cast for comparisons When mixing strings with different character sets, and coercibility is the same, we allow conversion if one character set is superset for other character set. sql/item.cc: Bug #10892 user variables not auto cast for comparisons When mixing strings with different character sets, and coercibility is the same, we allow conversion if one character set is superset for other character set. mysql-test/t/grant.test: fixing tests accordingly mysql-test/r/grant.result: fixing tests accordingly
Diffstat (limited to 'mysql-test/t/grant.test')
-rw-r--r--mysql-test/t/grant.test7
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/t/grant.test b/mysql-test/t/grant.test
index 50255d515e0..b0de62e679c 100644
--- a/mysql-test/t/grant.test
+++ b/mysql-test/t/grant.test
@@ -402,4 +402,11 @@ flush privileges;
delete from tables_priv where host = '' and user = 'mysqltest_1';
flush privileges;
+#
+# Bug #10892 user variables not auto cast for comparisons
+# Check that we don't get illegal mix of collations
+#
+set @user123="non-existent";
+select * from mysql.db where user=@user123;
+
# End of 4.1 tests