php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #56668 rowCount return nothing with SQLite3 pragma query
Submitted: 2005-11-21 15:16 UTC Modified: 2005-11-21 15:25 UTC
From: fhenninot at freesurf dot fr Assigned:
Status: Not a bug Package: PDO (PECL)
PHP Version: Irrelevant OS: Linux
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: fhenninot at freesurf dot fr
New email:
PHP Version: OS:

 

 [2005-11-21 15:16 UTC] fhenninot at freesurf dot fr
Description:
------------
Hi!
This bug was verified with PHP-5.1RC6.

when PRAGMA query for SQLite3 can be return several rows, the rowCount method return 0.

Reproduce code:
---------------
$res = $PDO_DB->query("PRAGMA table_info(t1);");
echo "nb : ".$res->rowCount()."<br>";


Expected result:
----------------
the number of row, in this example, this will be return the number of table's columns.

Actual result:
--------------
nb : 0

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-11-21 15:25 UTC] ilia at prohost dot org
Sorry, but your problem does not imply a bug in PECL itself.  For a
list of more appropriate places to ask for help using PECL, please
visit http://pecl.php.net/support/ as this bug system is not the
appropriate forum for asking support questions. 

Thank you for your interest in PECL.

This is SQLite problem, the underlying library simply does not return the number of rows affected/returned by the PRAGMA operations.
 
PHP Copyright © 2001-2020 The PHP Group
All rights reserved.
Last updated: Sat Jan 18 14:01:23 2020 UTC