Issues

• 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

• DuckLake refresh is not atomic: concurrent readers see groups missing or half-published

  bugconcurrencycorrectness
  ila/openivm#88 · Filter by author ila opened on Sep 30, 2026

• CREATE MATERIALIZED VIEW with a LIST-typed GROUP BY key fails on index creation and poisons the next statement

  bugrobustness
  ila/openivm#73 · Filter by author ila opened on Sep 29, 2026

• Unqualified CREATE MATERIALIZED VIEW after USE <schema> puts the view in main and it can never be refreshed

  bugcorrectness
  ila/openivm#72 · Filter by author ila opened on Sep 29, 2026

• Concurrency and daemon tests coordinate threads with sleep_ms

  tests
  ila/openivm#69 · Filter by author ila opened on Sep 29, 2026

• extension-ci-tools submodule pinned to v1.5.2 while CI and the duckdb submodule use v1.5.4

  ci
  ila/openivm#68 · Filter by author ila opened on Sep 29, 2026

• CREATE MATERIALIZED VIEW corrupts string literals: removes ';' and collapses whitespace

  bugcorrectness
  ila/openivm#67 · Filter by author ila opened on Sep 29, 2026

• CREATE MV internal operations are tab-delimited strings parsed back by position

  refactorrobustness
  ila/openivm#63 · Filter by author ila opened on Sep 29, 2026

• Delta-SQL post-processing finds "INSERT INTO <delta>" by text search and can edit a literal instead

  refactorrobustness
  ila/openivm#62 · Filter by author ila opened on Sep 29, 2026