Bug #60867 QUERY ERROR - "WHERE" IS OMMITED

• Submitted: 14 Apr 2011 9:54
• Modified: 14 May 2011 10:11
• Reporter: fernando diaz toledano
• Status: No Feedback
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 6.0.5-alpha-community
• OS: Any
• CPU Architecture: Any

[14 Apr 2011 9:54] fernando diaz toledano

Description:
SELECT sum(1) CT,a.COD_ARTICULO,a.DESC_ARTICULO,a.GRUPO FROM lineas l,articulos a
WHERE l.COD_ART=a.COD_ARTICULO AND (a.GRUPO="99999" OR a.GRUPO="99997")
GROUP BY a.COD_ARTICULO ORDER BY CT DESC LIMIT 10

WHEN LIMIT AND ORDER BY SUM OR COUNT(*) IN A GROUP, "WHERE" IS OMITED

http://62.43.206.251:8090/bugmysql.wmv

How to repeat:
Video demostration
http://62.43.206.251:8090/bugmysql.wmv

Suggested fix:
REMOVE LIMIT...

[14 Apr 2011 10:05] Valeriy Kravchuk

Version 6.0.5 is not supported. Please, check if the problem is repeatable with any currently supported version, 5.0.92, 5.1.56 or 5.5.11.

[14 Apr 2011 10:07] fernando diaz toledano

if REPLACE GROUP BY a.COD_ARTICULO -> GROUP BY l.COD_ART
WORKS FINE!

[14 Apr 2011 10:11] Valeriy Kravchuk

Nobody is going to fix anything in 6.0.5, so, please, check with recent versions.

[14 May 2011 23: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".