Package org.teiid.query.optimizer.capabilities

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

794
795
796
797
798
799
800
801
802
    }
   
    @Test public void testUpdate2() throws Exception {
      BasicSourceCapabilities bsc = TestOptimizer.getTypicalCapabilities();
      bsc.setFunctionSupport(SourceSystemFunctions.CONVERT, true);
      DefaultCapabilitiesFinder dcf = new DefaultCapabilitiesFinder(bsc);
        helpPlan("Update pm1.g1 Set pm1.g1.e1= LTRIM('MyString'), pm1.g1.e2= 1 where pm1.g1.e2= convert(pm1.g1.e4, integer)", FakeMetadataFactory.example1Cached(), //$NON-NLS-1$
      new String[] { "UPDATE pm1.g1 SET e1 = 'MyString', e2 = 1 WHERE pm1.g1.e2 = convert(pm1.g1.e4, integer)"}, dcf, ComparisonMode.EXACT_COMMAND_STRING ); //$NON-NLS-1$
    }
View Full Code Here
802
803
804
805
806
807
808
809
810
    }
   
    @Test public void testDelete() throws Exception {
      BasicSourceCapabilities bsc = TestOptimizer.getTypicalCapabilities();
      bsc.setFunctionSupport(SourceSystemFunctions.CONVERT, true);
      DefaultCapabilitiesFinder dcf = new DefaultCapabilitiesFinder(bsc);
      helpPlan("Delete from pm1.g1 where pm1.g1.e1 = cast(pm1.g1.e2 AS string)", FakeMetadataFactory.example1Cached(), //$NON-NLS-1$
      new String[] { "DELETE FROM pm1.g1 WHERE pm1.g1.e1 = convert(pm1.g1.e2, string)"}, dcf, ComparisonMode.EXACT_COMMAND_STRING ); //$NON-NLS-1$
    }
View Full Code Here
1022
1023
1024
1025
1026
1027
1028
    }  

    @Test public void testSimpleCrossJoin1() throws Exception {
        helpPlan("select pm1.g1.e1 FROM pm1.g1, pm1.g2", example1(), //$NON-NLS-1$
            new String[] { "SELECT pm1.g1.e1 FROM pm1.g1", //$NON-NLS-1$
                "SELECT pm1.g2.e1 FROM pm1.g2" }, new DefaultCapabilitiesFinder(), ComparisonMode.EXACT_COMMAND_STRING );     //$NON-NLS-1$
    }
View Full Code Here
1041
1042
1043
1044
1045
1046
1047
    @Test public void testMultiSourceCrossJoin() throws Exception {
        helpPlan("select pm1.g1.e1 FROM pm1.g1, pm1.g2, pm1.g3", example1(), //$NON-NLS-1$
            new String[] { "SELECT pm1.g1.e1 FROM pm1.g1", //$NON-NLS-1$
                "SELECT pm1.g2.e1 FROM pm1.g2", //$NON-NLS-1$
                "SELECT pm1.g3.e1 FROM pm1.g3" }, new DefaultCapabilitiesFinder(), ComparisonMode.EXACT_COMMAND_STRING );     //$NON-NLS-1$
    }
View Full Code Here
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
    }
   
    @Test public void testDepJoinHintBaseline() throws Exception {
        ProcessorPlan plan = helpPlan("select * FROM vm1.g4", example1(), //$NON-NLS-1$
            new String[] { "SELECT pm1.g1.e1 FROM pm1.g1", //$NON-NLS-1$
                            "SELECT pm1.g2.e1 FROM pm1.g2" }, new DefaultCapabilitiesFinder(), ComparisonMode.EXACT_COMMAND_STRING ); //$NON-NLS-1$
        checkNodeTypes(plan, new int[] {
            2,      // Access
            0,      // DependentAccess
            0,      // DependentSelect
            0,      // DependentProject
View Full Code Here
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
                            "SELECT pm1.g5.e1 FROM pm1.g5",  //$NON-NLS-1$
                            "SELECT pm1.g6.e1 FROM pm1.g6",  //$NON-NLS-1$
                            "SELECT pm1.g7.e1 FROM pm1.g7", //$NON-NLS-1$
                            "SELECT pm1.g8.e1 FROM pm1.g8", //$NON-NLS-1$
                            "SELECT x.e1 FROM pm1.g1 AS x", //$NON-NLS-1$
                            "SELECT y.e1 FROM pm1.g2 AS y" }, new DefaultCapabilitiesFinder(), ComparisonMode.CORRECTED_COMMAND_STRING ); //$NON-NLS-1$
                           
        long elapsed = System.currentTimeMillis() - begin;  
        assertTrue("Did not plan many join query in reasonable time frame: " + elapsed + " ms", elapsed < 4000); //$NON-NLS-1$ //$NON-NLS-2$
    }
