Issues

• DISTINCT ON silently becomes full-row DISTINCT

  ila/openivm#155 · Filter by author 10xjs opened on Nov 6, 2026
  1

• Projection over DISTINCT fails CREATE with missing openivm_distinct_count in EXCLUDE

  ila/openivm#154 · Filter by author lunstb opened on Nov 5, 2026
  1

• Filtered-group COUNT(*) refresh ignores the inner WHERE predicate

  ila/openivm#153 · Filter by author lunstb opened on Nov 5, 2026

• GROUP_RECOMPUTE retains a deleted group when matching rows are removed from both join inputs

  ila/openivm#152 · Filter by author lunstb opened on Nov 5, 2026

• DISTINCT aux-state SUM returns 0 instead of NULL after the last non-NULL value is deleted

  ila/openivm#151 · Filter by author lunstb opened on Nov 5, 2026

• Refreshing COUNT(*) + 1 adds the constant again and returns the wrong count

  ila/openivm#150 · Filter by author lunstb opened on Nov 5, 2026

• A global window beside a partitioned window retains stale values after refresh

  ila/openivm#149 · Filter by author lunstb opened on Nov 5, 2026

• FILTER on FIRST and ARG_MIN_NULL returns wrong results already at MV creation

  ila/openivm#148 · Filter by author lunstb opened on Nov 5, 2026

• AVG/STDDEV/VARIANCE(DISTINCT) are maintained as occurrence-weighted aggregates

  ila/openivm#140 · Filter by author lunstb opened on Oct 20, 2026

• Generated-column source boundary drops virtual rowid binding during MV creation

  ila/openivm#138 · Filter by author ila opened on Oct 19, 2026

• Correlated LATERAL projection creates successfully but refresh emits an unbound scalar column

  ila/openivm#137 · Filter by author ila opened on Oct 19, 2026

• Projected rowid is replaced by multiplicity during incremental refresh, leaving incorrect rows

  ila/openivm#136 · Filter by author ila opened on Oct 19, 2026

• Generated-column identities are lost through table macros and query_table

  ila/openivm#135 · Filter by author ila opened on Oct 19, 2026

• PRAGMA refresh runs before preceding statements in a submitted SQL batch

  ila/openivm#134 · Filter by author ila opened on Oct 16, 2026

• DROP VIEW CASCADE leaves dependent materialized views in another metadata catalog

  ila/openivm#126 · Filter by author ila opened on Oct 15, 2026

• Refreshing a window-function view inside BEGIN/COMMIT fails with a binder error

  ila/openivm#116 · Filter by author ak2k opened on Oct 10, 2026

• Loadable extension: autocommit refresh drops a LEFT JOIN group whose count falls to zero

  ila/openivm#115 · Filter by author ak2k opened on Oct 10, 2026
  1

• LEFT JOIN + GROUP BY loses a group when a new left row's only match is removed in the same batch

  ila/openivm#114 · Filter by author ak2k opened on Oct 10, 2026

• West of UTC, refresh discards every change

  ila/openivm#113 · Filter by author ak2k opened on Oct 10, 2026

• DuckLake MV refresh leaves stale rows after CLI reopen with SQLite metadata

  ila/openivm#99 · Filter by author ila opened on Oct 1, 2026

• Document compiling views for Spark (input dialect, Spark hints, add_months, compile-only entry point)

  documentation
  ila/openivm#93 · Filter by author ila opened on Sep 30, 2026

• Loading OpenIVM turns preserve_insertion_order off database-wide, and PRAGMA refresh resets a session's explicit setting

  documentationrobustness
  ila/openivm#92 · Filter by author ila opened on Sep 30, 2026

• Duplicate CREATE MATERIALIZED VIEW reports internal names; concurrent duplicate fails with a raw write-write conflict

  concurrencyrobustness
  ila/openivm#91 · Filter by author ila opened on Sep 30, 2026

• One open transaction on any tracked table blocks all tracked DML and every refresh database-wide, with no timeout and no visibility

  concurrencyenhancementrobustness
  ila/openivm#90 · Filter by author ila opened on Sep 30, 2026

• Refresh mutates database-wide disabled_optimizers: data race crashes concurrent queries and overwrites the user's setting

  bugconcurrencyrobustness
  ila/openivm#89 · Filter by author ila opened on Sep 30, 2026