Bug #69474 [Opn]: ODBC: Query with same field name from two tables returns incorrect result

Edit report at https://bugs.php.net/bug.php?id=69474&edit=1 ID: 69474 User updated by: heinrich dot moser dot jun at moware dot at Reported by: heinrich dot moser dot jun at moware dot at Summary: ODBC: Query with same field name from two tables returns incorrect result Status: Open Type: Bug -Package: PDO ODBC +Package: ODBC related Operating System: Windows Server 2012 R2 PHP Version: 5.5.24 Block user comment: N Private report: N New Comment: Changed package from PDO ODBC to Database functions/ODBC related. Sorry for the initial miscategorization. Previous Comments: ------------------------------------------------------------------------ [2015-04-17 10:05:19] heinrich dot moser dot jun at moware dot at 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 } ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=69474&edit=1