Add tests for UNBOUNDED syntax ambiguity
authorPeter Eisentraut <peter@eisentraut.org>
Thu, 1 Jul 2021 07:17:44 +0000 (09:17 +0200)
committerPeter Eisentraut <peter@eisentraut.org>
Thu, 1 Jul 2021 07:27:05 +0000 (09:27 +0200)
commit71ba45a3602da0bdbb518e16e3990cfcf21e5f73
treef4a96f29aa5818d575e5a29b94595e0cf4a4230e
parent3788c66788e9f8c6904c6fe903724c1f44812c4d
Add tests for UNBOUNDED syntax ambiguity

There is a syntactic ambiguity in the SQL standard.  Since UNBOUNDED
is a non-reserved word, it could be the name of a function parameter
and be used as an expression.  There is a grammar hack to resolve such
cases as the keyword.  Add some tests to record this behavior.

Reviewed-by: Heikki Linnakangas <hlinnaka@iki.fi>
Discussion: https://www.postgresql.org/message-id/flat/b2a09a77-3c8f-7c68-c9b7-824054f87d98%40enterprisedb.com
src/test/regress/expected/window.out
src/test/regress/sql/window.sql