← Back to branch summary

~ubuntu-branches/ubuntu/precise/drizzle/precise

« back to all changes in this revision

Viewing changes to plugin/storage_engine_api_tester/tests/r/min_index_scan_error.result

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2011-03-02 10:38:38 UTC
  • mfrom: (1.2.9 upstream)
  • Revision ID: james.westby@ubuntu.com-20110302103838-4ezi8b065c4bv329
Tags: 2011.03.11-0ubuntu1
* New upstream release.
* Sleep no longer an so.
* Re-add get-orig-source, but this time with working.
* New symbol added to libdrizzle.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/storage_engine_api_tester/tests/r/min_index_scan_error.result
 
1
create table t1 (a int primary key auto_increment, b int, index(b)) engine=storage_engine_api_tester;
 
2
show create table t1;
 
3
Table   Create Table
 
4
t1      CREATE TABLE `t1` (
 
5
  `a` INT NOT NULL AUTO_INCREMENT,
 
6
  `b` INT DEFAULT NULL,
 
7
  PRIMARY KEY (`a`),
 
8
  KEY `b` (`b`)
 
9
) ENGINE=STORAGE_ENGINE_API_TESTER COLLATE = utf8_general_ci
 
10
insert into t1 (b) values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
 
11
insert into t1 (b) values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
 
12
explain select min(b) from t1;
 
13
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
 
14
1       SIMPLE  NULL    NULL    NULL    NULL    NULL    NULL    NULL    Select tables optimized away
 
15
SELECT seapitester_error_inject(4);
 
16
seapitester_error_inject(4)
 
17
4
 
18
select seapitester_clear_engine_state_history();
 
19
seapitester_clear_engine_state_history()
 
20
0
 
21
select min(b) from t1;
 
22
Got one of the listed errors
 
23
select * from data_dictionary.seapitester_engine_state_history;
 
24
STATE
 
25
START STATEMENT
 
26
END STATEMENT
 
27
ROLLBACK
 
28
::SEAPITester()
 
29
select seapitester_clear_engine_state_history();
 
30
seapitester_clear_engine_state_history()
 
31
0
 
32
SELECT seapitester_error_inject(0);
 
33
seapitester_error_inject(0)
 
34
0
 
35
drop table t1;