Revision history for DB::Handy

1.02  2026-03-21 JST (Japan Standard Time)

    - 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.

1.01  2026-03-20 JST (Japan Standard Time)

    - Fixed: CHECK constraints are now enforced on UPDATE as well as INSERT.
    - Fixed: WHERE col BETWEEN lo AND hi and
      WHERE col OP lo AND col OP hi (two-sided AND range on one column)
      now exploit an index when available.
    - Fixed: fetchrow_arrayref, fetchrow_array, and sth->{NAME} now
      reflect the SELECT list column order for named column lists.
      SELECT * and JOIN results still fall back to alphabetical order.
    - Added: t/1010_fixes.t (60 tests) covering the three fixes above.
    - Updated: POD and README revised to document the corrected behaviour.

1.00  2026-03-19 JST (Japan Standard Time)

    - First release on CPAN.