Bug #65690 [NEW]: PDO_Firebird returns wrong results with numeric 15,2 and dialect 1

From: Date: Tue, 17 Sep 2013 13:14:57 +0000
Subject: Bug #65690 [NEW]: PDO_Firebird returns wrong results with numeric 15,2 and dialect 1
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-181627@lists.php.net to get a copy of this message 
From:             slavb18 at gmail dot com
Operating system: any
PHP version:      5.4.19
Package:          PDO related
Bug Type:         Bug
Bug description:PDO_Firebird  returns wrong results with numeric 15,2 and dialect 1

Description:
------------
PDO_Firebird  returns wrong results with numeric (15,2) and dialect 1
dialect 1 returns numeric (15,2) as  SQL_DOUBLE and sqlscale < 0,

I know this was reported before but this report is with patch 

Test script:
---------------
create or alter procedure testpdo
returns (
    res numeric(15,2),
    res2 numeric(5,2))
as
begin
  RES=123.45;
  RES2=123.45;
  suspend;
end

Expected result:
----------------
Array
(
    [RES] => 123.45
    [0] => 123.45
    [RES2] => 123.45
    [1] => 123.45
)


Actual result:
--------------
Array
(
    [RES] => 0.04
    [0] => 0.04
    [RES2] => 123.45
    [1] => 123.45
)


(or any other number istead of 0.04 as variable "n" is unitilized in case
of SQL_DOUBLE)

-- 
Edit bug report at https://bugs.php.net/bug.php?id=65690&edit=1
-- 
Try a snapshot (PHP 5.4):   https://bugs.php.net/fix.php?id=65690&r=trysnapshot54
Try a snapshot (PHP 5.3):   https://bugs.php.net/fix.php?id=65690&r=trysnapshot53
Try a snapshot (trunk):     https://bugs.php.net/fix.php?id=65690&r=trysnapshottrunk
Fixed in SVN:               https://bugs.php.net/fix.php?id=65690&r=fixed
Fixed in release:           https://bugs.php.net/fix.php?id=65690&r=alreadyfixed
Need backtrace:             https://bugs.php.net/fix.php?id=65690&r=needtrace
Need Reproduce Script:      https://bugs.php.net/fix.php?id=65690&r=needscript
Try newer version:          https://bugs.php.net/fix.php?id=65690&r=oldversion
Not developer issue:        https://bugs.php.net/fix.php?id=65690&r=support
Expected behavior:          https://bugs.php.net/fix.php?id=65690&r=notwrong
Not enough info:            https://bugs.php.net/fix.php?id=65690&r=notenoughinfo
Submitted twice:            https://bugs.php.net/fix.php?id=65690&r=submittedtwice
register_globals:           https://bugs.php.net/fix.php?id=65690&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=65690&r=php4
Daylight Savings:           https://bugs.php.net/fix.php?id=65690&r=dst
IIS Stability:              https://bugs.php.net/fix.php?id=65690&r=isapi
Install GNU Sed:            https://bugs.php.net/fix.php?id=65690&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=65690&r=float
No Zend Extensions:         https://bugs.php.net/fix.php?id=65690&r=nozend
MySQL Configuration Error:  https://bugs.php.net/fix.php?id=65690&r=mysqlcfg

Thread (10 messages)

« previous php.bugs (#181627) next »