php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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 Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
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

Pull Requests

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-2025 The PHP Group
All rights reserved. 		Last updated: Tue Jul 01 21:01:35 2025 UTC