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

Example 21 with Query

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

the class TestOrderByRewrite method testOrderBy9.

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

Example 22 with Query

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

the class TestOrderByRewrite method testAliasedOrderBy_ConstantElement.

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

Example 23 with Query

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

the class TestOrderByRewrite method testNumberedOrderBy1_4.

@Test
public void testNumberedOrderBy1_4() throws Exception {
    // $NON-NLS-1$
    String sql = "select e1, (select e2 from pm4.g1) from pm4.g2 X order by 2";
    Query resolvedQuery = (Query) getCommand(sql);
    helpCheckExpressionsSymbols(resolvedQuery.getOrderBy(), // $NON-NLS-1$
    new String[] { "(SELECT e2 FROM pm4.g1 LIMIT 2)" });
}

Example 24 with Query

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

the class TestOrderByRewrite method testNumberedOrderBy4.

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

Example 25 with Query

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

the class TestOrderByRewrite method testNumberedOrderBy5.

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