@Description("test if value is finite")
    @ScalarFunction
    @SqlType(StandardTypes.BOOLEAN)
    public static boolean isFinite(@SqlType(StandardTypes.DOUBLE) double num)
    {
        return Doubles.isFinite(num);
    }
@Test
    public void testIsFinite()
    {
        assertFunction("is_finite(100000)", BOOLEAN, true);
        assertFunction("is_finite(rand() / 0.0E0)", BOOLEAN, false);
        assertFunction("is_finite(REAL '754.2008E0')", BOOLEAN, true);
        assertFunction("is_finite(rand() / REAL '0.0E0')", BOOLEAN, false);
        assertFunction("is_finite(NULL)", BOOLEAN, null);
    }