~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/simple_user_policy/tests/r/basic.result

  • Committer: Brian Aker
  • Date: 2011-01-26 06:50:16 UTC
  • mto: This revision was merged to the branch mainline in revision 2119.
  • Revision ID: brian@tangent.org-20110126065016-3ns7c7sp1ac9dj8h
Fix for show schemas to user generator correctly for output.

Show diffs side-by-side

added added

removed removed

Lines of Context:
2
2
create schema user2;
3
3
SELECT SCHEMA_NAME FROM DATA_DICTIONARY.SCHEMAS ORDER BY SCHEMA_NAME;
4
4
SCHEMA_NAME
5
 
data_dictionary
6
 
information_schema
 
5
DATA_DICTIONARY
 
6
INFORMATION_SCHEMA
7
7
mysql
8
8
test
9
9
user1
15
15
ERROR 42S02: Table 'user1.dont_exist' doesn't exist
16
16
SELECT SCHEMA_NAME FROM DATA_DICTIONARY.SCHEMAS ORDER BY SCHEMA_NAME;
17
17
SCHEMA_NAME
18
 
data_dictionary
19
 
information_schema
 
18
DATA_DICTIONARY
 
19
INFORMATION_SCHEMA
20
20
user1
21
21
SELECT * from user2.dont_exist;
22
22
ERROR 42000: Access denied for user 'user1'@'LOCALHOST' to schema 'user2'