Bug #69474 [Fbk->Csd]: 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 Updated by: ab@php.net 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: Feedback +Status: Closed Type: Bug Package: ODBC related Operating System: Windows Server 2012 R2 PHP Version: 5.5.24 Assigned To: ab Block user comment: N Private report: N New Comment: Thanks for the testing. Closing then :) Previous Comments: ------------------------------------------------------------------------ [2015-04-18 17:06:54] heinrich dot moser dot jun at moware dot at Works fine with SQL Server as well. Thanks for the quick fix! ------------------------------------------------------------------------ [2015-04-17 23:03:03] cmb@php.net The re09febb snapshot works fine with the Access driver. ------------------------------------------------------------------------ [2015-04-17 18:48:12] ab@php.net Please check this snapshot (or any later) http://windows.php.net/downloads/snaps/php-5.5/re09febb/ Thanks for triaging. ------------------------------------------------------------------------ [2015-04-17 14:07:35] cmb@php.net Verified with MS Access Driver (6.01.7601.17632). According to the ODBC trace[1] the driver doesn't recognize SQL_DESC_BASE_COLUMN_NAME in the SQLColAttribute() calls. The issue seems to have been introduced in commit #899362d[2]. Anatol, can you please have a look. [1] <https://gist.github.com/cmb69/37147767adf0514674ee> [2] <https://github.com/php/php-src/commit/899362db6ed3131ff96f07e2d2b7f77c76ce9c40> ------------------------------------------------------------------------ [2015-04-17 11:17:00] heinrich dot moser dot jun at moware dot at Changed package from PDO ODBC to Database functions/ODBC related. Sorry for the initial miscategorization. ------------------------------------------------------------------------ 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=69474 -- Edit this bug report at https://bugs.php.net/bug.php?id=69474&edit=1