php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #28897 fetching rows, from a numeric(18,4) column gives wrong value when value is -1
Submitted: 2004-06-23 18:58 UTC Modified: 2004-06-28 13:28 UTC
From: john at ceressoft dot nl Assigned:
Status: Closed Package: InterBase related
PHP Version: 4.3.7/5.0.0-dev OS: Linux, 2.6.6
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: john at ceressoft dot nl
New email:
PHP Version: OS:

 

 [2004-06-23 18:58 UTC] john at ceressoft dot nl
Description:
------------
fetching rows, from a numeric(18,4) column  gives wrong value (-0.0000) when value is -1

I verified this with iboconsole, and i can see that the correct value is in the database and iboconsole also returns the correct value.

Reproduce code:
---------------
<?php
$db = ibase_connect("server:/mydb.fdb", "SYSDBA", "mypass");
if ($db)
$q = ibase_query($db, "select * from test");
if($q)
 while($row = ibase_fetch_row($q))
	var_dump($row);
?>

Test table:

CREATE TABLE TEST
(
testcol numeric(18,4)
);



Expected result:
----------------
-1.0000

Actual result:
--------------
-0.0000

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-06-28 13:28 UTC] abies@php.net
This bug has been fixed in CVS.

Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
 
Thank you for the report, and for helping us make PHP better.


 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Nov 21 15:01:30 2024 UTC