diff options
Diffstat (limited to 'mysql-test/suite/funcs_1/r/is_basics_mixed.result')
-rw-r--r-- | mysql-test/suite/funcs_1/r/is_basics_mixed.result | 27 |
1 files changed, 16 insertions, 11 deletions
diff --git a/mysql-test/suite/funcs_1/r/is_basics_mixed.result b/mysql-test/suite/funcs_1/r/is_basics_mixed.result index 3ac17803688..2d14ada4f89 100644 --- a/mysql-test/suite/funcs_1/r/is_basics_mixed.result +++ b/mysql-test/suite/funcs_1/r/is_basics_mixed.result @@ -4,7 +4,7 @@ information_schema ####################################################################### # Testcase 3.2.1.20: USE INFORMATION_SCHEMA is supported ####################################################################### -# Switch to connection default +connection default; USE test; SELECT DATABASE(); DATABASE() @@ -15,7 +15,7 @@ DATABASE() information_schema DROP USER 'testuser1'@'localhost'; CREATE USER 'testuser1'@'localhost'; -# Establish connection testuser1 (user=testuser1) +connect testuser1, localhost, testuser1, , test; SELECT DATABASE(); DATABASE() test @@ -23,7 +23,8 @@ USE information_schema; SELECT DATABASE(); DATABASE() information_schema -# Switch to connection default and close connection testuser1 +connection default; +disconnect testuser1; DROP USER 'testuser1'@'localhost'; ####################################################################### # Testcase TBD1: The INFORMATION_SCHEMA cannot be dropped. @@ -38,7 +39,7 @@ ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_ ################################################################################## # Testcase 3.2.1.6+3.2.1.7: No user may create an INFORMATION_SCHEMA table or view ################################################################################## -# Switch to connection default (user=root) +connection default; USE information_schema; CREATE TABLE schemata ( c1 INT ); ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' @@ -128,7 +129,7 @@ GRANT ALL ON *.* TO testuser1@localhost; SHOW GRANTS FOR testuser1@localhost; Grants for testuser1@localhost GRANT ALL PRIVILEGES ON *.* TO 'testuser1'@'localhost' -# Establish connection testuser1 (user=testuser1) +connect testuser1, localhost, testuser1, , test; USE information_schema; CREATE TABLE schemata ( c1 INT ); ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema' @@ -212,7 +213,8 @@ SELECT * FROM information_schema.tables; ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema' CREATE VIEW information_schema.v1 AS SELECT 'garbage'; ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema' -# Switch to connection default (user=root) and close connection testuser1 +connection default; +disconnect testuser1; DROP USER 'testuser1'@'localhost'; ############################################################################### # Testcase 3.2.1.1+3.2.1.2: INFORMATION_SCHEMA tables can be queried via SELECT @@ -324,7 +326,7 @@ GRANT SELECT on information_schema.* TO testuser1@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' GRANT CREATE VIEW ON information_schema.* TO 'u_6_401018'@'localhost'; ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' -# Establish connection testuser1 (user=testuser1) +connect testuser1, localhost, testuser1, , db_datadict; SELECT table_schema,table_name FROM information_schema.tables WHERE table_schema = 'information_schema' AND table_name = 'tables'; table_schema table_name @@ -349,7 +351,7 @@ TABLE_SCHEMA TABLE_NAME TABLE_TYPE db_datadict t1 BASE TABLE db_datadict v2 VIEW GRANT SELECT ON db_datadict.v2 to testuser2@localhost; -# Establish connection testuser2 (user=testuser2) +connect testuser2, localhost, testuser2, , db_datadict; SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE FROM db_datadict.v2; TABLE_SCHEMA TABLE_NAME TABLE_TYPE @@ -358,7 +360,9 @@ SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE FROM information_schema.tables WHERE table_schema = 'db_datadict'; TABLE_SCHEMA TABLE_NAME TABLE_TYPE db_datadict v2 VIEW -# Switch to connection default and close connections testuser1 and testuser2 +connection default; +disconnect testuser1; +disconnect testuser2; DROP USER 'testuser1'@'localhost'; DROP USER 'testuser2'@'localhost'; DROP DATABASE db_datadict; @@ -533,7 +537,7 @@ db_datadict DROP USER 'testuser1'@'localhost'; CREATE USER 'testuser1'@'localhost'; GRANT ALL ON test.* TO 'testuser1'@'localhost'; -# Establish connection testuser1 (user=testuser1) +connect testuser1, localhost, testuser1, , test; SELECT DISTINCT table_schema FROM information_schema.columns WHERE table_schema LIKE 'db_data%'; table_schema @@ -573,7 +577,8 @@ trigger_schema event_object_schema SELECT DISTINCT table_schema FROM information_schema.views WHERE table_schema LIKE 'db_data%'; table_schema -# Switch to connection default and close connections testuser1 and testuser2 +connection default; +disconnect testuser1; DROP USER 'testuser1'@'localhost'; DROP DATABASE db_datadict; ######################################################################## |