sraoss / pgsql-ivm

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

Contents are not consistent when citext type is used. #49

Closed yugo-n closed 2 years ago

yugo-n commented 4 years ago

IMMV is not consistent with the result of the definition query if this includes any column whose type allows user-visible differences between values which compare as equal according to the type's default btree opclass.

citext is an example of such types.

citext=# create extension citext ;
CREATE EXTENSION
citext=# create table t (v citext);
CREATE TABLE
citext=# insert into t values ('abc'),('ABC');
INSERT 0 2
citext=# create incremental materialized view mv as select * from t;
SELECT 1
citext=# select * from t;
  v  
-----
 abc
 ABC
(2 rows)

citext=# select * from mv;
  v  
-----
 abc
 abc
(2 rows)
yugo-n commented 2 years ago

This no longer occurs since #92