From: gms08701 at yahoo dot com Operating system: windows 2000 sp4 PHP version: 4CVS-2003-08-16 (stable) PHP Bug Type: ODBC related Bug description: SQLExecDirect error with CLOB column in SQL
Description: ------------ Using w2k sp4, mdac 2.8, ibm db2 8.1.3, windows native ODBC. Trying to do a select with a table join with a CLOB column in the select list, is not executing. If selecting a CLOB column without table joins executes correctly. The very same sql (with the table joins) works correctly via ibm db2's command line. You can get a bit more detail at http://dbforums.com/showthread.php?postid=3247451 Reproduce code: --------------- <?php $conn = odbc_connect ('IBM DB2', 'user', 'pass'); //$sql = "select options from NULLID.config where name = 'foo'"; $sql = "SELECT c.options FROM NULLID.config c, NULLID.modules m WHERE c.name = 'foo' AND c.name = m.name"; $result = odbc_exec( $conn, $sql ); odbc_result_all($result); ?> Expected result: ---------------- Warning: odbc_exec(): SQL error: [IBM][CLI Driver][DB2/NT] SQL0270N Function not supported (Reason code = "63"). SQLSTATE=42997 , SQL state 42997 in SQLExecDirect in C:\Inetpub\wwwroot\z.php on line 7 -- Edit bug report at http://bugs.php.net/?id=25112&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=25112&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=25112&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=25112&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=25112&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=25112&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=25112&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=25112&r=support Expected behavior: http://bugs.php.net/fix.php?id=25112&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=25112&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=25112&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=25112&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=25112&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=25112&r=dst IIS Stability: http://bugs.php.net/fix.php?id=25112&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=25112&r=gnused
