java.lang.Object
- org.apache.calcite.test.UdfTest

```
public class UdfTest
extends java.lang.Object
```
Tests for user-defined functions; includes user-defined aggregate functions but user-defined table functions are in TableFunctionTest.

See Also:

Smalls

Nested Class Summary

Nested Classes
Modifier and Type	Class	Description
`private class`	`UdfTest.ArrayAppendDoubleFunction`	Function with signature "f(ARRAY OF DOUBLE, INTEGER) returns ARRAY OF DOUBLE".
`private class`	`UdfTest.ArrayAppendIntegerFunction`	Function with signature "f(ARRAY OF INTEGER, INTEGER) returns ARRAY OF INTEGER".
`private static class`	`UdfTest.ArrayAppendScalarFunction`	Base class for functions that append arrays.

Constructor Summary

Constructors
Constructor Description

UdfTest()

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`void`	`testArrayUserDefinedFunction()`	Test case for [CALCITE-1834] User-defined function for Arrays.
`void`	`testBigDecimalAndLong()`	Test case for [CALCITE-2053] Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong .
`void`	`testDate()`	Test case for [CALCITE-986] User-defined function with Date or Timestamp parameters.
`void`	`testDateAndTimestamp()`	Test case for [CALCITE-1881] Can't distinguish overloaded user-defined functions that have DATE and TIMESTAMP arguments.
`void`	`testNotNullImplementor()`	Tests that IS NULL/IS NOT NULL is properly implemented for non-strict functions.
`void`	`testPath()`	Tests resolution of functions using schema paths.
`void`	`testReturnDate()`	Test case for [CALCITE-1041] User-defined function returns DATE or TIMESTAMP value.
`void`	`testReturnDate2()`	Test case for [CALCITE-1041] User-defined function returns DATE or TIMESTAMP value.
`void`	`testSemiStrict()`	Tests that we generate the appropriate checks for a "semi-strict" function.
`void`	`testUdfArgumentName()`	Tests passing parameters to user-defined function by name.
`void`	`testUdfArgumentOptional()`	Tests calling a user-defined function some of whose parameters are optional.
`void`	`testUdfDerivedReturnType()`	Tests derived return type of user-defined function.
`void`	`testUdfOverloaded()`	Tests a user-defined function that has multiple overloads.
`void`	`testUdfOverloadedNullable()`
`void`	`testUserDefinedAggregateFunction()`	Tests user-defined aggregate function.
`void`	`testUserDefinedAggregateFunction3()`	Test for `CalciteResource.firstParameterOfAdd(String)`.
`void`	`testUserDefinedAggregateFunctionImplementsInterface()`	Test case for [CALCITE-1434] AggregateFunctionImpl doesnt work if the class implements a generic interface.
`void`	`testUserDefinedAggregateFunctionWithFilter()`	Tests user-defined aggregate function with FILTER.
`void`	`testUserDefinedAggregateFunctionWithMultipleParameters()`	Tests user-defined aggregate function.
`void`	`testUserDefinedFunction()`	Tests a user-defined function that is defined in terms of a class with non-static methods.
`void`	`testUserDefinedFunction2()`	Test for `CalciteResource.requireDefaultConstructor(String)`.
`void`	`testUserDefinedFunctionB()`
`void`	`testUserDefinedFunctionInstanceCount()`	As `testUserDefinedFunction()`, but checks that the class is instantiated exactly once, per [CALCITE-1548] Instantiate function objects once per query.
`void`	`testUserDefinedFunctionInView()`	Test case for [CALCITE-937] User-defined function within view.
`void`	`testUserDefinedFunctionWithMethodName()`	Tests user-defined function, with multiple methods per class.
`private static CalciteAssert.AssertThat`	`withBadUdf(java.lang.Class clazz)`
`private CalciteAssert.AssertThat`	`withUdf()`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - UdfTest
```
public UdfTest()
```
- Method Detail
  - withUdf
```
private CalciteAssert.AssertThat withUdf()
```
  - testUserDefinedFunction
```
public void testUserDefinedFunction()
                             throws java.lang.Exception
```
    Tests a user-defined function that is defined in terms of a class with non-static methods.
    
    Throws:
    
    java.lang.Exception
  - testUserDefinedFunctionInstanceCount
```
public void testUserDefinedFunctionInstanceCount()
                                          throws java.lang.Exception
```
    As testUserDefinedFunction(), but checks that the class is instantiated exactly once, per [CALCITE-1548] Instantiate function objects once per query.
    
    Throws:
    
    java.lang.Exception
  - testUserDefinedFunctionB
```
public void testUserDefinedFunctionB()
                              throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testUserDefinedFunctionInView
```
public void testUserDefinedFunctionInView()
                                   throws java.lang.Exception
