SQL Pretty Printer v3.6.0 updated
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.