Bug #68301 [NEW]: Empty results when querying more than a couple columns
From: evan dot king at bluespurs dot com
Operating system: ubuntu 14.04 64bit, centos 64bit
PHP version: 5.5.18
Package: ODBC related
Bug Type: Bug
Bug description:Empty results when querying more than a couple columns
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 bug report at https://bugs.php.net/bug.php?id=68301&edit=1
--
Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=68301&r=trysnapshot54
Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=68301&r=trysnapshot55
Try a snapshot (trunk): https://bugs.php.net/fix.php?id=68301&r=trysnapshottrunk
Fixed in SVN: https://bugs.php.net/fix.php?id=68301&r=fixed
Fixed in release: https://bugs.php.net/fix.php?id=68301&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=68301&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=68301&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=68301&r=oldversion
Not developer issue: https://bugs.php.net/fix.php?id=68301&r=support
Expected behavior: https://bugs.php.net/fix.php?id=68301&r=notwrong
Not enough info: https://bugs.php.net/fix.php?id=68301&r=notenoughinfo
Submitted twice: https://bugs.php.net/fix.php?id=68301&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=68301&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=68301&r=php4
Daylight Savings: https://bugs.php.net/fix.php?id=68301&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=68301&r=isapi
Install GNU Sed: https://bugs.php.net/fix.php?id=68301&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=68301&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=68301&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=68301&r=mysqlcfg
Thread (3 messages)
- evan dot king at bluespurs dot com