Bug #65690 [Fbk->NoF]: PDO_Firebird returns wrong results with numeric 15,2 and dialect 1

From: Date: Sun, 15 Jul 2018 04:22:21 +0000
Subject: Bug #65690 [Fbk->NoF]: PDO_Firebird returns wrong results with numeric 15,2 and dialect 1
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-216330@lists.php.net to get a copy of this message
Edit report at https://bugs.php.net/bug.php?id=65690&edit=1

 ID:               65690
 Updated by:       php-bugs@lists.php.net
 Reported by:      slavb18 at gmail dot com
 Summary:          PDO_Firebird  returns wrong results with numeric 15,2
                   and dialect 1
-Status:           Feedback
+Status:           No Feedback
 Type:             Bug
 Package:          PDO Firebird
 Operating System: any
 PHP Version:      5.4.19
 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:
------------------------------------------------------------------------
[2018-07-06 19:32:57] ab@php.net

@slavb18, could you please check with the suggestion of @dorin? This might be a bigger piece, but
Firebird needs maintanance. Otherwise, as only dialect 3 seems to be supported well and dialect 1 is
mentioned as quasi deprecated in the doc, this ticket could be considered obsolete.

Thanks.

------------------------------------------------------------------------
[2017-01-30 08:18:19] dorin dot marcoci at gmail dot com

Slavb18,

I found this patch not so viable across Firebird dialects.
It just check for SQL_DOUBLE and sqlscale, behavior that may change and/or be different across
existing or next dialects.

Currently PDO driver connects by default using 3rd dialect and no other handling is done in terms of
specifics.

A nice solution will be to read and take into account the database dialect when connecting to a FB
database and on next operations like data fetches, parameters handling, etc...

------------------------------------------------------------------------
[2017-01-09 10:23:38] slavb18 at gmail dot com

dialect 1 is still used in legacy databases, why not fix, if patch exists for three years

------------------------------------------------------------------------
[2017-01-09 06:42:28] dorin dot marcoci at gmail dot com

Still anyone uses dialect 1? It is pending to be deprecated.
Is it worth to fix this bug? It will involve additional FB specific flag/parameter to PDO, in order
to deal right with dialects.

------------------------------------------------------------------------
[2016-03-03 13:45:31] cmb@php.net

Related To: Bug #71652

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


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=65690


--
Edit this bug report at https://bugs.php.net/bug.php?id=65690&edit=1


Thread (10 messages)

« previous php.bugs (#216330) next »