Cross-tests with CodoMetis.ValueRanges on both lines: range and multirange columns as temporal-constraint periods and exclusion-constraint operands #42

Updated 2026-10-19 for the spin-off (#37): the two lines are EFCore.ComplexIndexes 5.x on release/5.x and SchemaKit 11.x on main.

The contract between the two libraries is the store type name. The PostgreSQL differ accepts a period whose store type ends in range, or whose CLR type is NpgsqlRange<T>. Every ValueRanges mapping carries that name (daterange, datemultirange, the custom timerange, …). Neither package references the other, and that stays so. The connection is proven by tests on both sides.

Here, with a test-only reference to the four ValueRanges packages:

On release/5.x, against ValueRanges 10.x:

• HasTemporalConstraint(period: b => b.Period) over a DateRange, a RangeSet<DateRange, DateOnly> (multirange) and a TimeRange property passes validation, renders UNIQUE (… WITHOUT OVERLAPS), and the overlap is rejected on PostgreSQL 18.
• HasExclusionConstraint with && over the same properties renders and rejects the overlap, on PostgreSQL 16 and 18.
• A GiST HasComplexIndex over a range column serves a && query.

On main, against ValueRanges 11.0.0-preview.N:

• the exclusion-constraint and GiST tests above, under the SchemaKit ids
• no temporal test: SchemaKit: leave out what EF Core 11 and Npgsql 11 do natively; keep what stays unique #39 leaves temporal constraints to Npgsql 11, and ValueRanges holds the native ones itself (NativeTemporalKeyTests, feat: Npgsql 11's native temporal keys accept every range and multirange column CodoMetis.ValueRanges#335)

Docs: docs/postgresql-constraints.md names the ValueRanges types as valid periods.

The 11 half needs ValueRanges 11.0.0-preview.1 on nuget.org (CaffeinatedCoder/CodoMetis.ValueRanges#332) and SchemaKit's own preview (#38).

ValueRanges carries the mirror tests: ComplexIndexesCrossTests and a joint smoke consumer on its 10 line, re-enabled against SchemaKit on its 11 line by CaffeinatedCoder/CodoMetis.ValueRanges#333.