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/t/innodb_handler.test | |
| 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/t/innodb_handler.test')
| -rw-r--r-- | mysql-test/t/innodb_handler.test | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/mysql-test/t/innodb_handler.test b/mysql-test/t/innodb_handler.test index c6448eba3ef..6777e4f49bd 100644 --- a/mysql-test/t/innodb_handler.test +++ b/mysql-test/t/innodb_handler.test @@ -72,5 +72,11 @@ alter table t1 type=innodb; --error 1109 handler t2 read first; -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); +HANDLER t1 READ `primary` PREV; +DROP TABLE t1; |