Five windowing functions that are returning incorrect results

There was an open bug from Calpont time, #5309. I retested all windows functions using the latest Calpont build and confirmed they are still not working. Here is the email that I sent out to group on April 29, 2016.

Hi, All;

I just want to provide everyone with an update on couple items regarding windowing testing for ColumnStore.

1) Windowing test cases, part of the autopilot test suite, has been fixed and is now working
a) I have an Oracle 11g XE instance setup and I was able to generate reference results for a 1mg TPCH database
b) I was able to run the test on the latest InfiniDB released by MariaDB (4.6.6-2). I have yet tried MariaDB ColumnStore.

2) Status of Windowing functions support on InfiniDB 4.6.6-2 (not ColumnStore)
My test results indicated that the following 5 functions are producing incorrect results.
NTH_VALUE
FIRST_VALUE
LAST_VALUE
LEAD
LAG
I reinstalled the latest release from InfiniDB (4.6.0-1) and still got the same incorrect results. I even regenerated the Oracle reference results and that did not help. I searched the old Bugzilla database from Calpont and there was bug 5309 with an OPEN status. The target milestone for the bug was set to release 5.0, which was never released, on March 9th, 2014. Therefore, we can conclude that the above functions are currently not working correctly and they need to be fixed in ColumnStore.

Let me know if you have questions

Thanks