MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:Tatjana A Nuernberg Date:May 31 2006 1:38pm
Subject:bk commit into 5.0 tree (tnurnberg:1.2161) BUG#19920
View as plain text  
Below is the list of changes that have just been committed into a local
5.0 repository of tnurnberg. When tnurnberg 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
  1.2161 06/05/31 15:37:57 tnurnberg@stripped +2 -0
  Bug#19920: SHOW GRANTS can crash the server, if host information doesn't match
  
  This is a duplicate of 16297 (In memory grant tables not flushed when
  users's hostname is ""), so we just show that the fix for that also
  fixes 19920.

  mysql-test/t/grant.test
    1.42 06/05/31 15:37:47 tnurnberg@stripped +18 -0
    test case for #19920

  mysql-test/r/grant.result
    1.53 06/05/31 15:37:47 tnurnberg@stripped +15 -0
    test case for #19920

# 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:	tnurnberg
# Host:	salvation.intern.azundris.com
# Root:	/home/mysql-5.0-maint-19920

--- 1.52/mysql-test/r/grant.result	2006-05-29 15:06:30 +02:00
+++ 1.53/mysql-test/r/grant.result	2006-05-31 15:37:47 +02:00
@@ -867,3 +867,18 @@
 flush privileges;
 drop table t2;
 drop table t1;
+CREATE USER testuser@'%';
+CREATE DATABASE test1;
+CREATE DATABASE test2;
+CREATE TABLE test2.tt (id INT NOT NULL PRIMARY KEY);
+GRANT ALL ON test1.* TO testuser@'%';
+GRANT ALL ON test2.tt TO testuser@'%';
+UPDATE mysql.tables_priv SET host='' WHERE user='testuser';
+FLUSH PRIVILEGES;
+SHOW GRANTS FOR testuser@'%';
+Grants for testuser@%
+GRANT USAGE ON *.* TO 'testuser'@'%'
+GRANT ALL PRIVILEGES ON `test1`.* TO 'testuser'@'%'
+DROP USER testuser@'';
+DROP DATABASE test1;
+DROP DATABASE test2;

--- 1.41/mysql-test/t/grant.test	2006-05-29 15:06:30 +02:00
+++ 1.42/mysql-test/t/grant.test	2006-05-31 15:37:47 +02:00
@@ -681,3 +681,21 @@
 drop table t1;
 
 
+
+#
+# Bug #19920 SHOW GRANTS can crash the server, if host information
+#            doesn't match.
+#
+
+CREATE USER testuser@'%';
+CREATE DATABASE test1;
+CREATE DATABASE test2;
+CREATE TABLE test2.tt (id INT NOT NULL PRIMARY KEY);
+GRANT ALL ON test1.* TO testuser@'%';
+GRANT ALL ON test2.tt TO testuser@'%';
+UPDATE mysql.tables_priv SET host='' WHERE user='testuser';
+FLUSH PRIVILEGES;
+SHOW GRANTS FOR testuser@'%';
+DROP USER testuser@'';
+DROP DATABASE test1;
+DROP DATABASE test2;
Thread
bk commit into 5.0 tree (tnurnberg:1.2161) BUG#19920Tatjana A Nuernberg31 May