Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3677

Wrong result with LEAD window function when used in multiple windows in the same query

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Invalid
    • Affects Version/s: 1.2.0
    • Fix Version/s: 1.2.0
    • Component/s: Functions - Drill
    • Labels:
      None

      Description

      Query produces wrong result:

      select
              c_integer,
              lead(c_integer) over (order by c_integer),
              lead(c_integer) over (partition by c_time order by c_date)
      from
              j1
      ;
      

      Attached: q46.res (result generated from postgres)
      q46.out (output from Drill)
      j1.tar - table used in the query

      I tried to reproduce the same error on a smaller data set without any success. Tried with the table with the same data as j1, but single parquet file: same behavior.

        Attachments

        1. j1.tar
          1.03 MB
          Victoria Markman
        2. q46.out
          278 kB
          Victoria Markman
        3. q46.res
          278 kB
          Victoria Markman

          Activity

            People

            • Assignee:
              adeneche Deneche A. Hakim
              Reporter:
              vicky Victoria Markman
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: