← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Daniel
  • Date: 2011-10-10 04:56:21 UTC
  • mto: This revision was merged to the branch mainline in revision 2437.
  • Revision ID: daniel@ubuntu-10-20111010045621-lav426gcxgksx0wb
Enable plugin by default.  Always escape and backtick quote the auth table name.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/auth_schema/tests/r/basic.result
1
1
SHOW VARIABLES LIKE 'auth_schema%';
2
2
Variable_name   Value
3
3
auth_schema_enabled     ON
4
 
auth_schema_table       auth.users
 
4
auth_schema_table       `auth`.`users`
5
5
SELECT MYSQL_PASSWORD('test_pass');
6
6
MYSQL_PASSWORD('test_pass')
7
7
34F2496C75CF8F8D8EBE14067C9C8B1AA8E80DEF
33
33
SELECT * FROM users2 ORDER BY user;
34
34
user    password
35
35
test_user2      34F2496C75CF8F8D8EBE14067C9C8B1AA8E80DEF
36
 
SET GLOBAL auth_schema_table='auth.users2';
 
36
SET GLOBAL auth_schema_table='`auth`.`users2`';
37
37
SHOW VARIABLES LIKE 'auth_schema%';
38
38
Variable_name   Value
39
39
auth_schema_enabled     ON
40
 
auth_schema_table       auth.users2
 
40
auth_schema_table       `auth`.`users2`
41
41
SELECT 'connection 2 works';
42
42
connection 2 works
43
43
connection 2 works
54
54
SHOW VARIABLES LIKE 'auth_schema%';
55
55
Variable_name   Value
56
56
auth_schema_enabled     OFF
57
 
auth_schema_table       auth.users
 
57
auth_schema_table       `auth`.`users`
58
58
connect(localhost,test_user,test_pass,test,MASTER_PORT,);
59
59
ERROR 28000: Access denied for user 'test_user' (using password: YES)
60
60
SET GLOBAL auth_schema_enabled=1;
61
61
SHOW VARIABLES LIKE 'auth_schema%';
62
62
Variable_name   Value
63
63
auth_schema_enabled     ON
64
 
auth_schema_table       auth.users
 
64
auth_schema_table       `auth`.`users`
65
65
SELECT 'auth re-enabled';
66
66
auth re-enabled
67
67
auth re-enabled
75
75
ERROR HY000: Incorrect arguments to SET
76
76
SHOW VARIABLES LIKE 'auth_schema_table';
77
77
Variable_name   Value
78
 
auth_schema_table       auth.users
 
78
auth_schema_table       `auth`.`users`
79
79
SET GLOBAL auth_schema_table='';
80
80
ERROR HY000: Incorrect arguments to SET
81
81
SHOW VARIABLES LIKE 'auth_schema_table';
82
82
Variable_name   Value
83
 
auth_schema_table       auth.users
 
83
auth_schema_table       `auth`.`users`
84
84
DROP SCHEMA auth;