Skip to Main Content

"with" and "group by" syntax highlighting bug

Alexey AnisimovSep 1 2015 — edited Sep 1 2015

Hi,

Version 4.1.1.19 Build MAIN-19.59 of Oracle SQL Developer doesn't properly uderstand queries with "group by" clauses inside "with" block.

select owner, sum(bytes)    bytes

  from dba_segments

group by owner;

with

  u as (select owner, sum(bytes)    bytes

          from dba_segments

         group by owner)

select * from u;

While both queries are valid, in the second example it underlines query with yellow line and suggest wrong replacement: add sum(bytes) to group by clause.

orasqldev_with_group_by_bug.png

Comments
Post Details
Added on Sep 1 2015
1 comment
302 views