diff options
| author | unknown <igor@rurik.mysql.com> | 2006-04-20 17:00:29 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2006-04-20 17:00:29 -0700 |
| commit | 17e3ee35531d0003de31093570e64f604bd8c4fa (patch) | |
| tree | e8d6c1515cbee501bb83fd9161a40f5422421abe /mysql-test/r/index_merge_innodb.result | |
| parent | f56780ecb5adc2dae785426126a8823bc7b3c724 (diff) | |
| parent | 93409ee7bebcf8df98ab532884ecfdaaae1f96cc (diff) | |
| download | mariadb-git-17e3ee35531d0003de31093570e64f604bd8c4fa.tar.gz | |
Merge rurik.mysql.com:/home/igor/tmp_merge
into rurik.mysql.com:/home/igor/dev/mysql-5.1-2
mysql-test/r/index_merge_innodb.result:
Auto merged
sql/opt_range.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/index_merge_innodb.result')
| -rw-r--r-- | mysql-test/r/index_merge_innodb.result | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/r/index_merge_innodb.result b/mysql-test/r/index_merge_innodb.result index b20e66a1098..d7dcc7853cd 100644 --- a/mysql-test/r/index_merge_innodb.result +++ b/mysql-test/r/index_merge_innodb.result @@ -260,3 +260,25 @@ t_vers t_rele t_cust filler1 7.6 a 7.6 a drop table t1; +create table t1 ( +pk int(11) not null auto_increment, +a int(11) not null default '0', +b int(11) not null default '0', +c int(11) not null default '0', +filler1 datetime, filler2 varchar(15), +filler3 longtext, +kp1 varchar(4), kp2 varchar(7), +kp3 varchar(2), kp4 varchar(4), +kp5 varchar(7), +filler4 char(1), +primary key (pk), +key idx1(a,b,c), +key idx2(c), +key idx3(kp1,kp2,kp3,kp4,kp5) +) engine=innodb default charset=latin1; +set @fill=NULL; +SELECT COUNT(*) FROM t1 WHERE b = 0 AND a = 0 AND c = 13286427 AND +kp1='279' AND kp2='ELM0678' AND kp3='6' AND kp4='10' AND kp5 = 'R '; +COUNT(*) +1 +drop table t1; |