Bug #68301 [Opn->Fbk]: Empty results when querying more than a couple columns
Edit report at https://bugs.php.net/bug.php?id=68301&edit=1
ID: 68301
Updated by: cmb@php.net
Reported by: evan dot king at bluespurs dot com
Summary: Empty results when querying more than a couple
columns
-Status: Open
+Status: Feedback
Type: Bug
Package: ODBC related
Operating System: ubuntu 14.04 64bit, centos 64bit
PHP Version: 5.5.18
Block user comment: N
Private report: N
New Comment:
The problem might be related to bug #68087. Please try PHP 5.5.19
or newer.
Previous Comments:
------------------------------------------------------------------------
[2014-10-24 16:00:05] evan dot king at bluespurs dot com
Description:
------------
I'm connecting to an Intersystems Cache database through an SSH tunnel, using either php5-odbc
or PDO (doesn't matter which) and a DSN connection string. When I write a query that fetches
many columns, PHP gets no records. I can run the same complete query using iSQL (unixODBC) on the
command line and get correct data, and can convince PHP to return data if I reduce the number of
colums queried to no more than about 2 or 3. It does not appear to matter what datatypes are being
fetched - the result can be broken by adding an integer or date field to the select, for example.
The problem arose some time after PHP 5.5.14 and is still present in 5.5.18. As a temporary
workaround we're replacing the odbc .so file using the one from 5.5.14, and with that all
queries still work.
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=68301&edit=1
Thread (3 messages)