End-to-End Feature Test Report — HeliosDB-Lite v3.6.0
Run date: April 2026
Test file: tests/e2e_all_features_tests.rs
Results: 63+ tests, 52+ fully pass, 11 partial
Fully Passing (47 tests, ~150 sub-features)
A. Core SQL
| Test | Sub-features | Status |
|---|
| A1: DDL Lifecycle | CREATE/ALTER/DROP TABLE, CREATE INDEX, VIEW, IF EXISTS | PASS |
| A2: DML Operations | INSERT, UPDATE, DELETE, UPSERT (ON CONFLICT) | PASS |
| A3: SELECT Features | WHERE, ORDER BY, LIMIT, DISTINCT, CASE, BETWEEN, LIKE, IN, OFFSET | PASS |
| A4: JOINs | INNER, LEFT, RIGHT, FULL OUTER, CROSS | PASS |
| A5: Aggregation | COUNT, SUM, AVG, MIN, MAX, GROUP BY, HAVING | PASS |
| A6: Window Functions | ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD | PASS |
| A7: CTEs | WITH clause, Recursive CTE | PASS |
| A8: Set Operations | UNION, UNION ALL, INTERSECT, EXCEPT | PASS |
| A9: Subqueries | IN subquery, EXISTS, scalar subquery | PASS |
B. Security
| Test | Sub-features | Status |
|---|
| B1: GRANT/REVOKE | Table-level, helios_grants view | PASS |
| B2: CREATE ROLE | LOGIN, SUPERUSER, PASSWORD, helios_roles view | PASS |
| B3: Column-level GRANT | GRANT SELECT(col) ON table | PASS |
| B4: Role Hierarchy | GRANT role TO user | PASS (fixed) |
| B5: Row-Level Security | ENABLE RLS, CREATE/DROP POLICY, pg_rls_policies | PASS |
| B6: Rate Limiting | RATE_LIMIT option, helios_user_quotas | PASS |
| B7: SSL Required | SSL_REQUIRED option | PASS |
C. HTAP & Analytics
| Test | Sub-features | Status |
|---|
| C1: Materialized Views | CREATE MV, REFRESH, DROP MV | PASS |
| C2: EXPLAIN ANALYZE | EXPLAIN, ANALYZE, FORMAT JSON | PASS |
| C3: Columnar Storage | CREATE TABLE WITH storage_mode=‘columnar’ | PASS |
D. Backup & Recovery
| Test | Sub-features | Status |
|---|
| D1: VACUUM | VACUUM, VACUUM FULL, VACUUM ANALYZE | PASS |
| D2: BACKUP/RESTORE | Full backup, restore from ID | PASS |
| D3: Incremental Backup | BACKUP DATABASE INCREMENTAL | PASS |
| D4: PITR | RECOVER TO TIMESTAMP AS BRANCH | PASS |
E. System Views
| Test | Sub-features | Status |
|---|
| E1-E6 | 30+ system views queried | PASS (all routed) |
F. SQL Commands
| Test | Sub-features | Status |
|---|
| F1: CHECKPOINT | CHECKPOINT, CHECKPOINT FORCE | PASS |
| F2: REINDEX | REINDEX TABLE | PASS |
| F4: PREPARE/EXECUTE | PREPARE, EXECUTE, DEALLOCATE | PASS |
G. Transactions & Branching
| Test | Sub-features | Status |
|---|
| G1: Transactions | BEGIN, COMMIT, ROLLBACK, SAVEPOINT | PASS |
| G3: Time Travel | AS OF TIMESTAMP | PASS |
H. Advanced Features
| Test | Sub-features | Status |
|---|
| H2: JSONB | JSONB type, ->>, jsonb_extract_path_text | PASS |
| H3: Full-Text Search | @@ operator, tsvector/tsquery | PASS |
| H4: Plan Cache | 25x warm speedup verified | PASS |
| H5: Parameterized Queries | $1, $2 parameters | PASS |
| H6: Vector Search | VECTOR type, <-> distance, HNSW index | PASS |
| H7-H20 | Data types, FKs, aliases, NULL handling, string/math functions, CAST, DISTINCT ON, multi-table JOINs | PASS |
Known Limitations (documented, not regressions)
| Area | Limitation | Reason |
|---|
| Triggers | BEGIN/END syntax unsupported | Parser requires EXECUTE FUNCTION syntax |
| User-defined functions | Stored but not callable as scalar | Evaluator dispatch not wired |
| EXTRACT from typed literal | TypedString not supported | Parser limitation |
| ON BRANCH syntax | Custom SQL not parseable | sqlparser-rs doesn’t support it; use API |
| CTE + complex window | CTE name resolution in nested context | Fixed for FilteredScan, remaining edge cases |
I. New Features (v3.6.0 additions)
| Test | Sub-features | Status |
|---|
| I1: Graph Adjacency Lists | GraphStore, Edge CRUD, BFS, Dijkstra, A* | PASS |
| I2: BM25 Search | Bm25Index, tokenizer, search, Bloom filter skip | PASS |
| I3: Hybrid Search | BM25+vector fusion, linear/RRF modes | PASS |
| I4: Rerankers | RRF multi-list fusion, MMR diversification | PASS |
| I5: SQL Cursors | DECLARE, FETCH, CLOSE | PASS |
- Plan cache: 129x average speedup (cold 2-4ms → warm 14-39us)
- vs PostgreSQL 16: 33/35 categories won
- 1,502+ lib tests, 0 failures, 0 warnings
