Edit report at https://bugs.php.net/bug.php?id=65690&edit=1
ID: 65690
Comment by: slavb18 at gmail dot com
Reported by: slavb18 at gmail dot com
Summary: PDO_Firebird returns wrong results with numeric
15,2 and dialect 1
Status: Open
Type: Bug
Package: PDO related
Operating System: any
PHP Version: 5.4.19
Block user comment: N
Private report: N
New Comment:
forget to attach php script:
...
$sql="select * FROM TESTPDO";
$sth = $pdo->prepare($sql);
$sth->execute();
$obj = $sth->fetch();
print_r($obj);
Previous Comments:
------------------------------------------------------------------------
[2013-09-17 13:14:57] slavb18 at gmail dot com
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 this bug report at https://bugs.php.net/bug.php?id=65690&edit=1
