[ASTERIXDB-2488][COMP] Support aggregate window functions - user model changes: yes - storage format changes: no - interface changes: no
Details: - Implement aggregate window functions: agg_func() OVER (frame_var AS)? (PARTITION BY ... ORDER BY ... frame_spec) - Where agg_func is a SQL/SQL++ aggregate function - Fix percent_rank() to always return 0 for the first tuple - Fix ntile() to handle NULL argument - Log query after each rewrite rule in SqlppQueryRewriter - Implement toString() for ADayTimeDuration, fix it for AYearMonthDuration - Add seek() method to RunFileReader
[ASTERIXDB-2366][TEST] Optimizer tests cleanup for SQL++ - user model changes: no - storage format changes: no - interface changes: no
Details: The current optimizerTest actually doesn't use the SQL++ test cases. The existed test cases for SQLPP also have various issues. This patch cleans part of the test cases which failed at variable names changes in the result query plan.