Unsupported Screen Size: The viewport size is too small for the theme to render properly.

SQL Formatter adding space after functions

forums forums SQLyog SQLyog: Bugs / Feature Requests SQL Formatter adding space after functions

Tagged: 

Viewing 1 reply thread
  • Author
    Posts
    • #36178
      RL Byrd
      Participant

      Version: 13.1.1 64 bit Windows.

      I note that the SQL formatter, which I use all the time, now is manifesting an irritating bug.

      This:

      SELECT
        COUNT(*) AS event_insert_count,
        created_at
      FROM
        unit_event
      GROUP BY DATE(created_at),
        HOUR(created_at),
        MINUT (created_at)
      ORDER BY event_insert_count ASC;

      is being formatted to this:

      SELECT
        COUNT (*) AS event_insert_count,
        created_at
      FROM
        unit_event
      GROUP BY DATE (created_at),
        HOUR (created_at),
        MINUT (created_at)
      ORDER BY event_insert_count ASC;

      Note the spaces after COUNT and DATE. Adding this space renders the statement unexecutable. I’ve checked in settings to see if this can be avoided, but apparently not.

      (a) is there a place to get rid of this space, and failing that (b) can I get this tagged as a bug?

    • #36257
      sdaggumati
      Participant

      Did you ever end up getting a resolution on this? My best take on this is that it has to do with the version of SQLyog that you’re running. Seems to work without the bugs on the v12, v13 has this issue I believe.

Viewing 1 reply thread
  • You must be logged in to reply to this topic.