php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #63466 PDO_MYSQL ignores PDO::FETCH_ORI_ABS in PDOStatement::fetch()
Submitted: 2012-11-08 09:48 UTC Modified: 2017-10-24 08:33 UTC
Votes:10
Avg. Score:4.4 ± 0.8
Reproduced:9 of 9 (100.0%)
Same Version:1 (11.1%)
Same OS:4 (44.4%)
From: vicrry at yahoo dot com dot hk Assigned:
Status: Open Package: PDO MySQL
PHP Version: 5.4.8 OS: CentOS
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [2012-11-08 09:48 UTC] vicrry at yahoo dot com dot hk
Description:
------------
When fetching with PDO::FETCH_ORI_ABS from MySQL with PDOStatement::fetch(), the 
driver silently swallows the options and work as if I passed PDO::FETCH_ORI_NEXT.

Test script:
---------------
$stmt = $pdo->prepare('SELECT * FROM table', array(
  PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL
));

$stmt->execute();

$row = $stmt->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_ABS, 5);

Expected result:
----------------
The sixth row returned.

Actual result:
--------------
The first row returned.

Patches

patch_against_5.3.3 (last revision 2013-05-02 19:46 UTC by brianj at technews dot co dot za)

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2013-01-30 16:08 UTC] uw@php.net
-Type: Bug +Type: Feature/Change Request
 [2013-01-30 16:08 UTC] uw@php.net
If its a bug, its a docs bug. Where in the PDO spec is written that every PDO driver has to support random flags of other drivers? I do not remember anything like that. Nonetheless the docs create the impression this is the case.
 [2017-10-24 08:33 UTC] kalle@php.net
-Package: PDO related +Package: PDO MySQL
 
PHP Copyright © 2001-2020 The PHP Group
All rights reserved.
Last updated: Wed Jan 22 05:01:23 2020 UTC