← 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_history.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_history.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_history
 
8
  where event_name like 'Wait/Synch/%' limit 1;
 
9
 
 
10
select * from performance_schema.events_waits_history
 
11
  where event_name='FOO';
 
12
 
 
13
select * from performance_schema.events_waits_history
 
14
  where event_name like 'Wait/Synch/%' order by timer_wait limit 1;
 
15
 
 
16
select * from performance_schema.events_waits_history
 
17
  where event_name like 'Wait/Synch/%' order by timer_wait desc limit 1;
 
18
--enable_result_log
 
19
 
 
20
--error ER_TABLEACCESS_DENIED_ERROR
 
21
insert into performance_schema.events_waits_history
 
22
  set thread_id='1', event_id=1,
 
23
  event_name='FOO', timer_start=1, timer_end=2, timer_wait=3;
 
24
 
 
25
--error ER_TABLEACCESS_DENIED_ERROR
 
26
update performance_schema.events_waits_history
 
27
  set timer_start=12;
 
28
 
 
29
--error ER_TABLEACCESS_DENIED_ERROR
 
30
update performance_schema.events_waits_history
 
31
  set timer_start=12 where thread_id=0;
 
32
 
 
33
--error ER_TABLEACCESS_DENIED_ERROR
 
34
delete from performance_schema.events_waits_history
 
35
  where thread_id=1;
 
36
 
 
37
--error ER_TABLEACCESS_DENIED_ERROR
 
38
delete from performance_schema.events_waits_history;
 
39
 
 
40
-- error ER_TABLEACCESS_DENIED_ERROR
 
41
LOCK TABLES performance_schema.events_waits_history READ;
 
42
UNLOCK TABLES;
 
43
 
 
44
-- error ER_TABLEACCESS_DENIED_ERROR
 
45
LOCK TABLES performance_schema.events_waits_history WRITE;
 
46
UNLOCK TABLES;
 
47