Examples of LikeExpression

com.salesforce.phoenix.expression.LikeExpression
Implementation for LIKE operation where the first child expression is the string and the second is the pattern. The pattern supports '_' character for single character wildcard match and '%' for zero or more character match. where these characters may be escaped by preceding them with a '\'. Example: foo LIKE 'ab%' will match a row in which foo starts with 'ab' @author jtaylor @since 0.1
net.sf.jsqlparser.expression.operators.relational.LikeExpression
org.apache.phoenix.expression.LikeExpression
Implementation for LIKE operation where the first child expression is the string and the second is the pattern. The pattern supports '_' character for single character wildcard match and '%' for zero or more character match. where these characters may be escaped by preceding them with a '\'. Example: foo LIKE 'ab%' will match a row in which foo starts with 'ab' @since 0.1
org.araneaframework.backend.list.memorybased.expression.compare.LikeExpression
org.codehaus.jparsec.examples.sql.ast.LikeExpression
Represents "expr like 'pattern' escape 'escape'" expression. @author Ben Yu
org.eclipse.persistence.jpa.jpql.parser.LikeExpression
The LIKE condition is used to specify a search for a pattern.
The string_expression must have a string value. The pattern_value is a string literal or a string-valued input parameter in which an underscore (_) stands for any single character, a percent (%) character stands for any sequence of characters (including the empty sequence), and all other characters stand for themselves. The optional escape_character is a single-character string literal or a character-valued input parameter (i.e., char or Character) and is used to escape the special meaning of the underscore and percent characters in pattern_value.

BNF: like_expression ::= string_expression [NOT] LIKE pattern_value [ESCAPE escape_character]
@version 2.4.2 @since 2.3 @author Pascal Filion

Examples of org.apache.phoenix.expression.LikeExpression

                    rhs = LiteralExpression.newConstant(rhsLiteral, PDataType.CHAR, rhs.isDeterministic());
                    return new ComparisonExpression(op, Arrays.asList(lhs,rhs));
                }
            }
        }
        Expression expression = new LikeExpression(children);
        if (node.isStateless()) {
            ImmutableBytesWritable ptr = context.getTempPtr();
            if (!expression.evaluate(null, ptr)) {
                return LiteralExpression.newConstant(null, expression.isDeterministic());
            } else {
                return LiteralExpression.newConstant(Boolean.TRUE.equals(PDataType.BOOLEAN.toObject(ptr)) ^ node.isNegate(), expression.isDeterministic());
            }
        }
        if (node.isNegate()) {
            expression = new NotExpression(expression);
        }

View Full Code Here

Examples of org.araneaframework.backend.list.memorybased.expression.compare.LikeExpression

    }    
    public Like() {
      super();
    }
    protected Expression buildAction(Map filterInfo, Expression leftOperand, Expression rightOperand) {
      return new LikeExpression(leftOperand, (ValueExpression) rightOperand, isIgnoreCase());
    }

View Full Code Here

Examples of org.araneaframework.backend.list.memorybased.expression.compare.LikeExpression

  }
  
  public static class Like extends SimpleProcedureFilter {
    private static final long serialVersionUID = 1L;
    protected Expression buildAction(Map filterInfo, Expression leftOperand, Expression rightOperand) {
      return new LikeExpression(leftOperand, (ValueExpression) rightOperand, isIgnoreCase());
    }

View Full Code Here

Examples of org.araneaframework.backend.list.memorybased.expression.compare.LikeExpression

    }    
    public Like(Object value) {
      super(value);
    }
    protected Expression buildAction(Map filterInfo, Expression leftOperand, Expression rightOperand) {
      return new LikeExpression(leftOperand, (ValueExpression) rightOperand, isIgnoreCase());
    }

View Full Code Here

Examples of org.araneaframework.backend.list.memorybased.expression.compare.LikeExpression


  public void testLikeExpression() throws ExpressionEvaluationException {
    log.debug("Testing LikeExpression");
    boolean ignoreCase = false;
    try {
      new LikeExpression(null, null, ignoreCase).evaluate(this.resolver);
      fail("LikeExpression operands can not be nulls");
    } catch (Exception e) {
      // normal
    }
    try {
      new LikeExpression(this.tom, null, ignoreCase)
          .evaluate(this.resolver);
      fail("LikeExpression operands can not be nulls");
    } catch (Exception e) {
      // normal
    }
    try {
      new LikeExpression(null, this.om, ignoreCase)
          .evaluate(this.resolver);
      fail("LikeExpression operands can not be nulls");
    } catch (Exception e) {
      // normal
    }


    // evaluating
    assertEquals("LikeExpression must return true", Boolean.TRUE,
        new LikeExpression(this.tom, this.om, false)
            .evaluate(this.resolver));
    assertEquals("LikeExpression must return true", Boolean.TRUE,
        new LikeExpression(this.tom, this.tm, true)
            .evaluate(this.resolver));
    assertEquals("LikeExpression must return false", Boolean.FALSE,
        new LikeExpression(this.tom, this.tm, false)
            .evaluate(this.resolver));
    assertEquals("LikeExpression must return false", Boolean.FALSE,
        new LikeExpression(this.jerry, this.om, false)
            .evaluate(this.resolver));
  }

