← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.5/precise-201203300109

« back to all changes in this revision

Viewing changes to mysql-test/suite/perfschema/r/dml_threads.result

  • Committer: Package Import Robot
  • Author(s): Clint Byrum
  • Date: 2011-11-08 11:31:13 UTC
  • Revision ID: package-import@ubuntu.com-20111108113113-3ulw01fvi4vn8m25
Tags: upstream-5.5.17
Import upstream version 5.5.17

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/perfschema/r/dml_threads.result
 
1
select * from performance_schema.threads
 
2
where name like 'Thread/%' limit 1;
 
3
select * from performance_schema.threads
 
4
where name='FOO';
 
5
insert into performance_schema.threads
 
6
set name='FOO', thread_id=1, processlist_id=2;
 
7
ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'threads'
 
8
update performance_schema.threads
 
9
set thread_id=12;
 
10
ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'threads'
 
11
update performance_schema.threads
 
12
set thread_id=12 where name like "FOO";
 
13
ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'threads'
 
14
delete from performance_schema.threads
 
15
where id=1;
 
16
ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'threads'
 
17
delete from performance_schema.threads;
 
18
ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'threads'
 
19
LOCK TABLES performance_schema.threads READ;
 
20
ERROR 42000: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'threads'
 
21
UNLOCK TABLES;
 
22
LOCK TABLES performance_schema.threads WRITE;
 
23
ERROR 42000: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'threads'
 
24
UNLOCK TABLES;