ID: 11595
Updated by: ahill
Reported By: nicolasperalta@bigfoot.com
Old Status: Assigned
Status: Closed
Bug Type: ODBC related
Operating System: Solaris 2.7
PHP Version: 4.0.4pl1
Assigned To: ahill
New Comment:
unable to duplicate, no feedback
Previous Comments:
------------------------------------------------------------------------
[2001-07-30 12:08:34] ahill@php.net
Hi,
Please try with 4.0.6 or submit an ODBC trace; I am unable to reproduce.
Best regards,
Andrew
------------------------------------------------------------------------
[2001-07-09 16:08:07] ahill@php.net
Nico,
Can you please generate a trace? I expect we will see a problem in the SQLPrepare where it's
dropping your subquery.
To enable tracing, add or uncomment the following line in the $ODBCINI file:
DebugFile=/tmp/opl_debug.out
and then please paste the resultant trace in.
Best regards,
Andrew Hill
OpenLink Software
------------------------------------------------------------------------
[2001-06-26 17:59:09] kalowsky@php.net
assigning to ahill as he knows openlink best :)
------------------------------------------------------------------------
[2001-06-21 11:13:00] nicolasperalta@bigfoot.com
Sorry,
message error:
Warning: SQL error: [OpenLink][ODBC][Driver]General error, SQL state S1000 in SQLPrepare in
/psitio/multihomed/www.elsitio.com/pub/cgi-bin/gl/av/player/test.php3 on line 19
The most strange is that I reduce the query string "SELECT P.* FROM REAL_CAT_PADRE P WHERE
IDIOMA = 'C' AND P.ID_PADRE IN ( SELECT ID_HIJO FROM REAL_CAT_HIJO )" to "SELECT
P.* FROM REAL_CAT_PADRE P WHERE IDIOMA = 'C'" it works fine IN PHP4...
I don't know is very strange.
Nico.
------------------------------------------------------------------------
[2001-06-21 11:10:52] kalowsky@php.net
marking as feedback until user responds...
------------------------------------------------------------------------
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
http://bugs.php.net/?id=11595
Edit this bug report at http://bugs.php.net/?id=11595&edit=1