diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2003-04-16 21:10:45 +0300 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2003-04-16 21:10:45 +0300 |
| commit | dad32c931086985a007932bdabf48af91478b7cb (patch) | |
| tree | 3c2a85deb97f21f132191bc92097ab6a5a707d92 /mysql-test/r/innodb_handler.result | |
| parent | 674d512da05bdb0d86e7ddf8808a7ef79e44c150 (diff) | |
| download | mariadb-git-dad32c931086985a007932bdabf48af91478b7cb.tar.gz | |
Fix for a bug with InnoDB SQL handler, when previous query failed
and an attempt is made to read previous / next value.
Diffstat (limited to 'mysql-test/r/innodb_handler.result')
| -rw-r--r-- | mysql-test/r/innodb_handler.result | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/mysql-test/r/innodb_handler.result b/mysql-test/r/innodb_handler.result index 321aedabdc7..949756a6546 100644 --- a/mysql-test/r/innodb_handler.result +++ b/mysql-test/r/innodb_handler.result @@ -139,4 +139,12 @@ a b alter table t1 type=innodb; handler t2 read first; Unknown table 't2' in HANDLER -drop table if exists t1; +drop table t1; +CREATE TABLE t1 ( no1 smallint(5) NOT NULL default '0', no2 int(10) NOT NULL default '0', PRIMARY KEY (no1,no2)) TYPE=InnoDB; +INSERT INTO t1 VALUES (1,274),(1,275),(2,6),(2,8),(4,1),(4,2); +HANDLER t1 OPEN; +HANDLER t1 READ `primary` = (1, 1000); +no1 no2 +HANDLER t1 READ `primary` PREV; +no1 no2 +DROP TABLE t1; |