id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
29850	Add window support for RowRange frames	Daniel Fuchs	nobody	"The current RowRange frame is missing handling for several cases.

None of the following are currently supported:
RowRange(start=-2, end=-1)
ROWS BETWEEN 2 PRECEDING AND 1 PRECEDING
RowRange(start=1, end=2)
ROWS BETWEEN 1 FOLLOWING AND 2 FOLLOWING

It's also missing support for EXCLUDE.
ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING EXCLUDE CURRENT ROW

----

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]).
"	New feature	new	Database layer (models, ORM)	master	Normal				Accepted	0	0	0	0	0	0