Edit report at http://bugs.php.net/bug.php?id=51203&edit=1
ID: 51203
Updated by: pierrick@php.net
Reported by: rolf at winmutt dot com
Summary: PDO prepared statements, execute returns false on
second call without parameter
-Status: Open
+Status: Duplicate
Type: Bug
Package: MySQL related
Operating System: Debian
PHP Version: 5.3.1
New Comment:
This is the same bug as #45120 which was fixed in 5.3.2.
Previous Comments:
------------------------------------------------------------------------
[2010-03-04 15:49:23] rolf at winmutt dot com
Description:
------------
$sth->execute() returns false on second run but fetchColumn still
returns a value.
Test script:
---------------
$db = new PDO('mysql:dbname=XXXX;unix_socket=/tmp/mysql.sock;','XXXX',
'XXXX');
$sth2 = $db->prepare("SELECT id FROM users ORDER BY RAND()");
$sth2->execute();
$ret=$sth2->fetchColumn();
echo $ret."\n";
$fail=$sth2->execute();
$ret=$sth2->fetchColumn();
var_dump($fail, $ret);
$sth = $db->prepare("SELECT 1 FROM users where active=?");
if ($sth->execute(array(1))) {
$ret=$sth->fetch();
echo "1\n";
} else die("poo pdo\n");
if ($sth->execute(array(1))) {
$ret=$sth->fetch();
echo "2\n";
} else die(var_export($db->errorInfo(), true));
$sth1 = $db->prepare("SELECT 1 FROM users where active=1");
if ($sth1->execute()) {
$ret=$sth1->fetch();
echo "1\n";
} else die("poo pdo\n");
if ($sth1->execute()) {
$ret=$sth1->fetch();
echo "2\n";
} else die(var_export($db->errorInfo(), true));
die;
Expected result:
----------------
1033
bool(true)
string(4) "1142"
1
2
1
2
Actual result:
--------------
1033
bool(false)
string(4) "1142"
1
2
1
array (
0 => '00000',
1 => NULL,
2 => NULL,
)
Relevant strace :
lose(4) = 0
socket(PF_FILE, SOCK_STREAM, 0) = 4
fcntl64(4, F_GETFL) = 0x2 (flags O_RDWR)
fcntl64(4, F_SETFL, O_RDWR|O_NONBLOCK) = 0
connect(4, {sa_family=AF_FILE, path="/tmp/mysql.sock"...}, 17) = 0
fcntl64(4, F_SETFL, O_RDWR) = 0
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1
([{fd=4, revents=POLLIN}])
recv(4, "8\0\0\0\n5.1.42-log\0\336\1\0\0JSE@MERN\0\377\367\10\2"...,
8192, MSG_DONTWAIT) = 60
send(4,
"G\0\0\1\215\242\7\0\0\0\0\300\10\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"...,
75, MSG_DONTWAIT) = 75
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1
([{fd=4, revents=POLLIN}])
recv(4, "\7\0\0\2\0\0\0\2\0\0\0"..., 8192, MSG_DONTWAIT) = 11
send(4, "%\0\0\0\3SELECT id FROM users ORDER B"..., 41, MSG_DONTWAIT) =
41
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1
([{fd=4, revents=POLLIN}])
recv(4, "\1\0\0\1\1,\0\0\2\3def\10mynatnet\5users\5user"..., 8192,
MSG_DONTWAIT) = 8192
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1
([{fd=4, revents=POLLIN}])
recv(4,
"1606\5\0\0\221\0041487\5\0\0\222\0041560\5\0\0\223\0041310\5\0"...,
8192, MSG_DONTWAIT) = 7275
write(1, "1318\n"..., 5) = 5
send(4, "%\0\0\0\3SELECT id FROM users ORDER B"..., 41, MSG_DONTWAIT) =
41
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1
([{fd=4, revents=POLLIN}])
recv(4, "\1\0\0\1\1,\0\0\2\3def\10mynatnet\5users\5user"..., 8192,
MSG_DONTWAIT) = 8192
poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1
([{fd=4, revents=POLLIN}])
recv(4,
"\0\0\220\0042199\5\0\0\221\0041211\5\0\0\222\0041024\5\0\0\223\00423"...,
8192, MSG_DONTWAIT) = 7275
write(1, "bool(false)\n"..., 12) = 12
write(1, "string(4) \""..., 11) = 11
write(1, "1607"..., 4) = 4
write(1, "\"\n"..., 2) = 2
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/bug.php?id=51203&edit=1