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
cd ~/Helios/Nanocargo test branch_sql_integration_testscargo test materialized_view_integrationcargo test time_travel_system_views_testscargo test --test postgres_extended_protocol_testsManual SQL
CREATE DATABASE BRANCH smoke FROM main AS OF NOW;SELECT branch_name FROM pg_database_branches();DROP DATABASE BRANCH smoke;