MySQL Bugs: #19617: little queries are not logged with log_queries_not_using

Bug #19617	little queries are not logged with log_queries_not_using_indexes
Submitted:	8 May 2006 15:19	Modified:	11 May 2006 11:50
Reporter:	Oli Sennhauser	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: General	Severity:	S3 (Non-critical)
Version:	5.1.9	OS:	any?
Assigned to:		CPU Architecture:	Any

Description:
Little queries are not logged with log_queries_not_using_indexes. Eigther docu bug or bug.

How to repeat:
CREATE TABLE test (id);
INSERT INTO test VALUES (1), (2), (3);
EXPLAIN SELECT * FROM test;
SELECT * FROM test;

--> Slow query log is empty.

Suggested fix:
Fix eigther code or docu.

Thank you for the bug report. I don't think it is a bug for that query to
be logged is necessary to have the condition to be a low query according
the value of long_query_time. Then I forced that situation:

c:\mysql\bin>mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.21-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT * FROM test;
+------+
| id   |
+------+
| 1    |
| 2    |
| 3    |
+------+
3 rows in set (0.00 sec)

mysql> exit
Bye

c:\mysql\bin>type c:\mysql\data\low.log
mysqld-nt, Version: 5.0.21-log. started with:
TCP Port: 0, Named Pipe: (null)
Time                 Id Command    Argument
# Time: 060510 12:44:22
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 3  Rows_examined: 3
use test;
SELECT * FROM test;

c:\mysql\bin>type c:\my.ini
[mysqld]
log-slow-queries=c:/mysql/data/low.log
log-queries-not-using-indexes
long_query_time=0
c:\mysql\bin>

Do you agree?

Thanks in advance.

Hi Miguel

Sorry. I did something realy wrong! I could not reproduce my problem anymore. Sorry for trouble!
Oli