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: 

This topic contains 0 replies, has 1 voice, and was last updated by  RL Byrd 1 week ago.

  • 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?

You must be logged in to reply to this topic.