Search in sources :

Example 81 with Query

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

the class TestOrderByRewrite method testOrderBy11.

@Test
public void testOrderBy11() throws Exception {
    // $NON-NLS-1$
    Query resolvedQuery = (Query) getCommand("SELECT a.e1, b.e1 FROM pm1.g1 AS a, pm1.g1 AS b ORDER BY b.e1");
    helpCheckElements(resolvedQuery.getOrderBy(), // $NON-NLS-1$
    new String[] { "b.e1" }, // $NON-NLS-1$
    new String[] { "pm1.g1.e1" });
}
Also used : Query(org.teiid.query.sql.lang.Query) Test(org.junit.Test)

Example 82 with Query

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

the class TestOrderByRewrite method testOrderBy8.

@Test
public void testOrderBy8() throws Exception {
    // $NON-NLS-1$
    Query resolvedQuery = (Query) getCommand("SELECT x.e1 FROM pm1.g1 AS x ORDER BY e1");
    helpCheckElements(resolvedQuery.getOrderBy(), // $NON-NLS-1$
    new String[] { "x.e1" }, // $NON-NLS-1$
    new String[] { "pm1.g1.e1" });
}
Also used : Query(org.teiid.query.sql.lang.Query) Test(org.junit.Test)

Example 83 with Query

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

the class TestOrderByRewrite method testOrderBy14.

@Test
public void testOrderBy14() 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 x");
    helpCheckElements(resolvedQuery.getOrderBy(), // $NON-NLS-1$
    new String[] { "a.e1" }, // $NON-NLS-1$
    new String[] { "pm1.g1.e1" });
}
Also used : Query(org.teiid.query.sql.lang.Query) Test(org.junit.Test)

Example 84 with Query

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

the class TestOrderByRewrite method testOrderBy3.

@Test
public void testOrderBy3() throws Exception {
    // $NON-NLS-1$
    Query resolvedQuery = (Query) getCommand("SELECT * FROM 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" });
}
Also used : Query(org.teiid.query.sql.lang.Query) Test(org.junit.Test)

Example 85 with Query

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

the class TestAccessNode method testShouldExecuteAgg.

@Test
public void testShouldExecuteAgg() throws Exception {
    // $NON-NLS-1$
    Query query = (Query) QueryParser.getQueryParser().parseCommand("SELECT count(*) FROM pm1.g1 where false");
    assertTrue(RelationalNodeUtil.shouldExecute(query, false));
}
Also used : Query(org.teiid.query.sql.lang.Query) Test(org.junit.Test)

Aggregations

Query (org.teiid.query.sql.lang.Query)97 Test (org.junit.Test)58 GroupSymbol (org.teiid.query.sql.symbol.GroupSymbol)31 Select (org.teiid.query.sql.lang.Select)30 ElementSymbol (org.teiid.query.sql.symbol.ElementSymbol)26 From (org.teiid.query.sql.lang.From)25 Constant (org.teiid.query.sql.symbol.Constant)22 SetQuery (org.teiid.query.sql.lang.SetQuery)21 MultipleElementSymbol (org.teiid.query.sql.symbol.MultipleElementSymbol)20 UnaryFromClause (org.teiid.query.sql.lang.UnaryFromClause)13 Limit (org.teiid.query.sql.lang.Limit)10 ArrayList (java.util.ArrayList)9 Expression (org.teiid.query.sql.symbol.Expression)9 SQLException (java.sql.SQLException)7 Reference (org.teiid.query.sql.symbol.Reference)7 CompareCriteria (org.teiid.query.sql.lang.CompareCriteria)6 ODataApplicationException (org.apache.olingo.server.api.ODataApplicationException)5 List (java.util.List)4 ODataLibraryException (org.apache.olingo.server.api.ODataLibraryException)4 TeiidProcessingException (org.teiid.core.TeiidProcessingException)4