diff options
| author | Michael Widenius <monty@askmonty.org> | 2011-01-12 17:38:13 +0200 |
|---|---|---|
| committer | Michael Widenius <monty@askmonty.org> | 2011-01-12 17:38:13 +0200 |
| commit | 4c576fd4927fffbf7cb11f011ff05fc91f9c01e7 (patch) | |
| tree | 7673fdeb32bf17a0bb45b3804f7886e69728254a /mysql-test/suite/handler | |
| parent | e6ba9d285aa41bb3d691cba7445b9b5479e34eaf (diff) | |
| parent | d0e8dbc4a359d3fe354fff95e293bd1783ae009e (diff) | |
| download | mariadb-git-4c576fd4927fffbf7cb11f011ff05fc91f9c01e7.tar.gz | |
Merge with 5.1
Diffstat (limited to 'mysql-test/suite/handler')
| -rw-r--r-- | mysql-test/suite/handler/innodb.result | 10 | ||||
| -rw-r--r-- | mysql-test/suite/handler/innodb.test | 11 |
2 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/suite/handler/innodb.result b/mysql-test/suite/handler/innodb.result index 83ce270612d..2cdaa0c4664 100644 --- a/mysql-test/suite/handler/innodb.result +++ b/mysql-test/suite/handler/innodb.result @@ -560,3 +560,13 @@ HANDLER t1 READ a NEXT; a HANDLER t1 CLOSE; DROP TABLE t1; +CREATE TABLE t1 (f1 integer, f2 integer, primary key (f1), key (f2)) engine=innodb; +INSERT INTO t1 VALUES (1,1),(2,2),(3,3); +HANDLER t1 OPEN; +HANDLER t1 READ FIRST WHERE f2 <= 1; +f1 f2 +1 1 +HANDLER t1 READ `PRIMARY` PREV; +f1 f2 +3 3 +DROP TABLE t1; diff --git a/mysql-test/suite/handler/innodb.test b/mysql-test/suite/handler/innodb.test index f4e4bf7cc3f..6527c4bb8bb 100644 --- a/mysql-test/suite/handler/innodb.test +++ b/mysql-test/suite/handler/innodb.test @@ -15,3 +15,14 @@ let $engine_type= InnoDB; --source init.inc --source handler.inc + +# +# LP#697610 ha_index_prev(uchar*): Assertion `inited==INDEX' +# + +CREATE TABLE t1 (f1 integer, f2 integer, primary key (f1), key (f2)) engine=innodb; +INSERT INTO t1 VALUES (1,1),(2,2),(3,3); +HANDLER t1 OPEN; +HANDLER t1 READ FIRST WHERE f2 <= 1; +HANDLER t1 READ `PRIMARY` PREV; +DROP TABLE t1; |