Edit report at http://bugs.php.net/bug.php?id=52600&edit=1
ID: 52600
Updated by: ahar...@php.net
Reported by: nicholas dot j dot miller at gmail dot com
Summary: MSSQL Money Fields Causes Segfault on SELECT
-Status: Open
+Status: Duplicate
Type: Bug
Package: PDO related
Operating System: CentOS 5.4
PHP Version: 5.2.14
Block user comment: N
New Comment:
Looks like a duplicate of bug #52546.
Previous Comments:
------------------------------------------------------------------------
[2010-08-13 18:03:51] nicholas dot j dot miller at gmail dot com
Description:
------------
After upgrading from PHP 5.2.13 to 5.2.14 select queries on MSSQL tables
with
columns of type MONEY will produce a segfault. When the MONEY column is
changed
to something like DECIMAL(10, 2), the segfault is no longer present. The
problem
ceases when php is downgraded to 5.2.13, indicating the issue to be with
the
current version.
A description of my environment is included below:
==================================================
OS: CentOS 5.4
DB Connector: FreeTDS (Tested with both 0.64 and 0.82)
HTTP Server: Apache 2.2.3
SQL: Microsoft SQL Server 2008 R2
Test script:
---------------
create a table with a column of type money
$dsn = 'dblib:dbname=mydatabase;host=mssql.example.com';
$user = 'REDACTED';
$password = 'REDACTED';
try {
$dbh = new PDO($dsn, $user, $password);
} catch (PDOException $e) {
echo 'Connection failed: ' . $e->getMessage();
}
foreach ($dbh->query('SELECT * FROM TableWithMoneyColumn') as $row) {
echo $row['AnyColumn'] . "\n";
}
Expected result:
----------------
A page with output from the database.
Actual result:
--------------
Blank screen with segfault present in apache's logs
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/bug.php?id=52600&edit=1
