Examples of ExpressionCriteria

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

2858
2859
2860
2861
2862
2863
2864
2865
  }

  /** SELECT a or b from g */
  @Test public void testOrInSelect(){
    Query query = new Query();
    query.setSelect(new Select(Arrays.asList(new ExpressionSymbol("foo", new CompoundCriteria(CompoundCriteria.OR, Arrays.asList(new ExpressionCriteria(new ElementSymbol("a")), new ExpressionCriteria(new ElementSymbol("b"))))))));
    helpTest("select a or b", "SELECT (a) OR (b)", query);
  }
View Full Code Here

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

6855
6856
6857
6858
6859
6860
6861
6862
      f.setTypeString("CLOB");
      helpTestExpression("xmlserialize(x as CLOB)", "XMLSERIALIZE(x AS CLOB)", f);
    }
   
    @Test public void testExpressionCriteria() throws Exception {
      SearchedCaseExpression sce = new SearchedCaseExpression(Arrays.asList(new ExpressionCriteria(new ElementSymbol("x"))), Arrays.asList(new ElementSymbol("y")));
      helpTestExpression("case when x then y end", "CASE WHEN x THEN y END", sce);
    }
View Full Code Here

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

6860
6861
6862
6863
6864
6865
6866
6867
      SearchedCaseExpression sce = new SearchedCaseExpression(Arrays.asList(new ExpressionCriteria(new ElementSymbol("x"))), Arrays.asList(new ElementSymbol("y")));
      helpTestExpression("case when x then y end", "CASE WHEN x THEN y END", sce);
    }
   
    @Test public void testExpressionCriteria1() throws Exception {
      SearchedCaseExpression sce = new SearchedCaseExpression(Arrays.asList(new NotCriteria(new ExpressionCriteria(new ElementSymbol("x")))), Arrays.asList(new ElementSymbol("y")));
      helpTestExpression("case when not x then y end", "CASE WHEN NOT (x) THEN y END", sce);
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.