Bug #71652 [Fbk->NoF]: Wrong float values will be returned

Edit report at https://bugs.php.net/bug.php?id=71652&edit=1 ID: 71652 Updated by: php-bugs@lists.php.net Reported by: b dot vonheesen at maprom dot de Summary: Wrong float values will be returned -Status: Feedback +Status: No Feedback Type: Bug Package: PDO Firebird Operating System: Ubuntu 14.04 LTS 64-Bit PHP Version: 7.0.3 Private report: N New Comment: No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Re-Opened". Thank you. Previous Comments: ------------------------------------------------------------------------ [2016-05-29 16:41:38] ab@php.net Currently i don't reproduce this issue with Firebird 2.5.5. Doing "SET SQL DIALECT 1" before your snippet, but the behavior is correct. Could you please provide a bit more precise reproduce way? Also, probably *100 is not what one wants to have, fe if the column definition were NUMERIC(15,3). Thanks. ------------------------------------------------------------------------ [2016-03-22 15:22:58] chris dot spb25 at gmail dot com 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 ) ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=71652 -- Edit this bug report at https://bugs.php.net/bug.php?id=71652&edit=1