← 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-08 19:47:11 UTC
  • mto: This revision was merged to the branch mainline in revision 2437.
  • Revision ID: daniel@ubuntu-10-20111008194711-dp47vra0qzjm2o8x
Escape user in SQL statement to avoid SQL injection.  Verify auth table name.  Include auth query in error message.  Tweak formatting to match coding standards.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/auth_schema/tests/r/basic.result
65
65
SELECT 'auth re-enabled';
66
66
auth re-enabled
67
67
auth re-enabled
 
68
connect(localhost,"'; drop table auth.users; select '",test_pass,test,MASTER_PORT,);
 
69
ERROR 28000: Access denied for user '"'; drop table auth.users; select '"' (using password: YES)
 
70
SHOW TABLES FROM auth;
 
71
Tables_in_auth
 
72
users
 
73
users2
 
74
SET GLOBAL auth_schema_table=NULL;
 
75
ERROR HY000: Incorrect arguments to SET
 
76
SHOW VARIABLES LIKE 'auth_schema_table';
 
77
Variable_name   Value
 
78
auth_schema_table       auth.users
 
79
SET GLOBAL auth_schema_table='';
 
80
ERROR HY000: Incorrect arguments to SET
 
81
SHOW VARIABLES LIKE 'auth_schema_table';
 
82
Variable_name   Value
 
83
auth_schema_table       auth.users
68
84
DROP SCHEMA auth;