diff options
| author | unknown <monty@hundin.mysql.fi> | 2002-10-18 09:51:46 +0300 |
|---|---|---|
| committer | unknown <monty@hundin.mysql.fi> | 2002-10-18 09:51:46 +0300 |
| commit | 4ae5fd0b892748925b3899131adc2c192453f693 (patch) | |
| tree | 0dab2949d066a3b223a7d273f96e80372b4f202a /mysql-test/t/heap_btree.test | |
| parent | 5d2e98ff5f29bbad52b7b57319ba0542b5d94d48 (diff) | |
| download | mariadb-git-4ae5fd0b892748925b3899131adc2c192453f693.tar.gz | |
Fixed heap_btree test to make it repeatable
mysql-test/r/heap_btree.result:
Make test repeatable
mysql-test/t/heap_btree.test:
Make test repeatable
Diffstat (limited to 'mysql-test/t/heap_btree.test')
| -rw-r--r-- | mysql-test/t/heap_btree.test | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/t/heap_btree.test b/mysql-test/t/heap_btree.test index e4b7d8674b9..3dd22f2da03 100644 --- a/mysql-test/t/heap_btree.test +++ b/mysql-test/t/heap_btree.test @@ -42,9 +42,10 @@ alter table t1 type=myisam; explain select * from t1 where a in (869751,736494,226312,802616); drop table t1; -create table t1 (x int not null, y int not null, key x using BTREE (x), unique y using BTREE (y)) +create table t1 (x int not null, y int not null, key x using BTREE (x,y), unique y using BTREE (y)) type=heap; insert into t1 values (1,1),(2,2),(1,3),(2,4),(2,5),(2,6); +explain select * from t1 where x=1; select * from t1 where x=1; select * from t1,t1 as t2 where t1.x=t2.y; explain select * from t1,t1 as t2 where t1.x=t2.y; |