← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mysql-5.6/trusty

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): James Page
  • Date: 2014-02-12 11:54:27 UTC
  • Revision ID: package-import@ubuntu.com-20140212115427-oq6tfsqxl1wuwehi
Tags: upstream-5.6.15
Import upstream version 5.6.15

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/perfschema/t/dml_events_waits_current.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.events_waits_current
 
8
  where event_name like 'Wait/Synch/%' limit 1;
 
9
 
 
10
select * from performance_schema.events_waits_current
 
11
  where event_name='FOO';
 
12
--enable_result_log
 
13
 
 
14
--error ER_TABLEACCESS_DENIED_ERROR
 
15
insert into performance_schema.events_waits_current
 
16
  set thread_id='1', event_id=1,
 
17
  event_name='FOO', timer_start=1, timer_end=2, timer_wait=3;
 
18
 
 
19
--error ER_TABLEACCESS_DENIED_ERROR
 
20
update performance_schema.events_waits_current
 
21
  set timer_start=12;
 
22
 
 
23
--error ER_TABLEACCESS_DENIED_ERROR
 
24
update performance_schema.events_waits_current
 
25
  set timer_start=12 where thread_id=0;
 
26
 
 
27
--error ER_TABLEACCESS_DENIED_ERROR
 
28
delete from performance_schema.events_waits_current
 
29
  where thread_id=1;
 
30
 
 
31
--error ER_TABLEACCESS_DENIED_ERROR
 
32
delete from performance_schema.events_waits_current;
 
33
 
 
34
-- error ER_TABLEACCESS_DENIED_ERROR
 
35
LOCK TABLES performance_schema.events_waits_current READ;
 
36
UNLOCK TABLES;
 
37
 
 
38
-- error ER_TABLEACCESS_DENIED_ERROR
 
39
LOCK TABLES performance_schema.events_waits_current WRITE;
 
40
UNLOCK TABLES;
 
41