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 com.salesforce.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 net.sf.jsqlparser.expression.operators.relational.LikeExpression

                {if (true) return result;}
    throw new Error("Missing return statement in function");
  }


  final public Expression LikeExpression() throws ParseException {
        LikeExpression result = new LikeExpression();
        Expression leftExpression = null;
        Expression rightExpression = null;
    leftExpression = SimpleExpression();
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case K_NOT:
      jj_consume_token(K_NOT);
               result.setNot(true);
      break;
    default:
      jj_la1[92] = jj_gen;
      ;
    }
    jj_consume_token(K_LIKE);
    rightExpression = SimpleExpression();
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case K_ESCAPE:
      jj_consume_token(K_ESCAPE);
      token = jj_consume_token(S_CHAR_LITERAL);
                                         result.setEscape((new StringValue(token.image)).getValue());
      break;
    default:
      jj_la1[93] = jj_gen;
      ;
    }
                result.setLeftExpression(leftExpression);
                result.setRightExpression(rightExpression);
                {if (true) return result;}
    throw new Error("Missing return statement in function");
  }

View Full Code Here

Examples of net.sf.jsqlparser.expression.operators.relational.LikeExpression

        else if (exp instanceof GreaterThan)
            qualified = new GreaterThan();
        else if (exp instanceof GreaterThanEquals)
            qualified = new GreaterThanEquals();
        else if (exp instanceof LikeExpression)
            qualified = new LikeExpression();
        else if (exp instanceof MinorThan)
            qualified = new MinorThan();
        else if (exp instanceof MinorThanEquals)
            qualified = new MinorThanEquals();
        else if (exp instanceof NotEqualsTo)

View Full Code Here

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 (ExpressionUtil.isConstant(expression)) {
            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.apache.phoenix.expression.LikeExpression

    public static Expression constantComparison(CompareOp op, Expression e, Object o) {
        return  new ComparisonExpression(op, Arrays.asList(e, LiteralExpression.newConstant(o)));
    }


    public static Expression like(Expression e, Object o) {
        return  new LikeExpression(Arrays.asList(e, LiteralExpression.newConstant(o)));
    }

View Full Code Here

Examples of org.apache.phoenix.expression.LikeExpression

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

View Full Code Here

Examples of org.apache.phoenix.expression.LikeExpression

    public static Expression constantComparison(CompareOp op, Expression e, Object o) {
        return  new ComparisonExpression(op, Arrays.asList(e, LiteralExpression.newConstant(o)));
    }


    public static Expression like(Expression e, Object o) {
        return  new LikeExpression(Arrays.asList(e, LiteralExpression.newConstant(o)));
    }

View Full Code Here

Examples of org.apache.phoenix.expression.LikeExpression

    public static Expression constantComparison(CompareOp op, Expression e, Object o) {
        return  new ComparisonExpression(op, Arrays.asList(e, LiteralExpression.newConstant(o)));
    }


    public static Expression like(Expression e, Object o) {
        return  new LikeExpression(Arrays.asList(e, LiteralExpression.newConstant(o)));
    }

View Full Code Here

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 (ExpressionUtil.isConstant(expression)) {
            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.apache.phoenix.expression.LikeExpression

    public static Expression constantComparison(CompareOp op, Expression e, Object o) {
        return  new ComparisonExpression(op, Arrays.asList(e, LiteralExpression.newConstant(o)));
    }


    public static Expression like(Expression e, Object o) {
        return  new LikeExpression(Arrays.asList(e, LiteralExpression.newConstant(o)));
    }

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.