Submitted by: @asfernandes

Jira_subtask_inward CORE1688
Is related to QA634

Because CORE1688 "ANSI SQL2003 Window Functions" is not a small feature, I'll create subtasks for it when implementing pieces.

This one needs much more tests and work, but it's started with good results. :-)

SQL> select * from t;

      N1           N2 

============ ============
1 11
2 22
5 55

SQL> select
CON> n1,
CON> n2,
CON> count(*) over (),
CON> min(n1) over (),
CON> max(n1) over(),
CON> min(n2) over (),
CON> max(n2) over (),
CON> list(n1) over (),
CON> list(n2) over ()
CON> from t;

      N1           N2        COUNT          MIN          MAX          MIN          MAX              LIST              LIST 

============ ============ ============ ============ ============ ============ ============ ================= =================
1 11 3 1 5 11 55 0:22 0:21

LIST:
1,2,5

==============================================================================
LIST:
11,22,55

       2           22            3            1            5           11           55              0:22              0:21 

==============================================================================
LIST:
1,2,5

==============================================================================
LIST:
11,22,55

       5           55            3            1            5           11           55              0:22              0:21 

==============================================================================
LIST:
1,2,5

==============================================================================
LIST:
11,22,55

Commits: d88b5cf 0145996 ed0e0da FirebirdSQL/fbt-repository@d94f3c2