SQLinForm SQL FormatterCommunity Discussion Forum
SQLinForm SQL Formatter
I am using 6.22.7
I noticed that any column or alias that begins with the word "RETURN" will not format correctly
For example, the two sql statement below:
SELECT RETURNX from dual;
select a as returnx from dual;
will be formatted as:
SELECT
RETURNX from dual;
SELECT a AS
RETURNX from dual;
It appears that a line feed/carriage is put if the formatter sees the characters "RETURN" in the beginning of a column or alias.
If this is a configuration issue, please let me know.
Thank you.
Hi,
many thanks for your feedback.
This looks like a parsing error. Probably regex expression is not precise enough.
Will fix this with the next release
Are you using the windows desktop app or the N++ plugin?
Regards
Guido
I am using the n++ plugin.
Also, it is not limited to column. It appears also table names that begin with characters "RETURN" also have the issue.
Original statement: SELECT C1, c2 as return_check, RETURN_FLAG FROM RETURN_TABLE;
Format Results:
SELECT c1
, c2 AS
RETURN_CHECK
,
RETURN_FLAG from
RETURN_TABLE;
Thanks for the quick reply.
@sqldeveloper10202 I think I found the error. Just to double-check. Are you working with "Any SQL", "DB2" or "Oracle" as DB?
Regards
Guido
the fix has been published. Could you please download and install the newest version and give it a try
The latest update solved the issue. Thanks for pushing out the fix.
