Changes between Version 5 and Version 10 of Ticket #29850
- Timestamp:
- Feb 2, 2023, 3:02:02 AM (23 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #29850
- Property Keywords GSoC added
- Property Cc added
-
Ticket #29850 – Description
v5 v10 12 12 ---- 13 13 14 Frame 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]).14 Frame exclusion is supported in [https://www.postgresql.org/docs/11/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS PostgreSQL 11+], [https://www.sqlite.org/windowfunctions.html#wexcls SQLite 3.28+], and [https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/Analytic-Functions.html#GUID-527832F7-63C0-4445-8C16-307FA5084056 Oracle 21c+] other databases do not support exclusion ([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]).