php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #59827 OFFSET in `ingres_query` doesn't work
Submitted: 2011-06-23 05:50 UTC Modified: 2017-10-24 08:41 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:1 (100.0%)
Same OS:1 (100.0%)
From: francesco dot daguanno at bucap dot it Assigned:
Status: Suspended Package: ingres (PECL)
PHP Version: 5.3.6 OS: Windows Server 2003 Standard Edi
Private report: No CVE-ID: None
 [2011-06-23 05:50 UTC] francesco dot daguanno at bucap dot it
Description:
------------
OFFSET in `ingres_query` doesn't work

Reproduce code:
---------------
<? 
$dbLink = ingres_connect($dbDatabase, $dbUsername, $dbPassword) or die("error ingres_connect"); 
$dbQuery = " SELECT field1 FROM myTable OFFSET 10"; 
$dbResult = ingres_query($dbLink, $dbQuery) or die("error ingres_query"); 

echo "ingres_num_rows: ".ingres_num_rows($dbResult)."<br>";

while ($dbRow = ingres_fetch_array($dbResult))
{
echo ".$dbRow["field1"]."<br>";
}
?>

Expected result:
----------------
List of results starting with record number 10.

Actual result:
--------------
List of results starting with record number 1

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2017-10-24 08:41 UTC] kalle@php.net
-Status: Open +Status: Suspended
 [2017-10-24 08:41 UTC] kalle@php.net
The ingres package has not had any activity for 4 years, so its safe to say that its no longer in active development, if activity picks backup then the maintainer can re-open this report
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Dec 26 21:01:28 2024 UTC