1 Reply Latest reply on Sep 1, 2015 9:09 PM by Vadim Tropashko-Oracle

    "with" and "group by" syntax highlighting bug

    Alexey Anisimov

      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