Search in sources :

Example 96 with Function

use of org.teiid.language.Function in project teiid by teiid.

the class TestSybaseConvertModifier method testModDrop.

// original test -- this is not a drop one anymore
@Test
public void testModDrop() throws Exception {
    Function func = // $NON-NLS-1$
    LANG_FACTORY.createFunction(// $NON-NLS-1$
    "convert", new Expression[] { // $NON-NLS-1$
    LANG_FACTORY.createLiteral("5", String.class), // $NON-NLS-1$
    LANG_FACTORY.createLiteral("integer", String.class) }, Integer.class);
    // $NON-NLS-1$
    assertEquals("cast('5' AS int)", helpGetString(func));
}
Also used : Function(org.teiid.language.Function) Test(org.junit.Test)

Example 97 with Function

use of org.teiid.language.Function in project teiid by teiid.

the class TestSybaseConvertModifier method testBooleanToIntegerb.

@Test
public void testBooleanToIntegerb() throws Exception {
    Function func = // $NON-NLS-1$
    LANG_FACTORY.createFunction(// $NON-NLS-1$
    "convert", new Expression[] { LANG_FACTORY.createLiteral(Boolean.FALSE, Boolean.class), // $NON-NLS-1$
    LANG_FACTORY.createLiteral("integer", Integer.class) }, Integer.class);
    // $NON-NLS-1$
    helpGetString1(func, "cast(0 AS int)");
}
Also used : BigInteger(java.math.BigInteger) Function(org.teiid.language.Function) Test(org.junit.Test)

Example 98 with Function

use of org.teiid.language.Function in project teiid by teiid.

the class TestSybaseConvertModifier method testIntegerToShort.

@Test
public void testIntegerToShort() throws Exception {
    Function func = // $NON-NLS-1$
    LANG_FACTORY.createFunction(// $NON-NLS-1$
    "convert", new Expression[] { LANG_FACTORY.createLiteral(new Integer(1232321), Integer.class), // $NON-NLS-1$
    LANG_FACTORY.createLiteral("short", Short.class) }, Short.class);
    // $NON-NLS-1$
    helpGetString1(func, "cast(1232321 AS smallint)");
}
Also used : BigInteger(java.math.BigInteger) Function(org.teiid.language.Function) Test(org.junit.Test)

Example 99 with Function

use of org.teiid.language.Function in project teiid by teiid.

the class TestSybaseConvertModifier method testShortToInteger.

@Test
public void testShortToInteger() throws Exception {
    Function func = // $NON-NLS-1$
    LANG_FACTORY.createFunction(// $NON-NLS-1$
    "convert", new Expression[] { LANG_FACTORY.createLiteral(new Short((short) 1243), Short.class), // $NON-NLS-1$
    LANG_FACTORY.createLiteral("integer", Integer.class) }, Integer.class);
    // $NON-NLS-1$
    helpGetString1(func, "cast(1243 AS int)");
}
Also used : BigInteger(java.math.BigInteger) Function(org.teiid.language.Function) Test(org.junit.Test)

Example 100 with Function

use of org.teiid.language.Function in project teiid by teiid.

the class TestSybaseConvertModifier method testBooleanToDoubleb.

@Test
public void testBooleanToDoubleb() throws Exception {
    Function func = // $NON-NLS-1$
    LANG_FACTORY.createFunction(// $NON-NLS-1$
    "convert", new Expression[] { LANG_FACTORY.createLiteral(Boolean.FALSE, Boolean.class), // $NON-NLS-1$
    LANG_FACTORY.createLiteral("double", Double.class) }, Double.class);
    // $NON-NLS-1$
    helpGetString1(func, "cast(0 AS double precision)");
}
Also used : Function(org.teiid.language.Function) Test(org.junit.Test)

Aggregations

Function (org.teiid.language.Function)173 Test (org.junit.Test)127 BigInteger (java.math.BigInteger)36 ArrayList (java.util.ArrayList)16 Literal (org.teiid.language.Literal)15 BigDecimal (java.math.BigDecimal)14 List (java.util.List)13 Expression (org.teiid.language.Expression)13 AliasModifier (org.teiid.translator.jdbc.AliasModifier)12 FunctionModifier (org.teiid.translator.jdbc.FunctionModifier)12 SQLConversionVisitor (org.teiid.translator.jdbc.SQLConversionVisitor)9 LinkedList (java.util.LinkedList)3 ColumnReference (org.teiid.language.ColumnReference)3 Comparison (org.teiid.language.Comparison)3 SearchedCase (org.teiid.language.SearchedCase)3 EscapeSyntaxModifier (org.teiid.translator.jdbc.EscapeSyntaxModifier)3 ModFunctionModifier (org.teiid.translator.jdbc.ModFunctionModifier)3 ConcatFunctionModifier (org.teiid.translator.jdbc.oracle.ConcatFunctionModifier)3 Timestamp (java.sql.Timestamp)2 AggregateFunction (org.teiid.language.AggregateFunction)2