Released: Mar 13, 2015

Updates in this release

Updates in v3.5.0

• support new databases: informix, postgresql, sybase,Teradata.
• [sql formatter] stack on parameters on a FETCH NEXT cursor if parameter number more than 5.
• [sql formatter] fix a bug that remove linebreak between sql statements while set ouput to "keep layout"
• [format options] wordSeparator, if this option was set, use this token to separate word in variable/identifier/name. this option works when CaseOption = coInitCapEachWord. if gfmtopt.wordSeparator = '-', take identifier: dec_seq_Event_Global_Beg for example, first letter of dec, seq, Event, Global, Beg will be set to uppercase. (Desktop version: Formatter Options->Capitalisation. Add-In version: Format options->Capitalisation )
• [format options] addMissingSemicolon, add semicolon after statement if it's missing. works for sql server only. Don't add semicolon after GO statement. (Desktop version: Formatter Options->Refactor. Add-In version: Format options->Default Options )
• [format options] add new format option: keepCommentAfterColumn, commaInsideList option must be set to false to make this option works correctly. (Desktop version: Formatter Options->Select. Add-In version: Format options->Select )

this format option work when Select_Columnlist_Comma = before comma,

select ename, -- first column
sal, dname
from emp;

when keepCommentAfterColumn = false;
SELECT ename
,-- first column
sal
,dname
FROM emp;

when keepCommentAfterColumn = true;
SELECT ename -- first column
,sal
,dname
FROM emp;

actually, this option changes the position of comment which should be
put after first comma.

• [SQL Server] support waitfor, receive, writetext, OPEN SYMMETRIC KEY statement
• [SQL Server] fix some parse errors.
• [Oracle] fix some parse errors.
• [DB2] The keywords NEXTVAL and PREVVAL can be used as alternatives for NEXT VALUE and PREVIOUS VALUE respectively.
• [MySQL] support charset of char datatype in cast function