[2015-04-17 10:05 UTC] 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
}