ASPN ActiveState Programmer Network
ActiveState
/ Home / Perl / PHP / Python / Tcl / XSLT /
/ Safari / My ASPN /
Cookbooks | Documentation | Mailing Lists | Modules | News Feeds | Products | User Groups


Recent Messages
List Archives
About the List
List Leaders
Subscription Options

View Subscriptions
Help

View by Topic
ActiveState
.NET Framework
Open Source
Perl
PHP
Python
Tcl
Web Services
XML & XSLT

View by Category
Database
General
SOAP
System Administration
Tools
User Interfaces
Web Programming
XML Programming


MyASPN >> Mail Archive >> php-dev
php-dev
#37026 [NEW]: PDOStatemenet::execute() returns always false
by Kubis At Pawouk Dot Net other posts by this author
Apr 9 2006 12:47PM messages near this date
#37027 [NEW]: mkdir($dir, 0777, true) does NOT chmod created directory | #37026 [Opn->Bgs]: PDOStatemenet::execute() returns always false
From:             kubis at pawouk dot net
Operating system: Windows XP
PHP version:      5.1.2
PHP Bug Type:     PDO related
Bug description:  PDOStatemenet::execute() returns always false

Description:
------------
PDOStatement::execute() returns false even if the statement has been
executed correctly.

I have tried it with PDO drivers for postgresql packaged with PHP version
5.1, it returns correctly true, but with version 5.2.1 it returns false. I
ran into this problem while executing unit tests after an upgrade.

According to manual page should PDOStatement::execute() return true if the
statement has been executed properly or false if not

Reproduce code:
---------------
try {
	$db = DBShop::getInstance();	//
	$stmt = $db-> prepare('SELECT 1 AS testcolumn1, 2 AS testcolumn2');
	$count1 = $stmt-> columnCount();
	$res = $stmt-> execute();
	$count2 = $stmt-> columnCount();
} catch (Exception $e){
	$fail[] = self::errorMsg($e, 'Unable to test columnCount()');
	break;
}
$this-> assertTrue($res, 'DBStatement::execute() returned false, should be
true');
$this-> assertSame(2, $count2, 'DBStatement::columnCount() did not return
expected value');

Expected result:
----------------
no failure in unit test:
- $res is true
- $count2 is 2

Actual result:
--------------
PHPUnit reports "DBStatement::execute() returned false, should be true",
so $res is not true; but $count2 is integer of value 2, thus the statement
has been executed properly

-- 
Edit bug report at http://bugs.php.net/?id=37026&edit=1
-- 
Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=37026&r=trysnapshot44
Try a CVS snapshot (PHP 5.1): http://bugs.php.net/fix.php?id=37026&r=trysnapshot51
Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=37026&r=trysnapshot60
Fixed in CVS:                 http://bugs.php.net/fix.php?id=37026&r=fixedcvs
Fixed in release:             http://bugs.php.net/fix.php?id=37026&r=alreadyfixed
Need backtrace:               http://bugs.php.net/fix.php?id=37026&r=needtrace
Need Reproduce Script:        http://bugs.php.net/fix.php?id=37026&r=needscript
Try newer version:            http://bugs.php.net/fix.php?id=37026&r=oldversion
Not developer issue:          http://bugs.php.net/fix.php?id=37026&r=support
Expected behavior:            http://bugs.php.net/fix.php?id=37026&r=notwrong
Not enough info:              http://bugs.php.net/fix.php?id=37026&r=notenoughinfo
Submitted twice:              http://bugs.php.net/fix.php?id=37026&r=submittedtwice
register_globals:             http://bugs.php.net/fix.php?id=37026&r=globals
PHP 3 support discontinued:   http://bugs.php.net/fix.php?id=37026&r=php3
Daylight Savings:             http://bugs.php.net/fix.php?id=37026&r=dst
IIS Stability:                http://bugs.php.net/fix.php?id=37026&r=isapi
Install GNU Sed:              http://bugs.php.net/fix.php?id=37026&r=gnused
Floating point limitations:   http://bugs.php.net/fix.php?id=37026&r=float
No Zend Extensions:           http://bugs.php.net/fix.php?id=37026&r=nozend
MySQL Configuration Error:    http://bugs.php.net/fix.php?id=37026&r=mysqlcfg
Thread:
Kubis At Pawouk Dot Net
edink
Kubis At Pawouk Dot Net

Privacy Policy | Email Opt-out | Feedback | Syndication
© ActiveState Software Inc. All rights reserved