@Description("test if value is infinite")
    @ScalarFunction
    @SqlType(StandardTypes.BOOLEAN)
    public static boolean isInfinite(@SqlType(StandardTypes.DOUBLE) double num)
    {
        return Double.isInfinite(num);
    }
@Test
    public void testIsInfinite()
    {
        assertFunction("is_infinite(1.0E0 / 0.0E0)", BOOLEAN, true);
        assertFunction("is_infinite(0.0E0 / 0.0E0)", BOOLEAN, false);
        assertFunction("is_infinite(1.0E0 / 1.0E0)", BOOLEAN, false);
        assertFunction("is_infinite(REAL '1.0' / REAL '0.0')", BOOLEAN, true);
        assertFunction("is_infinite(REAL '0.0' / REAL '0.0')", BOOLEAN, false);
        assertFunction("is_infinite(REAL '1.0' / REAL '1.0')", BOOLEAN, false);
        assertFunction("is_infinite(NULL)", BOOLEAN, null);
    }