v.22.6Experimental Feature

PR: Update ENGINE Syntax Behavior in WINDOW VIEW to Match MATERIALIZED VIEW

Official CH changelog text
This PR changes the behavior of the ENGINE syntax in WINDOW VIEW, to make it like in MATERIALIZED VIEW. #37214 (vxider).
Updated the behavior of the ENGINE syntax in WINDOW VIEW to match the semantics used in MATERIALIZED VIEW.

Why it matters

This change ensures consistent and predictable behavior when specifying the ENGINE clause in WINDOW VIEW definitions, aligning it with the established logic of MATERIALIZED VIEW. This resolves potential confusion and improves the usability of window views.

How to use it

Define the WINDOW VIEW with the ENGINE clause similarly as you would in a MATERIALIZED VIEW. The syntax and behavior are now consistent, so users can apply their knowledge of materialized views to window views.

Related resources

PreviousNext