php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #58024 ingres_num_rows not working
Submitted: 2008-01-31 05:49 UTC Modified: 2017-10-24 08:41 UTC
Votes:2
Avg. Score:2.0 ± 1.0
Reproduced:1 of 2 (50.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: steve at dundeecity dot gov dot uk Assigned:
Status: Suspended Package: ingres (PECL)
PHP Version: 5.2.1 OS: Z/linux SLES8.2
Private report: No CVE-ID: None
 [2008-01-31 05:49 UTC] steve at dundeecity dot gov dot uk
Description:
------------
I've recently installed php-5.2.5 on Apache-2.2.8 and compiled in the PECL ingres extension.

Our production code is presently running on php-4.4.2 on Apache-1.3.33 using the old ingres_ii extension. This has been running great for several years now, but we wanted to move up to php5 and apache2 to reap the memory/speed benefits and generally keep up.

I copied our production test code over to the apache2 php5 server and found that there seem to be either a backwards compatibility issue or it may be we are using the original extension incorrectly.


Reproduce code:
---------------
I seem to be getting an error from ingres_num_rows,
we used to write

    $rowcount=ingres_num_rows($conn)
 
we get ingres_num_rows() supplied resource is not a valid Ingres Resource
I have changed this to point to the result set intead of the resource
   
    $rowcount=ingres_num_rows($result)

however the result is always 0

We have extensively used ingres_num_rows in our applications and wonder if the above behaviour is correct and if there is a workaround.

Expected result:
----------------
correct number of rows affected.

Actual result:
--------------
returns 0 and requires to operate on the result set rather than the connection resource.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2008-01-31 05:57 UTC] steve at dundeecity dot gov dot uk
Version of Ingres used


II 2.6/0305 (ibm.lnx/00)
11368

on SLES 8.2 Z/linux on S390 - ibm Z890
 [2008-01-31 06:01 UTC] grant dot croker at ingres dot com
Hi Steve,

I have reproduced the problem and it would appear that this will occur on any version of Ingres prior to Ingres 2006 release 3. For some reason IIAPI_GQ_ROW_COUNT is not being set in getQInfoParm.gq_mask.

Investigating

grant
 [2017-10-24 08:41 UTC] kalle@php.net
-Status: Verified +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