[MDEV-32054] Materialized views, PostgreSQL style Created: 2023-08-31  Updated: 2024-01-28

Status: Open
Project: MariaDB Server
Component/s: Views
Fix Version/s: None

Type: New Feature Priority: Major
Reporter: Michael Widenius Assignee: Unassigned
Resolution: Unresolved Votes: 2
Labels: None

Issue Links:
Relates
relates to MDEV-12163 Support for Materialized Views Open
relates to MDEV-32053 New features requested by customer on... Open

 Description   

The task is to create materialized views similar to PostgreSQL.

CREATE MATERIALIZED VIEW table_name
[ (column_name [, ...] ) ]
AS query
[ WITH [ NO ] DATA ]

The view will create an internal table that is filled when the table is created and updated when
REFRESH MATERIALIZED VIEW is executed.

See https://www.postgresql.org/docs/current/sql-creatematerializedview.html for details



 Comments   
Comment by Tamino Elgert [ 2024-01-28 ]

Is there any information on when or whether this will be implemented? I think it would be very useful, thank you in advance.

Comment by Sergei Golubchik [ 2024-01-28 ]

No specific plans at the moment yet

Generated at Thu Feb 08 10:28:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.