Uploaded image for project: 'Hue (READ ONLY)'
  1. Hue (READ ONLY)
  2. HUE-4062

[editor] Formatting action add extra spaces after group by and skip LIMIT

          Details

          • Type: Bug
          • Status: Resolved
          • Priority: Major
          • Resolution: Fixed
          • Affects Version/s: 3.10.0
          • Fix Version/s: 3.11.0
          • Component/s: app.editor
          • Labels:
            None
          • Target Version:
          • Sprint:
            Jul 5-22, 2016

            Description

            select addresses['shipping'].state, count(*) as ct from customer_orders group by addresses['shipping'].state order by ct limit 100

            gives

            SELECT addresses['shipping'].state, count(*) AS ct
FROM customer_orders
GROUP BY  addresses['shipping'].state
ORDER BY  ct limit 100

            Probably better:

            SELECT addresses['shipping'].state, count(*) AS ct
FROM customer_orders
GROUP BY addresses['shipping'].state
ORDER BY ct
LIMIT 100

            ?

              Attachments

                Activity

                  People

                  • Assignee:
                    enricoberti Enrico Berti
                    Reporter:
                    romain Romain Rigaux
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: