sraoss / pgsql-ivm

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

IMMV including expressions of aggregate results doesn't work #96

Open yugo-n opened 4 years ago

yugo-n commented 4 years ago
postgres=# create table s (i numeric, j numeric);
CREATE TABLE
postgres=# create view v_s as select sum(i)*0.5 as a, sum(i)/sum(j) as b from s;
CREATE VIEW
postgres=# create incremental materialized view mv_s as select sum(i)*0.5 as a, sum(i)/sum(j) as b from s;
SELECT 1
postgres=# select * from mv_s; select * from v_s;
 a | b 
---+---
   |  
(1 row)

 a | b 
---+---
   |  
(1 row)

postgres=# insert into s values (1,2);
INSERT 0 1
postgres=# select * from mv_s; select * from v_s;
 a | b 
---+---
   |  
(1 row)

  a  |           b            
-----+------------------------
 0.5 | 0.50000000000000000000
(1 row)