Debian Codegraph @

mysql-test/suite/funcs_1/r/is_schemata_extensions_is_mysql_test.result

raw
1 #########################################################################
2 # Testcases 3.2.9.2 + 3.2.9.3: INFORMATION_SCHEMA.SCHEMATA_EXTENSIONS
3 # accessible information
4 #########################################################################
5 DROP DATABASE IF EXISTS db_datadict;
6 CREATE DATABASE db_datadict;
7 DROP USER 'testuser1'@'localhost';
8 CREATE USER 'testuser1'@'localhost';
9 GRANT SELECT ON db_datadict.* TO 'testuser1'@'localhost';
10 SELECT * FROM information_schema.schemata_extensions
11 WHERE schema_name IN ('information_schema','mysql','test')
12 ORDER BY schema_name;
13 CATALOG_NAME SCHEMA_NAME OPTIONS
14 def information_schema
15 def mysql
16 def test
17 SHOW DATABASES LIKE 'information_schema';
18 Database (information_schema)
19 information_schema
20 SHOW DATABASES LIKE 'mysql';
21 Database (mysql)
22 mysql
23 SHOW DATABASES LIKE 'test';
24 Database (test)
25 test
26 # Establish connection testuser1 (user=testuser1)
27 SELECT * FROM information_schema.schemata_extensions
28 WHERE schema_name IN ('information_schema','mysql','test')
29 ORDER BY schema_name;
30 CATALOG_NAME SCHEMA_NAME OPTIONS
31 def information_schema
32 def test
33 SHOW DATABASES LIKE 'information_schema';
34 Database (information_schema)
35 information_schema
36 SHOW DATABASES LIKE 'mysql';
37 Database (mysql)
38 SHOW DATABASES LIKE 'test';
39 Database (test)
40 test
41 # Switch to connection default and close connection testuser1
42 DROP USER 'testuser1'@'localhost';
43 DROP DATABASE db_datadict;