search

sraoss / pgsql-ivm

IVM (Incremental View Maintenance) development for PostgreSQL
Other
129 stars 12 forks source link

SELECT statements with a TABLESAMPLE clause should be rejected. #80

Closed nuko-yokohama closed 4 years ago

nuko-yokohama commented 4 years ago

SELECT statements with a TABLESAMPLE clause should be rejected.

Currently, CREATE INCREMENTAL MATERIALIZED VIEW allows SELECT statements with the TABLESAMPLE clause. However, the result of this SELECT statement is undefined and should be rejected when specified in CREATE INCREMENTAL MATERIALIZED VIEW. (similar to handling non-immutable functions)

thoshiai commented 4 years ago

Thank you for your pointing out this issue. it was fixed a short time ago. Please close this issue if there is no problem.

nuko-yokohama commented 4 years ago

Commit ID = b2e620958da6a6f402c4a64389f730f510746281 Version confirmed that the problem was fixed (reject SELECT with TABLE SAMPLE). This issue closes.