```
    Test case for [CALCITE-937] User-defined function within view.
    
    Throws:
    
    java.lang.Exception
  - testNotNullImplementor
```
public void testNotNullImplementor()
```
    Tests that IS NULL/IS NOT NULL is properly implemented for non-strict functions.
  - testSemiStrict
```
public void testSemiStrict()
```
    Tests that we generate the appropriate checks for a "semi-strict" function.
    The difference between "strict" and "semi-strict" functions is that a "semi-strict" function might return null even if none of its arguments are null. (Both always return null if one of their arguments is null.) Thus, a nasty function is more unpredictable.
    
    See Also:
    
    SemiStrict
  - testUdfDerivedReturnType
```
public void testUdfDerivedReturnType()
```
    Tests derived return type of user-defined function.
  - testUdfOverloaded
```
public void testUdfOverloaded()
```
    Tests a user-defined function that has multiple overloads.
  - testUdfOverloadedNullable
```
public void testUdfOverloadedNullable()
```
  - testUdfArgumentName
```
public void testUdfArgumentName()
```
    Tests passing parameters to user-defined function by name.
  - testUdfArgumentOptional
```
public void testUdfArgumentOptional()
```
    Tests calling a user-defined function some of whose parameters are optional.
  - testUserDefinedFunction2
```
public void testUserDefinedFunction2()
                              throws java.lang.Exception
```
    Test for CalciteResource.requireDefaultConstructor(String).
    
    Throws:
    
    java.lang.Exception
  - testUserDefinedFunctionWithMethodName
```
public void testUserDefinedFunctionWithMethodName()
                                           throws java.lang.Exception
```
    Tests user-defined function, with multiple methods per class.
    
    Throws:
    
    java.lang.Exception
  - testUserDefinedAggregateFunction
```
public void testUserDefinedAggregateFunction()
                                      throws java.lang.Exception
```
    Tests user-defined aggregate function.
    
    Throws:
    
    java.lang.Exception
  - testUserDefinedAggregateFunctionWithMultipleParameters
```
public void testUserDefinedAggregateFunctionWithMultipleParameters()
                                                            throws java.lang.Exception
```
    Tests user-defined aggregate function.
    
    Throws:
    
    java.lang.Exception
  - testUserDefinedAggregateFunction3
```
public void testUserDefinedAggregateFunction3()
                                       throws java.lang.Exception
```
    Test for CalciteResource.firstParameterOfAdd(String).
    
    Throws:
    
    java.lang.Exception
  - testUserDefinedAggregateFunctionImplementsInterface
```
public void testUserDefinedAggregateFunctionImplementsInterface()
```
    Test case for [CALCITE-1434] AggregateFunctionImpl doesnt work if the class implements a generic interface.
  - withBadUdf
```
private static CalciteAssert.AssertThat withBadUdf(java.lang.Class clazz)
```
  - testUserDefinedAggregateFunctionWithFilter
```
public void testUserDefinedAggregateFunctionWithFilter()
                                                throws java.lang.Exception
```
    Tests user-defined aggregate function with FILTER.
    Also tests that we do not try to push ADAF to JDBC source.
    
    Throws:
    
    java.lang.Exception
  - testPath
```
public void testPath()
              throws java.lang.Exception
```
    Tests resolution of functions using schema paths.
    
    Throws:
    
    java.lang.Exception
  - testDate
```
public void testDate()
```
    Test case for [CALCITE-986] User-defined function with Date or Timestamp parameters.
  - testReturnDate
```
public void testReturnDate()
```
    Test case for [CALCITE-1041] User-defined function returns DATE or TIMESTAMP value.
  - testDateAndTimestamp
```
public void testDateAndTimestamp()
```
    Test case for [CALCITE-1881] Can't distinguish overloaded user-defined functions that have DATE and TIMESTAMP arguments.
  - testBigDecimalAndLong
```
public void testBigDecimalAndLong()
```
    Test case for [CALCITE-2053] Overloaded user-defined functions that have Double and BigDecimal arguments will goes wrong .
  - testReturnDate2
```
public void testReturnDate2()
```
    Test case for [CALCITE-1041] User-defined function returns DATE or TIMESTAMP value.
  - testArrayUserDefinedFunction
```
public void testArrayUserDefinedFunction()
                                  throws java.lang.Exception
```
    Test case for [CALCITE-1834] User-defined function for Arrays.
    
    Throws:
    
    java.lang.Exception

Class UdfTest

Nested Class Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

UdfTest

Method Detail

withUdf

testUserDefinedFunction

testUserDefinedFunctionInstanceCount

testUserDefinedFunctionB

testUserDefinedFunctionInView

testNotNullImplementor

testSemiStrict

testUdfDerivedReturnType

testUdfOverloaded

testUdfOverloadedNullable

testUdfArgumentName

testUdfArgumentOptional

testUserDefinedFunction2

testUserDefinedFunctionWithMethodName

testUserDefinedAggregateFunction

testUserDefinedAggregateFunctionWithMultipleParameters

testUserDefinedAggregateFunction3

testUserDefinedAggregateFunctionImplementsInterface

withBadUdf

testUserDefinedAggregateFunctionWithFilter

testPath

testDate

testReturnDate

testDateAndTimestamp

testBigDecimalAndLong

testReturnDate2

testArrayUserDefinedFunction