diff options
| author | Michael Widenius <monty@askmonty.org> | 2011-01-12 17:50:29 +0200 |
|---|---|---|
| committer | Michael Widenius <monty@askmonty.org> | 2011-01-12 17:50:29 +0200 |
| commit | 1fbcaf2e61996dfd9168800929257e9b54e0da4e (patch) | |
| tree | c8c2471e5004af893a179b4051b599428317df35 /mysql-test/suite/handler | |
| parent | a4579c3ef37ee2a17c71ea33f0a0261b0b49de05 (diff) | |
| parent | 4c576fd4927fffbf7cb11f011ff05fc91f9c01e7 (diff) | |
| download | mariadb-git-1fbcaf2e61996dfd9168800929257e9b54e0da4e.tar.gz | |
Merge with 5.2
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 6c3d03e291f..9d3bbb2ddfe 100644 --- a/mysql-test/suite/handler/innodb.result +++ b/mysql-test/suite/handler/innodb.result @@ -688,3 +688,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; |