[FORMATTING] plsql - keyword "rows"

[sosoba]

Input data

Which SQL and options did you provide as input?

select * from dual offset 5 rows fetch next 10 rows only

Expected Output

SELECT
  *
FROM
  dual
OFFSET
  5 ROWS
FETCH NEXT
  10 ROWS ONLY

Actual Output

SELECT
  *
FROM
  dual
OFFSET
  5 rows
FETCH NEXT
  10 rows ONLY

Usage

• How are you calling / using the library?
  JS API and playground
• What SQL language(s) does this apply to?
  plsql
• Which SQL Formatter version are you using?
  15.4.8

It seems that rows are treated as identifier not keyword here.

[nene]

Thanks for reporting.

Unfortunately SQL Formatter is unable to properly distinguish between keywords and identifiers. There are basically two bad choices for it:

• list lots as words as keywords and risk detecting normal identifiers as keywords
• list only a few words as keywords and risk not detecting them

SQL Formatter takes the latter approach.

Or put in another way: I could "fix" this bug by introducing another bug.