← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mariadb-5.5/trusty-proposed

« back to all changes in this revision

Viewing changes to mysql-test/suite/perfschema/t/dml_file_instances.test

  • Committer: Package Import Robot
  • Author(s): Otto Kekäläinen
  • Date: 2013-12-22 10:27:05 UTC
  • Revision ID: package-import@ubuntu.com-20131222102705-mndw7s12mz0szrcn
Tags: upstream-5.5.32
Import upstream version 5.5.32

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/perfschema/t/dml_file_instances.test
 
1
# Tests for PERFORMANCE_SCHEMA
 
2
 
 
3
--source include/not_embedded.inc
 
4
--source include/have_perfschema.inc
 
5
 
 
6
--disable_result_log
 
7
select * from performance_schema.file_instances limit 1;
 
8
 
 
9
select * from performance_schema.file_instances
 
10
  where file_name='FOO';
 
11
--enable_result_log
 
12
 
 
13
--error ER_TABLEACCESS_DENIED_ERROR
 
14
insert into performance_schema.file_instances
 
15
  set file_name='FOO', event_name='BAR', open_count=12;
 
16
 
 
17
--error ER_TABLEACCESS_DENIED_ERROR
 
18
update performance_schema.file_instances
 
19
  set file_name='FOO';
 
20
 
 
21
--error ER_TABLEACCESS_DENIED_ERROR
 
22
delete from performance_schema.file_instances
 
23
  where event_name like "wait/%";
 
24
 
 
25
--error ER_TABLEACCESS_DENIED_ERROR
 
26
delete from performance_schema.file_instances;
 
27
 
 
28
-- error ER_TABLEACCESS_DENIED_ERROR
 
29
LOCK TABLES performance_schema.file_instances READ;
 
30
UNLOCK TABLES;
 
31
 
 
32
-- error ER_TABLEACCESS_DENIED_ERROR
 
33
LOCK TABLES performance_schema.file_instances WRITE;
 
34
UNLOCK TABLES;
 
35