#35450 [NEW]: mysqli extension reports too many warnings

From: jellicle at gmail dot com Operating system: Debian PHP version: 5.1.0 PHP Bug Type: MySQLi related Bug description: mysqli extension reports too many warnings Description: ------------ Mysqli extension throws too many warnings. For example, "SELECT * FROM table" results in a warning: "Warning: mysqli::query(): No index used in query/prepared statement SELECT * FROM table ..." There's no way to have MySQL use an index when selecting all records, so this warning appears every time one wants to select all records from any table. Sometimes Mysqli gives this warning even when MySQL is apparently using an index (i.e. the same query, executed with EXPLAIN, says it's using an index). Mysqli should give warnings only on real problems. Not using an index is at most worthy of a notice, not a warning, especially when there's no way to use an index with a particular query! -- Edit bug report at http://bugs.php.net/?id=35450&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=35450&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=35450&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=35450&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=35450&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=35450&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=35450&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=35450&r=needscript Try newer version: http://bugs.php.net/fix.php?id=35450&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=35450&r=support Expected behavior: http://bugs.php.net/fix.php?id=35450&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=35450&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=35450&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=35450&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=35450&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=35450&r=dst IIS Stability: http://bugs.php.net/fix.php?id=35450&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=35450&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=35450&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=35450&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=35450&r=mysqlcfg