#35450 [Opn->Bgs]: mysqli extension reports too many warnings
ID: 35450
Updated by: tony2001@php.net
Reported By: jellicle at gmail dot com
-Status: Open
+Status: Bogus
Bug Type: MySQLi related
Operating System: Debian
PHP Version: 5.1.0
New Comment:
Use mysqli_report() to disable that.
Previous Comments:
------------------------------------------------------------------------
[2005-11-28 16:35:26] jellicle at gmail dot com
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 this bug report at http://bugs.php.net/?id=35450&edit=1
Thread (3 messages)