Skip to content

Advanced Feature Integration Test Reference

Advanced Feature Integration Test Reference

HeliosDB Nano integration tests exercise advanced features through SQL, storage, catalog, and protocol boundaries.

Integration Scenarios

  • Create a branch, write isolated data, inspect branch metadata, and merge or drop the branch
  • Insert data, query historical snapshots with AS OF, and combine time-travel with filters and aggregates
  • Create and refresh materialized views, then inspect staleness metadata
  • Create vector indexes and inspect vector index statistics
  • Use PostgreSQL extended protocol messages for prepared statements, binds, portals, and executes

Commands

Terminal window
cd ~/Helios/Nano
cargo test branch_sql_integration_tests
cargo test materialized_view_integration
cargo test time_travel_system_views_tests
cargo test --test postgres_extended_protocol_tests

Manual SQL

CREATE DATABASE BRANCH smoke FROM main AS OF NOW;
SELECT branch_name FROM pg_database_branches();
DROP DATABASE BRANCH smoke;

See Also