Interval testing error breakdown (CqlIntervalOperatorsTest)

As of 12/3/2025
interval testing in a nutshell

1. "passCount": 358,
   "skipCount": 4,
   "failCount": 50,

2. Failing tests:
   actual is supposed to return interval objects, but returns a string or array of strings (engine errors)
   IntegerIntervalCollapse2
   IntegerIntervalCollapse3
   DecimalIntervalCollapse
   DecimalIntervalCollapse2
   TimeCollapse
   ExpandPerHour
   ExpandPerHourOpen
   ExpandPer1
   ExpandPer1Open
   ExpandPer0D1IntervalOverload
   ExpandPer0D1 (AND does not do expand)
   ExpandInterval
   ExpandIntervalOpen
   ExpandIntervalPer2
   ExpandIntervalOpenPer2
   IntegerIntervalExcept1to3
   DecimalIntervalExcept1to3
   Except12
   ExceptTimeInterval
   ExceptTime2
   TestIntersectNull
   IntegerIntervalIntersectTest4to10
   DecimalIntervalIntersectTest4to10
   TimeIntersect
   IntegerIntervalUnion1To15
   DecimalIntervalUnion1To15
   IntegerIntervalTest
   IntegerIntervalTest2
   IntegerIntervalTest3
   IntegerIntervalTest4
   IntegerIntervalTest5
   TimeUnion
   DecimalIntervalTest
   DecimalIntervalTest2
   DecimalIntervalTest3
   DecimalIntervalTest4
   DecimalIntervalTest5
   TimeIntervalTest
   CollapseIntervalTestInteger

    Various errors:
    ExpandPerDay        (T00:00:00+00:00 in actual not in expected)
    ExpandPer2Days      (T00:00:00+00:00 in actual not in expected)
    DateTimeIntervalEnd (Z in actual, not in expected)
    TestPeriod1         (Z in actual, not in expected)
    TestPeriod2         (Z in actual, not in expected)
    NullBoundariesProperlyIncludesIntegerInterval   (null(actual) vs true)
    IntegerIntervalProperlyIncludedInNullBoundaries (null(actual) vs true)
    DateTimeIntervalStart   (Z in actual, not in expected)
    DateTimeIntervalTest(Z in actual, not in expected)
   

Start by running CqlIntervalOperatorsTest and reviewing the listed failing cases, separating the interval-object, expansion, boundary, and timezone discrepancies. Trace each failure to the test runner or its interval handling, then confirm that the listed failures pass with the expected interval values and formatting.