#25210 [NEW]: Invalid resource when using query with derived tables

From: jack at vanzanen dot com Operating system: United Linux 1.0 PHP version: 4.3.2 PHP Bug Type: MySQL related Bug description: Invalid resource when using query with derived tables Description: ------------ I have installed MYSQL 4.1 with support for derived tables. If I query Mysql with a query that has a subquery in the from clause it works fine. If I now load this query in PHP I get invalid resource error. If I change the select for another select w/o the subquery it works fine (So my php script must be correct). I have tried PHP 4.3.2/4.3.3 & 5.0 TIA Jack Reproduce code: --------------- http://www.vanzanen.com/source.txt Expected result: ---------------- I expect the query to produce data that is shown on the screen as a html table Actual result: -------------- $result is not a valid resource -- Edit bug report at http://bugs.php.net/?id=25210&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=25210&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=25210&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=25210&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=25210&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=25210&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=25210&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=25210&r=support Expected behavior: http://bugs.php.net/fix.php?id=25210&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=25210&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=25210&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=25210&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=25210&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=25210&r=dst IIS Stability: http://bugs.php.net/fix.php?id=25210&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=25210&r=gnused