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

Sql Formatter Shoul Be Enhanced

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Sql Formatter Shoul Be Enhanced

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • December 14, 2009 at 9:02 am #11791
      [email protected]
      Member

      1.

      UNION

      2.

      CASE-WHEN

      3.

      unlimited number of levels or Subqueries

      I am waiting for these features…

    • December 15, 2009 at 4:54 am #30146
      navyashree.r
      Member

      Hi,

      Currently SQL Formatter has some limitations:

      1. Subqueries are supported only upto three levels for every query (but an unlimited number of JOIN constructs are supported).

      2. Special constructions not supported includes,

      * SELECT statement used as argument to a function (like “SELECT IF((SELECT ….),'true','false')”)

      * Various types of SELECT … CASE … and SELECT … IF… constructions

      * UNIONS clauses are not handled.

      We will improve SQL FORMATTER 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 all will be considered later while enhancing this feature,

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

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

      Regards,

      Navya

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