Bug #71652 [Com]: Wrong float values will be returned
Edit report at https://bugs.php.net/bug.php?id=71652&edit=1
ID: 71652
Comment by: chris dot spb25 at gmail dot com
Reported by: b dot vonheesen at maprom dot de
Summary: Wrong float values will be returned
Status: Open
Type: Bug
Package: PDO Firebird
Operating System: Ubuntu 14.04 LTS 64-Bit
PHP Version: 7.0.3
Block user comment: N
Private report: N
New Comment:
these fields are numeric (15,2)
Expected result:
stdClass Object
(
[PEDVRTOTAL] => 32.5
[PEDVRDESCTO] => 0
[PEDVRDESCTOSER] => 0
[TOTAL_FINAL] => 32.5
)
Actual result:
stdClass Object
(
[PEDVRTOTAL] => 2065761874.56
[PEDVRDESCTO] => 3096554025.60
[PEDVRDESCTOSER] => 4127346176.64
[TOTAL_FINAL] => 10312099082.88
)
Previous Comments:
------------------------------------------------------------------------
[2016-03-22 15:07:08] chris dot spb25 at gmail dot com
result of my query:
See the attribute values:
PEDVRTOTAL
PEDVRDESCTO
PEDVRDESCTOSER
TOTAL FINAL
[0] => stdClass Object
(
[ID_PEDIDO] => 218488
[PEDDTEMIS] => 2015-12-01 00:00:00
[PEDCODIGO] => 206265.001
[PEDVRTOTAL] => 2065761874.56
[PEDVRDESCTO] => 3096554025.60
[PEDVRDESCTOSER] => 4127346176.64
[EMPCODIGO] => 1
[EMPRAZSOCIAL] => WINNIKES IND. E COM. DE OCULOS LTDA
[PEDDTSAIDA] =>
[PEDORDEMCOMPRA] =>
[TOTAL_FINAL] => 10312099082.88
[NFCODIGO] => 000002.3
[NFDTEMIS] => 2015-12-01 00:00:00
)
------------------------------------------------------------------------
[2016-03-22 14:56:40] chris dot spb25 at gmail dot com
I also am with this same problem.
I'm using php 7.0.4 nts 32bit on windows platform.
------------------------------------------------------------------------
[2016-03-03 13:45:30] cmb@php.net
This appears to be a duplicate of bug #65690.
------------------------------------------------------------------------
[2016-02-23 15:41:42] b dot vonheesen at maprom dot de
Description:
------------
Starting position:
Ubuntu 14.04 LTS 64-Bit, PHP 7.0.3
Interbase with dialect 1
All columns of type NUMERIC return wrong values.
The returned value is the ordinal position multiplied with 0.4 instead of the correct value.
Sorry, I don't know how to use git diff so I created a diff with
diff -Naur firebird_statement.c firebird_statement.new > patch.c
Test script:
---------------
$pdo = new PDO('firebird:...');
$pdo->query('CREATE TABLE test (id INTEGER, name VARCHAR(20), price NUMERIC(15,2), price2
NUMERIC(15,2))');
$pdo->query('INSERT INTO test(id, name, price, price2) VALUES(1, 'Test1', 6.45,
7.25)');
$pdo->query('SELECT id, name, price FROM test');
$result = $pdo->fetchAll();
Expected result:
----------------
$result = [
[
'id' => 1, // column 0
'name' => 'Test1', // column 1
'price' => 6.45, // column 2
'price2' => 7.25 // column 3
]
Actual result:
--------------
$result = [
'id' => 1, // column 0
'name' => 'Test1', // column 1
'price' => 0.8, // column 2: 0.4 * 2
'price2' => 1.2 // column 3: 0.4 * 3
]
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=71652&edit=1
Thread (8 messages)