Skip to content

v0.1.0-alpha.3

Pre-release
Pre-release

Choose a tag to compare

@github-actions github-actions released this 10 Nov 11:51
8edf052

Adds materialized views: the explorer section the manifest has always
advertised now works. Tested against CockroachDB v24.3 and the latest release.

Added

  • Materialized views (#23): get_materialized_views,
    get_materialized_view_columns, get_materialized_view_definition and
    refresh_materialized_view.
    • Listing comes from SHOW TABLES filtered on type = 'materialized view',
      with the information_schema.tables fallback when the role cannot run
      SHOW TABLES. Only the requested schema's views are returned.
    • Columns reuse the get_columns query, so canonical types, comments and
      hidden-column filtering (rowid) behave exactly as for tables.
    • The definition comes from SHOW CREATE VIEW (materialized views are
      absent from information_schema.views).
    • REFRESH MATERIALIZED VIEW quotes identifiers, and server errors
      (missing view, permissions) surface with their SQLSTATE.

Fixed

  • The materialized_views: true capability no longer points at -32601
    stubs: discovery previously degraded to a silently empty list and refresh
    to an unsupported-driver error.