View Full Code Here
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
   
    @Test public void testAllJoinsInSingleClause() throws Exception {
        ProcessorPlan plan = helpPlan("select pm1.g1.e1 FROM pm1.g1 join (pm1.g2 right outer join pm1.g3 on pm1.g2.e1=pm1.g3.e1) on pm1.g1.e1=pm1.g3.e1", example1(),  //$NON-NLS-1$
            new String[] { "SELECT pm1.g1.e1 FROM pm1.g1",  //$NON-NLS-1$
                            "SELECT pm1.g2.e1 FROM pm1.g2", //$NON-NLS-1$
                            "SELECT pm1.g3.e1 FROM pm1.g3" }, new DefaultCapabilitiesFinder(), ComparisonMode.EXACT_COMMAND_STRING); //$NON-NLS-1$
        checkNodeTypes(plan, new int[] {
            3,      // Access
            0,      // DependentAccess
            0,      // DependentSelect
            0,      // DependentProject
View Full Code Here
1379
1380
1381
1382
1383
1384
1385
1386
1387
1388
1389
        });
    }
   
    @Test public void testNotPushDistinct() throws Exception {
        ProcessorPlan plan = helpPlan("select distinct e1 from pm1.g1", FakeMetadataFactory.example1Cached(), //$NON-NLS-1$
            new String[] { "SELECT pm1.g1.e1 FROM pm1.g1" }, new DefaultCapabilitiesFinder(), ComparisonMode.EXACT_COMMAND_STRING); //$NON-NLS-1$
        checkNodeTypes(plan, new int[] {
            1,      // Access
            0,      // DependentAccess
            0,      // DependentSelect
            0,      // DependentProject
View Full Code Here
5737
5738
5739
5740
5741
5742
5743
5744
     */
    @Test public void testCase4017() throws Exception {
       
        String sql = "SELECT env('soap_host') AS HOST, intkey from bqt2.smalla"; //$NON-NLS-1$
       
        helpPlan(sql, FakeMetadataFactory.exampleBQTCached(), null, new DefaultCapabilitiesFinder(),
                                      new String[] {"SELECT bqt2.smalla.intkey FROM bqt2.smalla"}, ComparisonMode.EXACT_COMMAND_STRING);  //$NON-NLS-1$     
    }
View Full Code Here
40
41
42
43
44
45
46
47
48
        super(name);
    }


    public void testFindCapabilities() throws Exception {
        CapabilitiesFinder capFinder = new DefaultCapabilitiesFinder();
        SourceCapabilities caps = capFinder.findCapabilities("blah"); //$NON-NLS-1$
        assertNotNull("Default capabilities should not be null", caps); //$NON-NLS-1$
    }
View Full Code Here
TOP

Related Classes of org.teiid.query.optimizer.capabilities.DefaultCapabilitiesFinder

  • org.teiid.dqp.internal.process.TestDataTierManager
  • org.teiid.dqp.internal.process.TestPreparedStatement
  • org.teiid.query.optimizer.capabilities.TestDefaultCapabilitiesFinder
  • org.teiid.query.optimizer.proc.TestProcedurePlanner
  • org.teiid.query.optimizer.relational.rules.TestCapabilitiesUtil
  • org.teiid.query.optimizer.relational.rules.TestRulePushSelectCriteria
  • org.teiid.query.optimizer.TestAggregatePushdown
  • org.teiid.query.optimizer.TestBatchedUpdatePlanner
  • org.teiid.query.optimizer.TestOptimizer
  • org.teiid.query.optimizer.TestRuleMergeVirtual
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.