From: Date: January 24 2007 2:45pm
Subject: bk commit into 5.0 tree (kaa:1.2391) BUG#6774
List-Archive: http://lists.mysql.com/commits/18703
X-Bug: 6774
Message-Id: <20070124134537.4B0FB1D1223@polly.local>

Below is the list of changes that have just been committed into a local
5.0 repository of kaa. When kaa does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet@stripped, 2007-01-24 16:45:30+03:00, kaa@stripped +2 -0
  Added a test case for bug #6774 "Replication fails with Wrong usage of DB GRANT and GLOBAL PRIVILEGES"

  mysql-test/r/grant.result@stripped, 2007-01-24 16:45:25+03:00, kaa@stripped +2 -0
    Added a test case for bug #6774 "Replication fails with Wrong usage of DB GRANT and GLOBAL PRIVILEGES"

  mysql-test/t/grant.test@stripped, 2007-01-24 16:45:26+03:00, kaa@stripped +12 -0
    Added a test case for bug #6774 "Replication fails with Wrong usage of DB GRANT and GLOBAL PRIVILEGES"

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	kaa
# Host:	polly.local
# Root:	/tmp/maint/bug6774/my50-bug6774

--- 1.60/mysql-test/r/grant.result	2007-01-24 16:45:37 +03:00
+++ 1.61/mysql-test/r/grant.result	2007-01-24 16:45:37 +03:00
@@ -970,4 +970,6 @@ REVOKE EXECUTE ON PROCEDURE p1 FROM 1234
 ERROR HY000: String '1234567890abcdefGHIKL' is too long for user name (should be no longer than 16)
 REVOKE EXECUTE ON PROCEDURE t1 FROM some_user_name@1234567890abcdefghij1234567890abcdefghij1234567890abcdefghijQWERTY;
 ERROR HY000: String '1234567890abcdefghij1234567890abcdefghij1234567890abcdefghijQWERTY' is too long for host name (should be no longer than 60)
+GRANT PROCESS ON * TO user@localhost;
+ERROR 3D000: No database selected
 End of 5.0 tests

--- 1.50/mysql-test/t/grant.test	2007-01-24 16:45:37 +03:00
+++ 1.51/mysql-test/t/grant.test	2007-01-24 16:45:37 +03:00
@@ -863,4 +863,16 @@ REVOKE EXECUTE ON PROCEDURE p1 FROM 1234
 
 --error ER_WRONG_STRING_LENGTH
 REVOKE EXECUTE ON PROCEDURE t1 FROM some_user_name@1234567890abcdefghij1234567890abcdefghij1234567890abcdefghijQWERTY;
+
+#
+# Bug #6774: Replication fails with Wrong usage of DB GRANT and GLOBAL PRIVILEGES
+#
+# Check if GRANT ... ON * ... fails when no database is selected
+connect (con1, localhost, root,,*NO-ONE*)
+connection con1;
+--error ER_NO_DB_ERROR
+GRANT PROCESS ON * TO user@localhost;
+disconnect con1;
+connection default;
+
 --echo End of 5.0 tests