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

[10 Dec 2012 9:04] anh nx
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.
[10 Dec 2012 10:00] MySQL Verification Team
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
[10 Dec 2012 14:51] anh nx
Shane Bester: thanks for your answer
[14 Jan 2013 1:00] Bugs System
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".