Bug #19703 group by with and?
Submitted: 11 May 2006 2:53 Modified: 12 May 2006 17:22
Reporter: gang chen Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version: OS:Linux (redhat9)
Assigned to: CPU Architecture:Any

[11 May 2006 2:53] gang chen 
Description:
I wondered that 'group by' can with 'and'?what does it mean? 

How to repeat:
select vslcd,voy,pn from tb_dj_d_portcall group by vslcd and voy =5;
[12 May 2006 17:22] Valeriy Kravchuk 
It is interpreted as:

select vslcd,voy,pn from tb_dj_d_portcall group by (vslcd and voy =5);

and is not a bug. Read http://dev.mysql.com/doc/refman/5.0/en/group-by-hidden-fields.html for the details:

"MySQL does allow expressions in GROUP BY  clauses."