Examples with Query org.teiid.query.sql.lang.Query used on opensource projects

Example 26 with Query

use of org.teiid.query.sql.lang.Query in project teiid by teiid.

the class TestOrderByRewrite method testNumberedOrderBy8.

@Test
public void testNumberedOrderBy8() throws Exception {
    // $NON-NLS-1$
    Query resolvedQuery = (Query) getCommand("SELECT a.e1 as x, pm1.g1.e1 as y FROM pm1.g1 AS a, pm1.g1 ORDER BY 1");
    helpCheckElements(resolvedQuery.getOrderBy(), // $NON-NLS-1$
    new String[] { "a.e1" }, // $NON-NLS-1$
    new String[] { "pm1.g1.e1" });
}

Example 27 with Query

use of org.teiid.query.sql.lang.Query in project teiid by teiid.

the class TestOrderByRewrite method testOrderBy1.

@Test
public void testOrderBy1() throws Exception {
    // $NON-NLS-1$
    Query resolvedQuery = (Query) getCommand("SELECT pm1.g1.e1, e2, e3 as x, (5+2) as y FROM pm1.g1 ORDER BY x, y, pm1.g1.e1, e2");
    helpCheckElements(resolvedQuery.getOrderBy(), // $NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
    new String[] { "pm1.g1.e3", "pm1.g1.e1", "pm1.g1.e2" }, // $NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
    new String[] { "pm1.g1.e3", "pm1.g1.e1", "pm1.g1.e2" });
}

Example 28 with Query

use of org.teiid.query.sql.lang.Query in project teiid by teiid.

the class TestOrderByRewrite method testOrderBy13.

@Test
public void testOrderBy13() throws Exception {
    // $NON-NLS-1$
    Query resolvedQuery = (Query) getCommand("SELECT a.e1, pm1.g1.e1 FROM pm1.g1 AS a, pm1.g1 ORDER BY pm1.g1.e1");
    helpCheckElements(resolvedQuery.getOrderBy(), // $NON-NLS-1$
    new String[] { "pm1.g1.e1" }, // $NON-NLS-1$
    new String[] { "pm1.g1.e1" });
}

Example 29 with Query

use of org.teiid.query.sql.lang.Query in project teiid by teiid.

the class TestOrderByRewrite method testNumberedOrderBy1_1.

@Test
public void testNumberedOrderBy1_1() throws Exception {
    // $NON-NLS-1$
    Query resolvedQuery = (Query) getCommand("SELECT pm1.g1.e1, e2, e3 as x, (5 + e4) FROM pm1.g1 ORDER BY 3, 4, 1, 2");
    helpCheckElements(resolvedQuery.getOrderBy(), // $NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$
    new String[] { "pm1.g1.e3", "pm1.g1.e4", "pm1.g1.e1", "pm1.g1.e2" }, // $NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$
    new String[] { "pm1.g1.e3", "pm1.g1.e4", "pm1.g1.e1", "pm1.g1.e2" });
    helpCheckExpressionsSymbols(resolvedQuery.getOrderBy(), // $NON-NLS-1$
    new String[] { "(5.0 + e4)" });
}

Example 30 with Query

use of org.teiid.query.sql.lang.Query in project teiid by teiid.

the class TestOrderByRewrite method testNumberedOrderBy1.

@Test
public void testNumberedOrderBy1() throws Exception {
    // $NON-NLS-1$
    Query resolvedQuery = (Query) getCommand("SELECT pm1.g1.e1, e2, e3 as x, (5+2) as y FROM pm1.g1 ORDER BY 3, 4, 1, 2");
    helpCheckElements(resolvedQuery.getOrderBy(), // $NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
    new String[] { "pm1.g1.e3", "pm1.g1.e1", "pm1.g1.e2" }, // $NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
    new String[] { "pm1.g1.e3", "pm1.g1.e1", "pm1.g1.e2" });
    helpCheckExpressionsSymbols(resolvedQuery.getOrderBy(), new String[] {});
}