← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/simple_user_policy/tests/t/basic.test

  • Committer: Lee Bieber
  • Date: 2011-01-08 03:39:25 UTC
  • mfrom: (2062.1.2 build)
  • Revision ID: kalebral@gmail.com-20110108033925-koobar399kwrm4ba
Merge Brian - parser clean up
Merge Marisa - latest doc updates, fix sphinx warnings

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/simple_user_policy/tests/t/basic.test
51
51
connection con1;
52
52
 
53
53
# Check that we don't see other people's connections
54
 
SELECT USER, DB FROM DATA_DICTIONARY.PROCESSLIST ORDER BY USER, DB;
 
54
SELECT USERNAME, DB FROM DATA_DICTIONARY.PROCESSLIST ORDER BY USERNAME, DB;
55
55
 
56
56
# Check that we can kill a process that is owned by our user
57
57
--disable_reconnect
80
80
 
81
81
# Test that we cannot kill a process owned by someone else
82
82
connection con2;
83
 
SELECT USER, DB FROM DATA_DICTIONARY.PROCESSLIST ORDER BY USER, DB;
 
83
SELECT USERNAME, DB FROM DATA_DICTIONARY.PROCESSLIST ORDER BY USERNAME, DB;
84
84
select IF(((@id := kill_id) - kill_id), "NO", "YES") from t1;
85
85
 
86
86
--replace_regex /Unknown session id: [0-9]+/Unknown session id: #/
89
89
 
90
90
# Test that root can see everybody
91
91
connection default;
92
 
SELECT USER, DB FROM DATA_DICTIONARY.PROCESSLIST ORDER BY USER, DB;
 
92
SELECT USERNAME, DB FROM DATA_DICTIONARY.PROCESSLIST ORDER BY USERNAME, DB;
93
93
 
94
94
# Test that root can kill someone else
95
95
use user1;