ID: 37285
Updated by: [EMAIL PROTECTED]
Reported By: vldi at yahoo dot com
-Status: Open
+Status: Assigned
Bug Type: PDO related
Operating System: Suse 10
PHP Version: 5CVS-2006-05-02 (snap)
-Assigned To:
+Assigned To: wez
Previous Comments:
------------------------------------------------------------------------
[2006-05-02 21:05:00] vldi at yahoo dot com
Description:
------------
PDO does not raise the exception when SQL fails.
Config is: './configure' '--prefix=/usr/local/php5' '--with-openssl'
'--with-kerberos' '--with-zlib' '--with-bz2' '--enable-calendar'
'--with-curl' '--with-curlwrappers' '--enable-exif' '--enable-ftp'
'--with-gettext' '--with-ldap' '--with-ldap-sasl'
'--with-mssql=/usr/local/freetds' '--with-mysql' '--with-mysql-sock'
'--with-mysqli' '--with-unixODBC=/usr' '--with-pdo-mysql'
'--with-pdo-odbc=unixODBC,/usr' '--enable-sockets' '--enable-sysvmsg'
'--enable-sysvsem' '--enable-sysvshm' '--with-xsl' '--with-pear'
'--disable-cgi' '--with-apxs2=/usr/local/apache2/bin/apxs'
'--with-config-file-path=/etc/php.ini' '--enable-debug'
Reproduce code:
---------------
<html><body>
<?php
$dsn =
'DRIVER=FreeTDS;SERVERNAME=server1;DATABASE=testdb;UID=user1;';
$dbuser='foolproof';
$dbpassword='';
$dbh = null;
try {
$dbh = new PDO('odbc:'.$dsn, $dbuser, $dbpassword );
if ( ! $dbh ) {
print "<p>No DBH</p></body></html>";
die();
};
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$dbh->exec("
create procedure pdotest
@param_in int = null,
@param_out int output
as
set @param_out = @param_in
go
");
} catch ( PDOException $e ) {
print "<p>Failed: ".$e->getMessage()."</p></body></html>";
die();
}
?>
<p>Succedeed</p>
</body></html>
Expected result:
----------------
Expect to either see the new procedure created, or exception raised.
Actual result:
--------------
The page displays "Succeesed", yet no procedure created in the
database.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=37285&edit=1
