push into mysql-6.0 branch (bar:2682) Bug#31302

[Alexander Barkov]

------------------------------------------------------------
revno: 2682
revision-id: bar@stripped
parent: bar@stripped
parent: alik@stripped
committer: Alexander Barkov <bar@stripped>
branch nick: mysql-6.0-alik2
timestamp: Wed 2008-08-06 11:41:30 +0500
message:
  Merge from mysql-6.0
modified:
  mysql-test/suite/falcon/r/falcon_tablespace_priv.result
mysqltestsuitefalcon-20080704142312-dh6xc2ic8ccmtp3g-1
  mysql-test/suite/falcon/t/falcon_tablespace_priv.test
mysqltestsuitefalcon-20080704142312-dh6xc2ic8ccmtp3g-2
    ------------------------------------------------------------
    revno: 2630.13.19
    revision-id: alik@stripped
    parent: alik@stripped
    committer: Alexander Nozdrin <alik@stripped>
    branch nick: 6.0
    timestamp: Mon 2008-08-04 10:58:12 +0400
    message:
      Add a test case for Bug#31302: USE information_schema disables DROP tablespace.
    modified:
      mysql-test/suite/falcon/r/falcon_tablespace_priv.result
mysqltestsuitefalcon-20080704142312-dh6xc2ic8ccmtp3g-1
      mysql-test/suite/falcon/t/falcon_tablespace_priv.test
mysqltestsuitefalcon-20080704142312-dh6xc2ic8ccmtp3g-2
=== modified file 'mysql-test/suite/falcon/r/falcon_tablespace_priv.result'
--- a/mysql-test/suite/falcon/r/falcon_tablespace_priv.result	2008-07-25 18:44:20 +0000
+++ b/mysql-test/suite/falcon/r/falcon_tablespace_priv.result	2008-08-04 06:58:12 +0000
@@ -42,3 +42,29 @@
 
 DROP USER mysqltest_u1@localhost;
 DROP USER mysqltest_u2@localhost;
+# --
+# -- Bug#31302: USE information_schema disables DROP tablespace
+# --
+GRANT CREATE TABLESPACE ON *.* TO mysqltest_u1@localhost;
+
+# -- Connection: mysqltest_u1@localhost
+
+# -- Grants for mysqltest_u1@localhost:
+SHOW GRANTS;
+Grants for mysqltest_u1@localhost
+GRANT CREATE TABLESPACE ON *.* TO 'mysqltest_u1'@'localhost'
+
+# -- CREATE TABLESPACE...
+CREATE TABLESPACE ts1
+ADD DATAFILE 'datafile.dat'
+ENGINE = Falcon;
+
+use INFORMATION_SCHEMA;
+
+# -- DROP TABLESPACE...
+DROP TABLESPACE ts1 
+ENGINE = Falcon;
+
+# -- Connection: root@localhost
+
+DROP USER mysqltest_u1@localhost;

=== modified file 'mysql-test/suite/falcon/t/falcon_tablespace_priv.test'
--- a/mysql-test/suite/falcon/t/falcon_tablespace_priv.test	2008-07-25 18:44:20 +0000
+++ b/mysql-test/suite/falcon/t/falcon_tablespace_priv.test	2008-08-04 06:58:12 +0000
@@ -56,3 +56,39 @@
 
 DROP USER mysqltest_u1@localhost;
 DROP USER mysqltest_u2@localhost;
+
+--echo # --
+--echo # -- Bug#31302: USE information_schema disables DROP tablespace
+--echo # --
+
+GRANT CREATE TABLESPACE ON *.* TO mysqltest_u1@localhost;
+
+--echo
+--echo # -- Connection: mysqltest_u1@localhost
+--echo
+--connect(con1, localhost, mysqltest_u1,,)
+
+--echo # -- Grants for mysqltest_u1@localhost:
+SHOW GRANTS;
+
+--echo
+--echo # -- CREATE TABLESPACE...
+CREATE TABLESPACE ts1
+ADD DATAFILE 'datafile.dat'
+ENGINE = Falcon;
+
+--echo
+use INFORMATION_SCHEMA;
+
+--echo
+--echo # -- DROP TABLESPACE...
+DROP TABLESPACE ts1 
+ENGINE = Falcon;
+
+--echo
+--echo # -- Connection: root@localhost
+--echo
+--connection default
+--disconnect con1
+
+DROP USER mysqltest_u1@localhost;