Bug #79940 [Opn]: Cannot re-fetch rows in PDO

Edit report at https://bugs.php.net/bug.php?id=79940&edit=1 ID: 79940 User updated by: guana dot histark at gmail dot com Reported by: guana dot histark at gmail dot com Summary: Cannot re-fetch rows in PDO Status: Open Type: Bug Package: PDO MySQL Operating System: Linux PHP Version: 8.0.0beta1 Block user comment: N Private report: N New Comment: I tried with [PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL] But it the bug still persist. Previous Comments: ------------------------------------------------------------------------ [2020-08-07 13:40:54] cmb@php.net $stmt = $conn->prepare("SELECT 1 FROM TABLE WHERE ID = 1"); should likely be $stmt = $conn->prepare("SELECT 1 FROM TABLE WHERE ID = 1", [PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL]); ------------------------------------------------------------------------ [2020-08-07 05:42:10] guana dot histark at gmail dot com <?php $stmt = $conn->prepare("SELECT 1 FROM TABLE WHERE ID = 1"); $stmt->execute(); while($row = $stmt->fetch(PDO::FETCH_ASSOC)){ echo "First fetch \n"; } while($row = $stmt->fetch(PDO::FETCH_ASSOC,PDO::FETCH_ORI_ABS,0)){ echo "Second fetch \n"; } ?> ------------------------------------------------------------------------ [2020-08-06 22:17:19] requinix@php.net Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If the script requires a database to demonstrate the issue, please make sure it creates all necessary tables, stored procedures etc. Please avoid embedding huge scripts into the report. ------------------------------------------------------------------------ [2020-08-06 22:03:02] guana dot histark at gmail dot com Description: ------------ PDO::FETCH_ORI_ABS is not working for mariadb Test script: --------------- while($row = $stmt->fetch(PDO::FETCH_ASSOC,PDO::FETCH_ORI_ABS,0)) ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=79940&edit=1