Examples of BasicSourceCapabilities

org.teiid.query.optimizer.capabilities.BasicSourceCapabilities

Examples of org.teiid.query.optimizer.capabilities.BasicSourceCapabilities

    /**
     * Can't push aggs due to not being able to push COUNT in the HAVING clause.
     */
    @Test public void testPushAggregate5() {
        FakeCapabilitiesFinder capFinder = new FakeCapabilitiesFinder();
        BasicSourceCapabilities caps = getTypicalCapabilities();
        caps.setCapabilitySupport(Capability.CRITERIA_COMPARE_ORDERED, true);
        caps.setCapabilitySupport(Capability.QUERY_AGGREGATES, true);
        caps.setCapabilitySupport(Capability.QUERY_AGGREGATES_MAX, true);
        caps.setCapabilitySupport(Capability.QUERY_AGGREGATES_COUNT, false);
        capFinder.addCapabilities("pm1", caps); //$NON-NLS-1$
         
        ProcessorPlan plan = helpPlan(
            "SELECT e2, MAX(e1) FROM pm1.g1 GROUP BY e2 HAVING COUNT(e1) > 0", //$NON-NLS-1$
            FakeMetadataFactory.example1Cached(),

View Full Code Here

Examples of org.teiid.query.optimizer.capabilities.BasicSourceCapabilities

    /**
     * Can't push aggs due to not being able to push function inside the aggregate
     */
    @Test public void testPushAggregate6() {
        FakeCapabilitiesFinder capFinder = new FakeCapabilitiesFinder();
        BasicSourceCapabilities caps = getTypicalCapabilities();
        caps.setCapabilitySupport(Capability.QUERY_AGGREGATES, true);
        caps.setCapabilitySupport(Capability.QUERY_AGGREGATES_COUNT, true);
        capFinder.addCapabilities("pm1", caps); //$NON-NLS-1$
         
        ProcessorPlan plan = helpPlan(
            "SELECT COUNT(length(e1)) FROM pm1.g1", //$NON-NLS-1$
            FakeMetadataFactory.example1Cached(),

View Full Code Here

Examples of org.teiid.query.optimizer.capabilities.BasicSourceCapabilities

    /**
     * Can't push aggs due to not being able to push function inside having
     */
    @Test public void testPushAggregate7() {
        FakeCapabilitiesFinder capFinder = new FakeCapabilitiesFinder();
        BasicSourceCapabilities caps = new BasicSourceCapabilities();
        caps.setCapabilitySupport(Capability.QUERY_AGGREGATES, true);
        caps.setCapabilitySupport(Capability.QUERY_AGGREGATES_COUNT, true);
        capFinder.addCapabilities("pm1", caps); //$NON-NLS-1$
         
        ProcessorPlan plan = helpPlan(
            "SELECT COUNT(*) FROM pm1.g1 GROUP BY e1 HAVING length(e1) > 0", //$NON-NLS-1$
            FakeMetadataFactory.example1Cached(),

View Full Code Here

Examples of org.teiid.query.optimizer.capabilities.BasicSourceCapabilities

    /**
     * BQT query that is failing
     */
    @Test public void testPushAggregate8() throws Exception {
        FakeCapabilitiesFinder capFinder = new FakeCapabilitiesFinder();
        BasicSourceCapabilities caps = new BasicSourceCapabilities();
        caps.setCapabilitySupport(Capability.QUERY_SELECT_EXPRESSION, true);
        caps.setCapabilitySupport(Capability.QUERY_FROM_GROUP_ALIAS, true);
        caps.setCapabilitySupport(Capability.CRITERIA_COMPARE_EQ, true);
        caps.setCapabilitySupport(Capability.CRITERIA_IN, true);
        caps.setCapabilitySupport(Capability.QUERY_AGGREGATES, true);
        caps.setCapabilitySupport(Capability.QUERY_AGGREGATES_MAX, true);
        caps.setCapabilitySupport(Capability.QUERY_SUBQUERIES_CORRELATED, true);
        caps.setCapabilitySupport(Capability.QUERY_SUBQUERIES_SCALAR, true);
        capFinder.addCapabilities("BQT1", caps); //$NON-NLS-1$
         
        String sqlIn =          
            "SELECT intkey FROM bqt1.smalla AS sa WHERE (sa.intkey = 46) AND " + //$NON-NLS-1$
            "(sa.stringkey IN (46)) AND (sa.datevalue = (" + //$NON-NLS-1$

View Full Code Here

Examples of org.teiid.query.optimizer.capabilities.BasicSourceCapabilities

        checkNodeTypes(plan, FULL_PUSHDOWN);         
    }


    @Test public void testPushFunctionInCriteria1() {
        FakeCapabilitiesFinder capFinder = new FakeCapabilitiesFinder();
        BasicSourceCapabilities caps = new BasicSourceCapabilities();
        caps.setCapabilitySupport(Capability.CRITERIA_COMPARE_EQ, true);
        caps.setFunctionSupport(SourceSystemFunctions.UCASE, true); 
        capFinder.addCapabilities("pm1", caps); //$NON-NLS-1$


        // Add join capability to pm1
        FakeMetadataFacade metadata = FakeMetadataFactory.example1Cached();

View Full Code Here

Examples of org.teiid.query.optimizer.capabilities.BasicSourceCapabilities

        checkNodeTypes(plan, FULL_PUSHDOWN);                                    
    }


    @Test public void testPushFunctionInSelect1() {
        FakeCapabilitiesFinder capFinder = new FakeCapabilitiesFinder();
        BasicSourceCapabilities caps = new BasicSourceCapabilities();
        caps.setCapabilitySupport(Capability.QUERY_SELECT_EXPRESSION, true);
        caps.setCapabilitySupport(Capability.CRITERIA_COMPARE_EQ, true);
        caps.setFunctionSupport(SourceSystemFunctions.UCASE, true); 
        caps.setFunctionSupport(SourceSystemFunctions.LCASE, true); 
        capFinder.addCapabilities("pm1", caps); //$NON-NLS-1$


        // Add join capability to pm1
        FakeMetadataFacade metadata = FakeMetadataFactory.example1Cached();

View Full Code Here

Examples of org.teiid.query.optimizer.capabilities.BasicSourceCapabilities

        checkNodeTypes(plan, FULL_PUSHDOWN);                                    
    }


    @Test public void testPushFunctionInSelect2() {
        FakeCapabilitiesFinder capFinder = new FakeCapabilitiesFinder();
        BasicSourceCapabilities caps = new BasicSourceCapabilities();
        caps.setCapabilitySupport(Capability.QUERY_SELECT_EXPRESSION, true);
        caps.setCapabilitySupport(Capability.CRITERIA_COMPARE_EQ, true);
        caps.setFunctionSupport(SourceSystemFunctions.UCASE, true); 
        caps.setFunctionSupport(SourceSystemFunctions.LCASE, true); 
        capFinder.addCapabilities("pm1", caps); //$NON-NLS-1$


        // Add join capability to pm1
        FakeMetadataFacade metadata = FakeMetadataFactory.example1Cached();

View Full Code Here

Examples of org.teiid.query.optimizer.capabilities.BasicSourceCapabilities

        checkNodeTypes(plan, FULL_PUSHDOWN);                                    
    }
    
    @Test public void testPushFunctionInSelect3() {
        FakeCapabilitiesFinder capFinder = new FakeCapabilitiesFinder();
        BasicSourceCapabilities caps = new BasicSourceCapabilities();
        caps.setCapabilitySupport(Capability.CRITERIA_COMPARE_EQ, true);
        caps.setFunctionSupport(SourceSystemFunctions.UCASE, true); 
        caps.setFunctionSupport(SourceSystemFunctions.LCASE, false); 
        capFinder.addCapabilities("pm1", caps); //$NON-NLS-1$


        // Add join capability to pm1
        FakeMetadataFacade metadata = FakeMetadataFactory.example1Cached();

View Full Code Here

Examples of org.teiid.query.optimizer.capabilities.BasicSourceCapabilities

        });                                    
    }    


    @Test public void testPushFunctionInSelect4() {
        FakeCapabilitiesFinder capFinder = new FakeCapabilitiesFinder();
        BasicSourceCapabilities caps = new BasicSourceCapabilities();
        caps.setCapabilitySupport(Capability.QUERY_SELECT_EXPRESSION, true);
        caps.setCapabilitySupport(Capability.CRITERIA_COMPARE_EQ, true);
        caps.setFunctionSupport(SourceSystemFunctions.UCASE, true); 
        caps.setFunctionSupport(SourceSystemFunctions.LCASE, true); 
        capFinder.addCapabilities("pm1", caps); //$NON-NLS-1$


        // Add join capability to pm1
        FakeMetadataFacade metadata = FakeMetadataFactory.example1Cached();

View Full Code Here

Examples of org.teiid.query.optimizer.capabilities.BasicSourceCapabilities

        checkNodeTypes(plan, FULL_PUSHDOWN);                                    
    }    


    @Test public void testPushFunctionInSelect5() {
        FakeCapabilitiesFinder capFinder = new FakeCapabilitiesFinder();
        BasicSourceCapabilities caps = new BasicSourceCapabilities();
        caps.setCapabilitySupport(Capability.QUERY_SELECT_EXPRESSION, true);
        caps.setCapabilitySupport(Capability.CRITERIA_COMPARE_EQ, true);
        caps.setFunctionSupport(SourceSystemFunctions.UCASE, true); 
        caps.setFunctionSupport(SourceSystemFunctions.LCASE, true); 
        capFinder.addCapabilities("pm1", caps); //$NON-NLS-1$


        // Add join capability to pm1
        FakeMetadataFacade metadata = FakeMetadataFactory.example1Cached();

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.