Com_empty_query

Hi,
 I was trying to find out what would trigger the counter on Com_empty_query and my two test cases do not trigger it:

mysql> SHOW STATUS LIKE 'Com_empty%';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| Com_empty_query | 0     |
+-----------------+-------+
1 row in set (0.00 sec)

mysql> SELECT * FROM foo WHERE bar=2;
Empty set (0.03 sec)

mysql> ;
ERROR: 
No query specified

mysql> SHOW STATUS LIKE 'Com_empty%';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| Com_empty_query | 0     |
+-----------------+-------+
1 row in set (0.00 sec)

Looking at the source, it seems to get triggered on an END_OF_INPUT in the query section of 'sql_yacc.yy' (assuming the query is syntactically correct). sql_lex.cc is the only instance that returns an END_OF_INPUT (after a lip->eof()), but I can't seem to trigger it.

Is this triggered on a breakdown from the client, or on a certain type of (reproducible) query?

Thanks,
 Derek Downey
-- 
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe:    http://lists.mysql.com/[email protected]