Examples of org.teiid.query.sql.lang.Select

org.teiid.query.sql.lang.Select
This class represents the SELECT clause of a query, which defines what elements or expressions are returned from the query.

    @Test public void testReservedWordGroup2(){
        GroupSymbol g = new GroupSymbol("newModel5.ResultSetDocument.MappingClasses.from.from.Query1InputSet"); //$NON-NLS-1$
        From from = new From();
        from.addGroup(g);


        Select select = new Select();
        select.addSymbol(new AllSymbol());


        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);

View Full Code Here

    @Test public void testXMLCriteriaWithAttribute() {
        GroupSymbol g = new GroupSymbol("model.doc"); //$NON-NLS-1$
        From from = new From();
        from.addGroup(g);


        Select select = new Select();
        select.addSymbol(new AllSymbol());


        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);

View Full Code Here

  @Test public void testStringNotEqual(){
    GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$
    From from = new From();
    from.addGroup(g);


    Select select = new Select();
    ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
    select.addSymbol(a);


    Expression constant = new Constant("value"); //$NON-NLS-1$
    Criteria crit = new CompareCriteria(a, CompareCriteria.NE, constant);


    Query query = new Query();

View Full Code Here

    @Test public void testBetween1(){
        GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$
        From from = new From();
        from.addGroup(g);


        Select select = new Select();
        ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
        select.addSymbol(a);


        Expression constant1 = new Constant(new Integer(1000));
        Expression constant2 = new Constant(new Integer(2000));
        Criteria crit = new BetweenCriteria(a, constant1, constant2);

View Full Code Here

    @Test public void testBetween2(){
        GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$
        From from = new From();
        from.addGroup(g);


        Select select = new Select();
        ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
        select.addSymbol(a);


        Expression constant1 = new Constant(new Integer(1000));
        Expression constant2 = new Constant(new Integer(2000));
        BetweenCriteria crit = new BetweenCriteria(a, constant1, constant2);
        crit.setNegated(true);

View Full Code Here

  @Test public void testCompareLT(){
    GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$
    From from = new From();
    from.addGroup(g);


    Select select = new Select();
    ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
    select.addSymbol(a);


    Expression constant = new Constant(new Integer(1000));
    Criteria crit = new CompareCriteria(a, CompareCriteria.LT, constant);


    Query query = new Query();

View Full Code Here

  @Test public void testCompareGT(){
    GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$
    From from = new From();
    from.addGroup(g);


    Select select = new Select();
    ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
    select.addSymbol(a);


    Expression constant = new Constant(new Integer(1000));
    Criteria crit = new CompareCriteria(a, CompareCriteria.GT, constant);


    Query query = new Query();

View Full Code Here

  @Test public void testCompareLE(){
    GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$
    From from = new From();
    from.addGroup(g);


    Select select = new Select();
    ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
    select.addSymbol(a);


    Expression constant = new Constant(new Integer(1000));
    Criteria crit = new CompareCriteria(a, CompareCriteria.LE, constant);


    Query query = new Query();

View Full Code Here

  @Test public void testCompareGE(){
    GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$
    From from = new From();
    from.addGroup(g);


    Select select = new Select();
    ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
    select.addSymbol(a);


    Expression constant = new Constant(new Integer(1000));
    Criteria crit = new CompareCriteria(a, CompareCriteria.GE, constant);


    Query query = new Query();

View Full Code Here

  private void helpTestCompoundCompare(String testSQL){
    GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$
    From from = new From();
    from.addGroup(g);


    Select select = new Select();
    ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
    select.addSymbol(a);


    Criteria crit1 = new CompareCriteria(new ElementSymbol("b"), CompareCriteria.EQ, new ElementSymbol("x")); //$NON-NLS-1$ //$NON-NLS-2$
    Expression constant = new Constant(new Integer(1000));
    Criteria crit2 = new CompareCriteria(a, CompareCriteria.EQ, constant);
    Criteria crit = new CompoundCriteria(CompoundCriteria.AND, crit1, crit2);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.teiid.query.sql.lang.Select

org.teiid.cdk.CommandBuilder

org.teiid.query.optimizer.relational.RelationalPlanner

org.teiid.query.optimizer.relational.rules.FrameUtil

org.teiid.query.optimizer.relational.rules.RuleCollapseSource

org.teiid.query.optimizer.relational.rules.RuleDecomposeJoin

org.teiid.query.optimizer.relational.rules.RulePushAggregates

org.teiid.query.optimizer.relational.rules.TestRuleChooseDependent

org.teiid.query.optimizer.relational.rules.TestRulePlaceAccess

org.teiid.query.optimizer.TriggerActionPlanner

org.teiid.query.optimizer.xml.QueryUtil

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.