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

Bug: Query Formater Problems With Some Formulas

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Bug: Query Formater Problems With Some Formulas

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • December 9, 2009 at 10:31 am #11784
      vygi
      Member

      Greetings,

      Queries like this cannot be formatted (F12) with SQLyog 8.2 anymore:

      Code:
      SELECT a_number, SUM(duration)/60 AS minutes FROM cdrs GROUP BY a_number

      Field “duration” holds call duration time in seconds and we often need minutes, therefore we're using formulas like “SUM(duration)/60” quite often.

      After upgrade to 8.2, these queries aren't being formatted anymore 🙁

      Greetings,

      Vygi

    • December 9, 2009 at 1:30 pm #30120
      navyashree.r
      Member

      Hi,

      Currently Formatter is not supported with queries using Function with arithmetic operators.

      We will improve this once we plan for an enhancement. Right now priority is not set.

      We added in same issue tracker,

      http://code.google.com/p/sqlyog/issues/detail?id=1174

      BTW FYI other formatting issues are listed here and will be considered later,

      http://code.google.com/p/sqlyog/issues/detail?id=979

      http://code.google.com/p/sqlyog/issues/detail?id=1112

      Regards,

      Navya

    • December 9, 2009 at 1:33 pm #30121
      vygi
      Member

      Yes, thanks; I thought it was working in previous verrsion, but it was not.

      Well…. let's wait and drink some coffee in the Christmas time 😉

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.