Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"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
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 29 2015
Added on Sep 1 2015
1 comment
562 views