fetching rows, from a numeric(18,4) column gives wrong value when value is -1
| 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 | ||
[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 commits
[2004-06-28 13:28 UTC] abies@php.net