Released: Feb 19, 2016

Updates in this release

Updates in v3.6.0

• [sql formatter] fix a bug can't format case expression in a plus expression.
• [sql server] support try_parse() function.
• [sql formatter] add new format option gfmtopt.onlyinsertblankaftergo to support: BLANK LINES only after "GO" statements this option works only gfmtopt.insertblanklineinbatchsqls is true.
• [sql formatter] new option option: gfmtopt.CTE_StackColumnList to stack column list in CTE.
• [SQL Server] support set clause in alter table statement.
• [Oracle] fix a bug can't parse syntax like: v_return_value.year in plsql.
• [Oracle] fix a bug can't parse query when "log" used as table or column name.
• [SQL Server] support TRY_CAST function.
• [SQL Server] support parse function.
• [SQL Server] fix a bug XML can't be column name.
• [Oracle] support enable validate clause in alter table statement.
• [SQL Server] support alter index statement by adding TAlterIndexSqlStatement.
• [Oracle] support interval value in analytic function.
• [Oracle] able to parse pivot/unpivot clause. full parse tree is still not available.
• [SQL Server] fix a but can't parse begin try/end catch statement if there is no statement inside catch block.
• [SQL Server] fix a but can't parse begin try/end catch statement when it's the only statement in a stored procedure.
• [SQL Server] support CLOSE SYMMETRIC KEY.
• [MySQL] support delimiter command.
• [Oracle] fix a bug can't parse sort clause in XMLAGG function.
• [format option] add new option: analyticFunctionInNewline, default is true.
• [SQL Server] support offset/fetch clause in order by clause.