← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • 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/r/basic.result
26
26
ERROR 42000: Access denied for user 'user1'@'LOCALHOST' to schema 'user2'
27
27
create table t1 (kill_id int);
28
28
insert into t1 values(connection_id());
29
 
SELECT USER, DB FROM DATA_DICTIONARY.PROCESSLIST ORDER BY USER, DB;
30
 
USER    DB
 
29
SELECT USERNAME, DB FROM DATA_DICTIONARY.PROCESSLIST ORDER BY USERNAME, DB;
 
30
USERNAME        DB
31
31
user1   user1
32
32
user1   user1
33
33
select IF(((@id := kill_id) - kill_id), "NO", "YES") from t1;
41
41
@id != connection_id()
42
42
1
43
43
update t1 set kill_id = connection_id();
44
 
SELECT USER, DB FROM DATA_DICTIONARY.PROCESSLIST ORDER BY USER, DB;
45
 
USER    DB
 
44
SELECT USERNAME, DB FROM DATA_DICTIONARY.PROCESSLIST ORDER BY USERNAME, DB;
 
45
USERNAME        DB
46
46
user2   user2
47
47
select IF(((@id := kill_id) - kill_id), "NO", "YES") from t1;
48
48
IF(((@id := kill_id) - kill_id), "NO", "YES")
49
49
YES
50
50
kill @id;
51
51
ERROR HY000: Unknown session id: #
52
 
SELECT USER, DB FROM DATA_DICTIONARY.PROCESSLIST ORDER BY USER, DB;
53
 
USER    DB
 
52
SELECT USERNAME, DB FROM DATA_DICTIONARY.PROCESSLIST ORDER BY USERNAME, DB;
 
53
USERNAME        DB
54
54
root    user2
55
55
user1   user1
56
56
user1   user1