~stewart/drizzle/seapitester-state-history

« back to all changes in this revision

Viewing changes to plugin/storage_engine_api_tester/tests/t/rnd_pos.test

  • Committer: Stewart Smith
  • Date: 2011-01-13 05:25:03 UTC
  • Revision ID: stewart@flamingspork.com-20110113052503-kmdtjjk5x4lrd7yq
modify storage_engine_api tests to check the new SEAPITESTER_ENGINE_STATE_HISTORY table for what storage engine calls were made.

Show diffs side-by-side

added added

removed removed

Lines of Context:
4
4
#
5
5
set storage_engine=storage_engine_api_tester;
6
6
 
 
7
select seapitester_clear_engine_state_history();
 
8
 
7
9
# This failed because of syntax. Changed int(5) to int.
8
10
CREATE TABLE t1 (
9
11
  aufnr varchar(12) NOT NULL default '',
21
23
 
22
24
drop table t1;
23
25
 
 
26
select * from data_dictionary.seapitester_engine_state_history;
 
27
select seapitester_clear_engine_state_history();
 
28
 
24
29
# and again with a primary key
25
30
 
26
31
CREATE TABLE t1 (
39
44
 
40
45
drop table t1;
41
46
 
 
47
select * from data_dictionary.seapitester_engine_state_history;
 
48
select seapitester_clear_engine_state_history();
 
49
 
42
50
# and again with a unique key that becomes the clustered key
43
51
 
44
52
create table t1 (a int, b int, c int);
46
54
alter table t1 add unique(a,b);
47
55
 
48
56
drop table t1;
 
57
 
 
58
select * from data_dictionary.seapitester_engine_state_history;
 
59
select seapitester_clear_engine_state_history();
 
60