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

Example 31 with Query

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

the class TestOrderByRewrite method testDefect10729.

/**
 * partially-qualified ORDER BY's with ambiguous short group names
 */
@Test
public void testDefect10729() throws Exception {
    // $NON-NLS-1$
    Query resolvedQuery = (Query) getCommand("SELECT pm1.g1.e1 FROM pm1.g1 ORDER BY g1.e1");
    helpCheckElements(resolvedQuery.getOrderBy(), // $NON-NLS-1$
    new String[] { "pm1.g1.e1" }, // $NON-NLS-1$
    new String[] { "pm1.g1.e1" });
}

Example 32 with Query

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

the class TestAccessNode method testExecCount.

@Test
public void testExecCount() throws Exception {
    // Setup
    AccessNode node = new AccessNode(1);
    // $NON-NLS-1$
    Query query = (Query) TestResolver.helpResolve("SELECT e1, e2 FROM pm1.g1 WHERE e2 = 5", RealMetadataFactory.example1Cached());
    node.setCommand(query);
    CommandContext context = new CommandContext();
    BufferManager bm = BufferManagerFactory.getStandaloneBufferManager();
    FakeDataManager dataManager = new FakeDataManager();
    TestProcessor.sampleData1(dataManager);
    node.setElements(query.getProjectedSymbols());
    node.initialize(context, bm, dataManager);
    // Call open()
    node.open();
    // $NON-NLS-1$
    assertEquals(Arrays.asList("SELECT e1, e2 FROM pm1.g1 WHERE e2 = 5"), dataManager.getQueries());
}

Example 33 with Query

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

the class TestAccessNode method testShouldExecuteLimitZero.

@Test
public void testShouldExecuteLimitZero() throws Exception {
    // $NON-NLS-1$
    Query query = (Query) QueryParser.getQueryParser().parseCommand("SELECT e1, e2 FROM pm1.g1 LIMIT 0");
    assertFalse(RelationalNodeUtil.shouldExecute(query, false));
}

Example 34 with Query

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

the class TestAccessNode method testOpen_Defect16059.

@Test
public void testOpen_Defect16059() throws Exception {
    // $NON-NLS-1$
    Query query = (Query) TestResolver.helpResolve("SELECT e1, e2 FROM pm1.g1 WHERE e2 = 5 AND ? IS NULL", RealMetadataFactory.example1Cached());
    IsNullCriteria nullCrit = (IsNullCriteria) ((CompoundCriteria) query.getCriteria()).getCriteria(1);
    nullCrit.setExpression(new Constant(null));
    // $NON-NLS-1$
    helpTestOpen(query, "SELECT e1, e2 FROM pm1.g1 WHERE e2 = 5", true);
}

Example 35 with Query

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

the class TestAlterResolving method testAlterProcedure.

@Test
public void testAlterProcedure() {
    AlterProcedure alterProc = (AlterProcedure) helpResolve("alter procedure MMSP5 as begin select param1; end", RealMetadataFactory.exampleBQTCached());
    assertNotNull(alterProc.getTarget().getMetadataID());
    Query q = (Query) ((CommandStatement) alterProc.getDefinition().getBlock().getStatements().get(0)).getCommand();
    assertTrue(((ElementSymbol) q.getSelect().getSymbol(0)).isExternalReference());
}