The following aggregation tests all contain switch statements with branches that will never execute. The tests use a `between(x, y)` switch expression, but there are `case` values that are outside the randomised range. We need to fix these before #88739 can be merged. By "fix", I mean either remove the spurious cases, or if we actually want them, then extend the randomized range.

   * InternalAutoDateHistogramTests
   * InternalAvgTests
   * InternalDerivativeTests
   * InternalGeoCentroidTests
   * InternalWeightedAvgTests
   * SignificantLongTermsTests
   * SignificantStringTermsTests
server/src/test/java/org/elasticsearch/search/aggregations/pipeline/InternalDerivativeTests.java
: randomFrom(new Double[] { Double.NEGATIVE_INFINITY, Double.POSITIVE_INFINITY, Double.NaN });
        double normalizationFactor = frequently() ? randomDoubleBetween(0, 100000, true) : 0;
        return new InternalDerivative(name, value, normalizationFactor, formatter, metadata);
    }
    @Override
    public void testReduceRandom() {
        expectThrows(UnsupportedOperationException.class, () -> createTestInstance("name", null).reduce(null, null));
    }
    @Override
    protected void assertReduced(InternalDerivative reduced, List<InternalDerivative> inputs) {
        
    }
    @Override
    protected void assertFromXContent(InternalDerivative derivative, ParsedAggregation parsedAggregation) {
        ParsedDerivative parsed = ((ParsedDerivative) parsedAggregation);
        if (Double.isInfinite(derivative.getValue()) == false && Double.isNaN(derivative.getValue()) == false) {
            assertEquals(derivative.getValue(), parsed.value(), Double.MIN_VALUE);
            assertEquals(derivative.getValueAsString(), parsed.getValueAsString());
        } else {
            
            
            assertEquals(parsed.value(), Double.NaN, Double.MIN_VALUE);
        }
    }
    @Override
    protected InternalDerivative mutateInstance(InternalDerivative instance) {
        String name = instance.getName();
        double value = instance.getValue();
        double normalizationFactor = instance.getNormalizationFactor();
        DocValueFormat formatter = instance.formatter();