| Bug #60070 | Beautify Query deletes grouped functions when beautifying | ||
|---|---|---|---|
| Submitted: | 10 Feb 2011 0:41 | Modified: | 8 Jun 2011 18:02 |
| Reporter: | Aldo Fregoso | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench: SQL Editor | Severity: | S2 (Serious) |
| Version: | 5.2.31 CE | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | beautify query | ||
[10 Feb 2011 0:49]
Aldo Fregoso
Changed synopsis to a more suitable one
[10 Feb 2011 4:11]
Valeriy Kravchuk
Verified on Mac OS X.
[8 Jun 2011 18:02]
Paul DuBois
Noted in 5.2.32 changelog. The query beautifier deleted aggregate function text.
Description: Beautifier deletes grouped functions How to repeat: Beautifying the following query: SELECT GROUP_CONCAT(DATE_FORMAT(pa.pago_aplicacion_fecha_hora,'%d/%m/%Y') ORDER BY pa.pago_aplicacion_fecha_hora ASC SEPARATOR ', ') AS fechas_pago FROM factura Turns into: SELECT GROUP_CONCAT ( ORDER BY pa.pago_aplicacion_fecha_hora ASC SEPARATOR ', ' ) AS fechas_pago FROM factura so DATE_FORMAT(pa.pago_aplicacion_fecha_hora,'%d/%m/%Y') is completely lost