Changes for version 1.02 - 2026-03-21
- New: Multi-column AND queries now exploit an available index on one of the columns (partial AND index pushdown). Example: WHERE dept = 'Eng' AND salary > 70000 uses the dept or salary index rather than performing a full table scan.
- New: INTERSECT, INTERSECT ALL, EXCEPT, and EXCEPT ALL set operations are now supported alongside UNION / UNION ALL.
- Added: t/1011_index_and_setop.t (69 tests) covering both features.
- Updated: POD and README revised to document the new behaviour.
Documentation
Modules
Pure-Perl flat-file relational database with DBI-like interface