Bug? Parser problem with OFFSET i subquery

Toad for Oracle
1

This works fine to execute

SELECT 1
  FROM DUAL
 WHERE 1 IN (SELECT 2
               FROM DUAL
             OFFSET 0 ROWS
              FETCH NEXT 1 ROWS ONLY)

But Toad complains about an error on "ONLY", the syntax error simply says "Parser: ORA-SQL-PLSQL". I'm on Toad version 15.0.97.1178.

2

This is a regression appearing in Toad 14.1.84.872 of Feb 8 (parser version 5.364).
To be fixed, of course. (QP-3932)

Thanks for reporting!
Andre

3

Fixed ---------

4

I have Toad for Oracle 15.0.97.1178.

I have error when formatting it.

How can I fix the problem ?

I opened another Thread few months ago: My Post

Error:

[Error] Syntax check (8: 33): ERROR: line 7, column 33, ending line 7, column 36: Found 'only': This statement may be ambiguous, please report it to Quest Software
Parser: ORA-SQL-PLSQL, on line: 2, context: select 1
from dual
where 1 in (select 2
from dual
offset 0 rows
fetch next 1 rows only)

5

Hello,
As said in Bug? Parser problem with OFFSET i subquery it was to be fixed (and has been fixed) in issue QP-3932. It will become available to the Toad team in the coming week.

Thanks,
Andre