exec: deletions not processed correctly in transformed tables

metadb-project / metadb

Metadb extends PostgreSQL with features to support analytics such as streaming data sources, data model transforms, and historical data

Apache License 2.0

8 stars 2 forks source link

Closed nassibnassar closed 1 year ago

nassibnassar commented 1 year ago

A record known to be deleted appears to be still present in the transformed table:

SELECT a.id AS id1, b.id AS id2
    FROM folio_users.users__t AS a
        LEFT JOIN folio_users.users AS b ON a.id=b.id
    WHERE b.id IS NULL;

                 id1                  | id2
--------------------------------------+-----
 14eb3416-7de4-49be-a11f-df2a057e1d5d |
(1 row)

nassibnassar commented 1 year ago

closed by 119905f7a8785f5c7d4909286c4fafc1539e3e91