1 Reply Latest reply on Jan 25, 2019 6:08 PM by Vadim Tropashko-Oracle

    Wrong parser warning reported when using inverse distribution functions as window functions

    Lukas Eder

      SQL Developer 18.4.0.376 / Build 376.1900 reports a parser warning on the following two queries, which are both correct

       

      SELECT

        i,

        percentile_cont(0.5) WITHIN GROUP (ORDER BY i) OVER()

      FROM (

        SELECT 1 i FROM dual UNION ALL

        SELECT 2 i FROM dual UNION ALL

        SELECT 3 i FROM dual

      ) t

      ORDER BY i;

       

      SELECT

        i,

        percentile_cont(0.5) WITHIN GROUP (ORDER BY i) OVER(PARTITION BY i)

      FROM (

        SELECT 1 i FROM dual UNION ALL

        SELECT 2 i FROM dual UNION ALL

        SELECT 3 i FROM dual

      ) t

      ORDER BY i;