← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

Merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/test_authz/tests/r/basic.result
 
1
create database authz_no;
 
2
SELECT * from authz_no.dont_exist;
 
3
ERROR 42S02: Table 'authz_no.dont_exist' doesn't exist
 
4
create database authz_yes;
 
5
show databases;
 
6
Database
 
7
authz_no
 
8
authz_yes
 
9
data_dictionary
 
10
information_schema
 
11
mysql
 
12
test
 
13
show databases;
 
14
Database
 
15
authz_yes
 
16
data_dictionary
 
17
information_schema
 
18
mysql
 
19
test
 
20
SELECT * from authz_no.dont_exist;
 
21
ERROR 42000: Access denied for user 'authz'@'LOCALHOST' to database 'authz_no'
 
22
create database authz_no;
 
23
ERROR 42000: Access denied for user 'authz'@'LOCALHOST' to database 'authz_no'
 
24
drop database authz_no;
 
25
ERROR 42000: Access denied for user 'authz'@'LOCALHOST' to database 'authz_no'
 
26
show processlist;
 
27
ID      USER    HOST    DB      COMMAND TIME    STATE   INFO
 
28
1       root    #       test    #       #       #       
 
29
2       authz   #       test    #       #       #       
 
30
3       root    #       test    #       #       #       show processlist
 
31
4       root    #       test    #       #       #       show processlist
 
32
create table t1 (kill_id int);
 
33
insert into t1 values(connection_id());
 
34
select ((@id := kill_id) - kill_id) from t1;
 
35
((@id := kill_id) - kill_id)
 
36
0
 
37
kill @id;
 
38
select ((@id := kill_id) - kill_id) from t1;
 
39
((@id := kill_id) - kill_id)
 
40
0
 
41
select @id != connection_id();
 
42
@id != connection_id()
 
43
1
 
44
update t1 set kill_id= connection_id();
 
45
show processlist;
 
46
ID      USER    HOST    DB      COMMAND TIME    STATE   INFO
 
47
2       authz   #       test    Query   #       Sending data    show processlist
 
48
select ((@id := kill_id) - kill_id) from t1;
 
49
((@id := kill_id) - kill_id)
 
50
0
 
51
kill @id;
 
52
ERROR HY000: Unknown thread id: 5
 
53
connect(localhost,authz,,authz_no,MASTER_PORT,);
 
54
ERROR 42000: Access denied for user 'authz'@'LOCALHOST' to database 'authz_no'
 
55
drop table t1;
 
56
drop schema authz_yes;
 
57
drop schema authz_no;