|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2015-04-17 11:17 UTC] heinrich dot moser dot jun at moware dot at
-Package: PDO ODBC
+Package: ODBC related
[2015-04-17 11:17 UTC] heinrich dot moser dot jun at moware dot at
[2015-04-17 14:07 UTC] cmb@php.net
-Status: Open
+Status: Verified
-Assigned To:
+Assigned To: ab
[2015-04-17 14:07 UTC] cmb@php.net
[2015-04-17 18:48 UTC] ab@php.net
-Status: Verified
+Status: Feedback
[2015-04-17 18:48 UTC] ab@php.net
[2015-04-17 23:03 UTC] cmb@php.net
[2015-04-18 17:06 UTC] heinrich dot moser dot jun at moware dot at
[2015-04-19 23:10 UTC] ab@php.net
-Status: Feedback
+Status: Closed
[2015-04-19 23:10 UTC] ab@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Tue Oct 28 03:00:02 2025 UTC |
Description: ------------ An ODBC query which created a correct result with PHP 5.5.23 produces an incorrect result with PHP 5.5.24. Tested on Windows Server 2012 R2 with SQL Server 2012. How to reproduce: 1. Create an empty database and create the table with the test script given. 2. Create a system DSN called "forum" which connects to the database. 3. Execute the test script given with PHP 5.5.23 and 5.5.24 and compare the results. Test script: --------------- Database: CREATE TABLE table1 (topic_id int); CREATE TABLE table2 (topic_id int); INSERT INTO table1 (topic_id) VALUES (1023); Code: <?php date_default_timezone_set('Europe/Vienna'); $link = odbc_connect("forum", "", ""); $sql = "SELECT table1.topic_id, table2.topic_id AS X FROM table1 LEFT JOIN table2 ON table1.topic_id = table2.topic_id WHERE table1.topic_id = 1023"; $result = odbc_exec($link, $sql); $topic_data = odbc_fetch_array($result); var_dump($topic_data); odbc_free_result($result); odbc_close($link); ?> Expected result: ---------------- This is the script output I get with PHP 5.5.23: array(2) { ["topic_id"]=> string(4) "1023" ["X"]=> NULL } Actual result: -------------- This is the script output I get with PHP 5.5.24: array(1) { ["topic_id"]=> NULL }