← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/myisam_mrr.test

  • Committer: Monty Taylor
  • Date: 2008-07-22 05:48:51 UTC
  • mto: (202.1.3 toru)
  • mto: This revision was merged to the branch mainline in revision 204.
  • Revision ID: monty@inaugust.com-20080722054851-airxt73370725p7x
Re-enabled optimizations for the normal build, and added back the --with-debug option to turn them off. 

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/myisam_mrr.test
1
 
#
2
 
# MRR/MyISAM tests.
3
 
#
4
 
 
5
 
--disable_warnings
6
 
drop table if exists t1, t2, t3;
7
 
--enable_warnings
8
 
 
9
 
set @read_rnd_buffer_size_save= @@read_rnd_buffer_size;
10
 
set read_rnd_buffer_size=79;
11
 
select @@read_rnd_buffer_size;
12
 
 
13
 
 
14
 
set @@read_rnd_buffer_size= @read_rnd_buffer_size_save;
15
 
 
16
 
drop table t1, t2, t3, t4;
17
 
 
18
 
#
19
 
# BUG#30622: Incorrect query results for MRR + filesort
20
 
# 
21
 
CREATE TABLE t1 (
22
 
  ID int(10) NOT NULL AUTO_INCREMENT,
23
 
  col1 int(10) DEFAULT NULL,
24
 
  key1 int(10) NOT NULL DEFAULT '0',
25
 
  key2 int(10) DEFAULT NULL,
26
 
  text1 text,
27
 
  text2 text,
28
 
  col2 int(6) DEFAULT '100',
29
 
  col3 enum('headers','bodyandsubject') NOT NULL DEFAULT 'bodyandsubject',
30
 
  col4 int(3) NOT NULL DEFAULT '0',
31
 
  PRIMARY KEY (ID),
32
 
  KEY (key1),
33
 
  KEY (key2)
34
 
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
35
 
 
36
 
INSERT INTO t1 VALUES
37
 
(1,NULL,1130,NULL,'Hello',NULL,100,'bodyandsubject',0),
38
 
(2,NULL,1130,NULL,'bye',NULL,100,'bodyandsubject',0),
39
 
(3,NULL,1130,NULL,'red',NULL,100,'bodyandsubject',0),
40
 
(4,NULL,1130,NULL,'yellow',NULL,100,'bodyandsubject',0),
41
 
(5,NULL,1130,NULL,'blue',NULL,100,'bodyandsubject',0);
42
 
 
43
 
select * FROM t1 WHERE key1=1130 AND col1 IS NULL ORDER BY text1;
44
 
 
45
 
drop table t1;
46