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

```
public class SqlFunctionsTest
extends java.lang.Object
```
Unit test for the methods in SqlFunctions that implement SQL functions.

Constructor Summary

Constructors
Constructor Description

SqlFunctionsTest()

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`private void`	`checkAddMonths(int y0, int m0, int d0, int y1, int m1, int d1, int months)`
`private void`	`checkCeil(int x, int y, int result)`
`private void`	`checkFloor(int x, int y, int result)`
`private long`	`d2ts(int date, int millis)`	Converts a date (days since epoch) and milliseconds (since midnight) into a timestamp (milliseconds since epoch).
`void`	`testAddMonths()`
`void`	`testByteString()`
`void`	`testCeil()`
`void`	`testCharLength()`
`void`	`testCompare()`	Unit test for `Utilities.compare(java.util.List, java.util.List)`.
`void`	`testConcat()`
`void`	`testDivideAny()`
`void`	`testEqWithAny()`
`void`	`testFloor()`
`void`	`testGeWithAny()`
`void`	`testGreater()`
`void`	`testGtWithAny()`
`void`	`testInitcap()`
`void`	`testLesser()`
`void`	`testLeWithAny()`
`void`	`testLower()`
`void`	`testLtrim()`	Test for `SqlFunctions.ltrim(java.lang.String)`.
`void`	`testLtWithAny()`
`void`	`testMinusAny()`
`void`	`testMultiplyAny()`
`void`	`testMultiset()`
`void`	`testNeWithAny()`
`void`	`testPlusAny()`
`void`	`testRtrim()`	Test for `SqlFunctions.rtrim(java.lang.String)`.
`void`	`testSRoundDouble()`
`void`	`testSRoundInt()`
`void`	`testSRoundLong()`
`void`	`testSTruncateDouble()`
`void`	`testSTruncateInt()`
`void`	`testSTruncateLong()`
`void`	`testTrim()`	Test for `SqlFunctions.trim(boolean, boolean, java.lang.String, java.lang.String)`.
`void`	`testTruncateInt()`
`void`	`testTruncateLong()`
`void`	`testUpper()`
`private void`	`thereAndBack(byte[] bytes)`
`(package private) static java.lang.String`	`trimSpacesBoth(java.lang.String s)`

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

Constructor Detail
- SqlFunctionsTest
```
public SqlFunctionsTest()
```

Method Detail

testCharLength
```
public void testCharLength()
```

testConcat
```
public void testConcat()
```

testLower
```
public void testLower()
```

testUpper
```
public void testUpper()
```

testInitcap
```
public void testInitcap()
```

testLesser
```
public void testLesser()
```

testGreater
```
public void testGreater()
```

testRtrim
```
public void testRtrim()
```
Test for SqlFunctions.rtrim(java.lang.String).

testLtrim
```
public void testLtrim()
```
Test for SqlFunctions.ltrim(java.lang.String).

testTrim
```
public void testTrim()
```
Test for SqlFunctions.trim(boolean, boolean, java.lang.String, java.lang.String).

trimSpacesBoth

static java.lang.String trimSpacesBoth(java.lang.String s)

testAddMonths
```
public void testAddMonths()
```

checkAddMonths

private void checkAddMonths(int y0,
                            int m0,
                            int d0,
                            int y1,
                            int m1,
                            int d1,
                            int months)

d2ts
```
private long d2ts(int date,
                  int millis)
```
Converts a date (days since epoch) and milliseconds (since midnight) into a timestamp (milliseconds since epoch).

testFloor
```
public void testFloor()
```

checkFloor

private void checkFloor(int x,
                        int y,
                        int result)

testCeil
```
public void testCeil()
```

checkCeil

private void checkCeil(int x,
                       int y,
                       int result)

testCompare
```
public void testCompare()
```
Unit test for Utilities.compare(java.util.List, java.util.List).

testTruncateLong
```
public void testTruncateLong()
```

testTruncateInt
```
public void testTruncateInt()
```

testSTruncateDouble
```
public void testSTruncateDouble()
```

testSTruncateLong
```
public void testSTruncateLong()
```

testSTruncateInt
```
public void testSTruncateInt()
```

testSRoundDouble
```
public void testSRoundDouble()
```

testSRoundLong
```
public void testSRoundLong()
```

testSRoundInt
```
public void testSRoundInt()
```

testByteString
```
public void testByteString()
```

thereAndBack

private void thereAndBack(byte[] bytes)

testEqWithAny
```
public void testEqWithAny()
```

testNeWithAny
```
public void testNeWithAny()
```

testLtWithAny
```
public void testLtWithAny()
```

testLeWithAny
```
public void testLeWithAny()
```

testGtWithAny
```
public void testGtWithAny()
```

testGeWithAny
```
public void testGeWithAny()
```

testPlusAny
```
public void testPlusAny()
```

testMinusAny
```
public void testMinusAny()
```

testMultiplyAny
```
public void testMultiplyAny()
```

testDivideAny
```
public void testDivideAny()
```

testMultiset
```
public void testMultiset()
```

Class SqlFunctionsTest

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

SqlFunctionsTest

Method Detail

testCharLength

testConcat

testLower

testUpper

testInitcap

testLesser

testGreater

testRtrim

testLtrim

testTrim

trimSpacesBoth

testAddMonths

checkAddMonths

d2ts

testFloor

checkFloor

testCeil

checkCeil

testCompare

testTruncateLong

testTruncateInt

testSTruncateDouble

testSTruncateLong

testSTruncateInt

testSRoundDouble

testSRoundLong

testSRoundInt

testByteString

thereAndBack

testEqWithAny

testNeWithAny

testLtWithAny

testLeWithAny

testGtWithAny

testGeWithAny

testPlusAny

testMinusAny

testMultiplyAny

testDivideAny

testMultiset