Bug #75271 [Fbk->NoF]: ODBC query result contains random memory blocks, source code
| From: | php-bugs at lists dot php dot net | Date: | Sun, 05 Nov 2017 04:22:55 +0000 |
| Subject: | Bug #75271 [Fbk->NoF]: ODBC query result contains random memory blocks, source code | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-212463@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=75271&edit=1
ID: 75271
Updated by: php-bugs@lists.php.net
Reported by: charlie at csdv dot co
Summary: ODBC query result contains random memory blocks,
source code
-Status: Feedback
+Status: No Feedback
Type: Bug
Package: PDO ODBC
Operating System: Windows, MacOS
PHP Version: 7.1.9
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:
------------------------------------------------------------------------
[2017-09-28 08:53:11] ab@php.net
Thanks for the report. Please post also the table definition, the relevant data and the expected
result, too. Which particular driver is involved?
Thanks.
------------------------------------------------------------------------
[2017-09-27 23:31:33] charlie at csdv dot co
Description:
------------
Behavior exists in 5.5, 5.6, and 7.1.
When querying a database via PDO ODBC, some fields are returning unexpected results which appear to
be uninitialized memory, bits of the source PHP file that ran the script, other PHP files that were
included, etc.
I've run this same query via Golang and other GUIs and the correct data is returned.
Example output:
Array
(
[0] => Array
(
[body] => Lorem ipsum�/**
* Finds the path to the file where the class is defined.
*
* @param string $class The name of the class
*
* @return string|false The path if found, false otherwise
Since it's working as expected when querying via other languages/tools, I'm thinking the
issue is within PDO and not the driver. Any direction on this issue would be much appreciated.
Test script:
---------------
$connection = new
PDO("odbc:Driver=driver;Server=hostname;Database=dbname;Uid=uid;Pwd=pwd;");
$result = $connection
->query("SELECT body FROM posts WHERE id = 123")
->fetchAll(PDO::FETCH_ASSOC);
print_r($result);
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=75271&edit=1