summaryrefslogtreecommitdiff
path: root/mysql-test/t/grant.test
diff options
context:
space:
mode:
authorunknown <msvensson@pilot.(none)>2007-06-01 14:12:16 +0200
committerunknown <msvensson@pilot.(none)>2007-06-01 14:12:16 +0200
commitc0c5a056a4cf6d8021a5e49ccf44cfd57647bcac (patch)
treea954c68dd355ce2f433f7c07e9eb4385a6f71e79 /mysql-test/t/grant.test
parenta89e00ff429a1aa259518e023cceaddad978a4d5 (diff)
downloadmariadb-git-c0c5a056a4cf6d8021a5e49ccf44cfd57647bcac.tar.gz
Fiux syntax errors in grant.test, connect command with both -- and ;
only one of those is allowed
Diffstat (limited to 'mysql-test/t/grant.test')
-rw-r--r--mysql-test/t/grant.test12
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/t/grant.test b/mysql-test/t/grant.test
index f500b8e6591..17c5f1bbe8f 100644
--- a/mysql-test/t/grant.test
+++ b/mysql-test/t/grant.test
@@ -862,7 +862,7 @@ CREATE TABLE mysqltest1.t2 (int_field INT);
CREATE USER mysqltest_1@localhost;
GRANT SELECT ON mysqltest1.t1 TO mysqltest_1@localhost;
---connect (conn42,localhost,mysqltest_1,,mysqltest1);
+connect (conn42,localhost,mysqltest_1,,mysqltest1);
SELECT USER();
SHOW GRANTS;
--error ER_TABLEACCESS_DENIED_ERROR
@@ -873,7 +873,7 @@ ALTER TABLE t1 RENAME TO t2;
--connection default
GRANT DROP ON mysqltest1.t1 TO mysqltest_1@localhost;
---connect (conn42,localhost,mysqltest_1,,mysqltest1);
+connect (conn42,localhost,mysqltest_1,,mysqltest1);
--error ER_TABLEACCESS_DENIED_ERROR
RENAME TABLE t1 TO t2;
--error ER_TABLEACCESS_DENIED_ERROR
@@ -882,7 +882,7 @@ ALTER TABLE t1 RENAME TO t2;
--connection default
GRANT ALTER ON mysqltest1.t1 TO mysqltest_1@localhost;
---connect (conn42,localhost,mysqltest_1,,mysqltest1);
+connect (conn42,localhost,mysqltest_1,,mysqltest1);
SHOW GRANTS;
--error ER_TABLEACCESS_DENIED_ERROR
RENAME TABLE t1 TO t2;
@@ -891,7 +891,7 @@ ALTER TABLE t1 RENAME TO t2;
--disconnect conn42
--connection default
GRANT INSERT, CREATE ON mysqltest1.t1 TO mysqltest_1@localhost;
---connect (conn42,localhost,mysqltest_1,,mysqltest1);
+connect (conn42,localhost,mysqltest_1,,mysqltest1);
SHOW GRANTS;
--error ER_TABLEACCESS_DENIED_ERROR
--disconnect conn42
@@ -899,7 +899,7 @@ SHOW GRANTS;
GRANT INSERT, SELECT, CREATE, ALTER, DROP ON mysqltest1.t2 TO mysqltest_1@localhost;
DROP TABLE mysqltest1.t2;
---connect (conn42,localhost,mysqltest_1,,mysqltest1);
+connect (conn42,localhost,mysqltest_1,,mysqltest1);
SHOW GRANTS;
RENAME TABLE t1 TO t2;
RENAME TABLE t2 TO t1;
@@ -910,7 +910,7 @@ ALTER TABLE t2 RENAME TO t1;
REVOKE DROP, INSERT ON mysqltest1.t1 FROM mysqltest_1@localhost;
REVOKE DROP, INSERT ON mysqltest1.t2 FROM mysqltest_1@localhost;
---connect (conn42,localhost,mysqltest_1,,mysqltest1);
+connect (conn42,localhost,mysqltest_1,,mysqltest1);
SHOW GRANTS;
--error ER_TABLEACCESS_DENIED_ERROR
RENAME TABLE t1 TO t2;