MySQL Bugs: #67859: problem with com

Bug #67859	problem with com_select
Submitted:	10 Dec 2012 9:04	Modified:	14 Jan 2013 5:21
Reporter:	anh nx	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:		OS:	Windows (windows xp)
Assigned to:		CPU Architecture:	Any

Description:
I have a problem with com_select:
I have a query:
select A.com_select, B.Qcache_hits
   from
   (SELECT G.`variable_value` as com_select
   FROM `information_schema`.global_Status G
   where G.variable_name = "com_select" ) A,
   (SELECT G.`variable_value` as Qcache_hits
   FROM `information_schema`.global_Status G
   where G.variable_name = "Qcache_hits" ) B;
-------------------------
I execute by MySQL tool gui, result is:
com_select = 2;
-------------------------
execute by MySQL command line, result is:
com_select = 1;
-----------------------------------
each query has executed by tool gui, com_select always increase 2.
each query has executed by command line, com_select only increase 1.
why does execute by command line different from  execute by tool gui?

How to repeat:
comment on bug.

You can enable general query log and see exactly what the clients/gui are running.
I doubt there is any bug here...

http://dev.mysql.com/doc/refman/5.5/en/query-log.html

Shane Bester: thanks for your answer

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".