Changes between Version 3 and Version 5 of Ticket #29850


Ignore:
Timestamp:
Oct 9, 2019, 4:11:53 AM (5 years ago)
Author:
Mariusz Felisiak
Comment:

Exclusion is supported also on SQLite 3.28+ (see release notes).

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #29850 – Description

    v3 v5  
    1212----
    1313
    14 Frame exclusion is supported only in [https://www.postgresql.org/docs/11/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS PostgreSQL 11+], other databases do not support exclusion (see [https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Analytic-Functions.html#GUID-527832F7-63C0-4445-8C16-307FA5084056 Oracle 18c doc], [https://mariadb.com/kb/en/library/window-functions-overview/ MariaDB doc], and [https://dev.mysql.com/doc/refman/8.0/en/window-functions-frames.html MySQL doc]).
     14Frame exclusion is supported only in [https://www.postgresql.org/docs/11/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS PostgreSQL 11+] and [https://www.sqlite.org/windowfunctions.html#wexcls SQLite 3.28+], other databases do not support exclusion (see [https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Analytic-Functions.html#GUID-527832F7-63C0-4445-8C16-307FA5084056 Oracle 18c doc], [https://mariadb.com/kb/en/library/window-functions-overview/ MariaDB doc], and [https://dev.mysql.com/doc/refman/8.0/en/window-functions-frames.html MySQL doc]).
Back to Top