View Full Code Here

Examples of org.araneaframework.backend.list.memorybased.expression.compare.LikeExpression

  
  // String  
  
  class LikeTranslator extends CompositeExprToSqlExprTranslator {
    protected SqlExpression translateParent(Expression expr, SqlExpression[] sqlChildren) {
      LikeExpression like = (LikeExpression) expr;      
      SqlExpression var = sqlChildren[0];
      SqlExpression mask = new SqlValueExpression(
          "%" + convertValue(like.getMask()) + "%");
      if (like.getIgnoreCase()) {
        var = new SqlUpperExpression(var);
        mask = new SqlUpperExpression(mask);
      }
      return new SqlLikeExpression(var, mask);
    }

View Full Code Here

Examples of org.codehaus.jparsec.examples.sql.ast.LikeExpression

    assertParser(parser, "2 >= 1", new BinaryExpression(number(2), Op.GE, number(1)));
    assertParser(parser, "1 is null",
        new BinaryExpression(number(1), Op.IS, NullExpression.instance));
    assertParser(parser, "1 is not null",
        new BinaryExpression(number(1), Op.NOT, NullExpression.instance));
    assertParser(parser, "1 like 2", new LikeExpression(number(1), true, number(2), null));
    assertParser(parser, "1 BETWEEN 0 and 2",
        new BetweenExpression(number(1), true, number(0), number(2)));
    assertParser(parser, "1 not between 2 and 0",
        new BetweenExpression(number(1), false, number(2), number(0)));
  }

View Full Code Here

Examples of org.codehaus.jparsec.examples.sql.ast.LikeExpression

        new BetweenExpression(number(1), false, number(2), number(0)));
  }
  
  public void testLike() {
    Parser<Expression> parser = ExpressionParser.like(NUMBER);
    assertParser(parser, "1 like 2", new LikeExpression(number(1), true, number(2), null));
    assertParser(parser, "1 not like 2", new LikeExpression(number(1), false, number(2), null));
    assertParser(parser, "1 like 2 escape 3",
        new LikeExpression(number(1), true, number(2), number(3)));
    assertParser(parser, "1 not like 2 escape 3",
        new LikeExpression(number(1), false, number(2), number(3)));
  }

View Full Code Here

Examples of org.codehaus.jparsec.examples.sql.ast.LikeExpression

    assertParser(parser, "1 = 2", new BinaryExpression(number(1), Op.EQ, number(2)));
    assertParser(parser, "1 is null",
        new BinaryExpression(number(1), Op.IS, NullExpression.instance));
    assertParser(parser, "1 is not null",
        new BinaryExpression(number(1), Op.NOT, NullExpression.instance));
    assertParser(parser, "1 like 2", new LikeExpression(number(1), true, number(2), null));
    assertParser(parser, "(1 < 2 or not exists t)",
        new BinaryExpression(
            new BinaryExpression(number(1), Op.LT, number(2)),
            Op.OR,
            new UnaryExpression(Op.NOT,

View Full Code Here

Examples of org.codehaus.jparsec.examples.sql.ast.LikeExpression

    assertParser(parser, "2 >= 1", new BinaryExpression(number(2), Op.GE, number(1)));
    assertParser(parser, "1 is null",
        new BinaryExpression(number(1), Op.IS, NullExpression.instance));
    assertParser(parser, "1 is not null",
        new BinaryExpression(number(1), Op.NOT, NullExpression.instance));
    assertParser(parser, "1 like 2", new LikeExpression(number(1), true, number(2), null));
    assertParser(parser, "1 BETWEEN 0 and 2",
        new BetweenExpression(number(1), true, number(0), number(2)));
    assertParser(parser, "1 not between 2 and 0",
        new BetweenExpression(number(1), false, number(2), number(0)));
  }

View Full Code Here

0 1 2

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.