php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #52600 MSSQL Money Fields Causes Segfault on SELECT
Submitted: 2010-08-13 18:03 UTC Modified: 2010-08-13 18:24 UTC
From: nicholas dot j dot miller at gmail dot com Assigned:
Status: Duplicate Package: PDO related
PHP Version: 5.2.14 OS: CentOS 5.4
Private report: No CVE-ID: None
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: nicholas dot j dot miller at gmail dot com
New email:
PHP Version: OS:

 

 [2010-08-13 18:03 UTC] 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2010-08-13 18:24 UTC] aharvey@php.net
-Status: Open +Status: Duplicate
 [2010-08-13 18:24 UTC] aharvey@php.net
Looks like a duplicate of bug #52546.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Mon Oct 14 10:01:28 2024 UTC