#30896 [NEW]: mysql(i)_fetch_*() fails on "SELECT * FROM t"

From: niklas dot lampen at publico dot com Operating system: Linux Debian PHP version: 5.0.2 PHP Bug Type: MySQLi related Bug description: mysql(i)_fetch_*() fails on "SELECT * FROM t" Description: ------------ Fetching rows fail on both mysql_() and mysqli_() when query is simple "SELECT *". Not working: "SELECT * FROM t ORDER BY f" Working: "SELECT * FROM t WHERE 1=1 ORDER BY f" "SELECT * FROM t ORDER BY f LIMIT n" "SELECT f, f2, f3, f4 FROM t ORDER BY f" Reproduce code: --------------- $Res = mysql_query("SELECT * FROM t ORDER BY f", $Conn); $R = mysql_fetch_object($Res); var_dump($R); Expected result: ---------------- object(stdClass)#2 (4) { ["f"]=> string(4) "data" ["f2"]=> string(4) "data" ["f3"]=> string(4) "data" ["f4"]=> string(4) "data" } Actual result: -------------- object(stdClass)#2 (2) { ["@"]=> string(8) "#CERT11#" ["
"]=> string(0) "" } -- Edit bug report at http://bugs.php.net/?id=30896&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=30896&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=30896&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=30896&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=30896&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=30896&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=30896&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=30896&r=needscript Try newer version: http://bugs.php.net/fix.php?id=30896&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=30896&r=support Expected behavior: http://bugs.php.net/fix.php?id=30896&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=30896&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=30896&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=30896&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=30896&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=30896&r=dst IIS Stability: http://bugs.php.net/fix.php?id=30896&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=30896&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=30896&r=float MySQL Configuration Error: http://bugs.php.net/fix.php?id=30896&r=mysqlcfg