summaryrefslogtreecommitdiff
path: root/mysql-test/t/grant_cache.test
diff options
context:
space:
mode:
authorunknown <bar@mysql.com>2004-07-08 18:54:07 +0500
committerunknown <bar@mysql.com>2004-07-08 18:54:07 +0500
commit27dc52fa022ba3d7d9cd87b866d84d9c03940048 (patch)
treec43bdd35c88c202349d72278d66beb8e80b93041 /mysql-test/t/grant_cache.test
parent80e005737b921624a7cf9d6dbdea6597897341e1 (diff)
downloadmariadb-git-27dc52fa022ba3d7d9cd87b866d84d9c03940048.tar.gz
Bug#4338: mysql-test-run fails if compiled with non-latin1 character set
Diffstat (limited to 'mysql-test/t/grant_cache.test')
-rw-r--r--mysql-test/t/grant_cache.test9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/grant_cache.test b/mysql-test/t/grant_cache.test
index 7806253124e..a82cd732802 100644
--- a/mysql-test/t/grant_cache.test
+++ b/mysql-test/t/grant_cache.test
@@ -126,6 +126,15 @@ show status like "Qcache_not_cached";
# Cleanup
connection root;
+#
+# A temporary 4.1 workaround to make this test pass if
+# mysql was compiled with other than latin1 --with-charset=XXX.
+# Without "set names binary" the below queries fail with
+# "Illegal mix of collations" error.
+# In 5.0 we will change grant tables to use NCHAR(N) instead
+# of "CHAR(N) BINARY", and use cast-to-nchar: N'mysqltest_1'.
+#
+set names binary;
delete from mysql.user where user in ("mysqltest_1","mysqltest_2","mysqltest_3");
delete from mysql.db where user in ("mysqltest_1","mysqltest_2","mysqltest_3");
delete from mysql.tables_priv where user in ("mysqltest_1","mysqltest_2","mysqltest_3");