Bug #75271 [Fbk->NoF]: ODBC query result contains random memory blocks, source code

From: 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

« previous php.bugs (#212463) next »