← Back to branch summary

~stewart/drizzle/embedded-innodb-create-select-transaction-arrgh

« back to all changes in this revision

Viewing changes to mysql-test/suite/funcs_1/r/is_column_privileges_is_mysql_test.result

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/funcs_1/r/is_column_privileges_is_mysql_test.result
 
1
##############################################################################
 
2
# Testcases 3.2.9.2+3.2.9.3 INFORMATION_SCHEMA.SCHEMATA accessible information
 
3
##############################################################################
 
4
DROP DATABASE IF EXISTS db_datadict;
 
5
CREATE DATABASE db_datadict;
 
6
DROP   USER 'testuser1'@'localhost';
 
7
CREATE USER 'testuser1'@'localhost';
 
8
GRANT SELECT ON db_datadict.* TO 'testuser1'@'localhost';
 
9
SELECT * FROM information_schema.column_privileges
 
10
WHERE table_schema IN ('information_schema','mysql','test')
 
11
ORDER BY table_schema, table_name, column_name;
 
12
GRANTEE TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME     PRIVILEGE_TYPE  IS_GRANTABLE
 
13
SHOW DATABASES LIKE 'information_schema';
 
14
Database (information_schema)
 
15
information_schema
 
16
SHOW DATABASES LIKE 'mysql';
 
17
Database (mysql)
 
18
mysql
 
19
SHOW DATABASES LIKE 'test';
 
20
Database (test)
 
21
test
 
22
# Establish connection testuser1 (user=testuser1)
 
23
SELECT * FROM information_schema.column_privileges
 
24
WHERE table_schema IN ('information_schema','mysql','test')
 
25
ORDER BY table_schema, table_name, column_name;
 
26
GRANTEE TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME     PRIVILEGE_TYPE  IS_GRANTABLE
 
27
SHOW DATABASES LIKE 'information_schema';
 
28
Database (information_schema)
 
29
information_schema
 
30
SHOW DATABASES LIKE 'mysql';
 
31
Database (mysql)
 
32
SHOW DATABASES LIKE 'test';
 
33
Database (test)
 
34
test
 
35
# Switch to connection default and close connection testuser1
 
36
DROP USER 'testuser1'@'localhost';
 
37
DROP DATABASE db_datadict;