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

From: Date: Mon, 28 Oct 2019 15:37:40 +0000
Subject: Bug #71652 [NoF->Dup]: Wrong float values will be returned
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-223492@lists.php.net to get a copy of this message 
Edit report at https://bugs.php.net/bug.php?id=71652&edit=1

 ID:                 71652
 Updated by:         cmb@php.net
 Reported by:        b dot vonheesen at maprom dot de
 Summary:            Wrong float values will be returned
-Status:             No Feedback
+Status:             Duplicate
 Type:               Bug
 Package:            PDO Firebird
 Operating System:   Ubuntu 14.04 LTS 64-Bit
 PHP Version:        7.0.3
-Assigned To:        
+Assigned To:        cmb
 Block user comment: N
 Private report:     N

 New Comment:

Actually, this is a duplicate of bug #65690.


Previous Comments:
------------------------------------------------------------------------
[2016-06-12 04:22:19] php-bugs at lists dot php dot net

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.

------------------------------------------------------------------------
[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.

------------------------------------------------------------------------


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

Thread (8 messages)

« previous php.bugs (#223492) next »