Examples of com.salesforce.phoenix.expression.function.SubstrFunction

Package com.salesforce.phoenix.expression.function

Examples of com.salesforce.phoenix.expression.function.SubstrFunction

com.salesforce.phoenix.expression.function.SubstrFunction
Implementation of the SUBSTR(,[,]) built-in function where is the offset from the start of . A positive offset is treated as 1-based, a zero offset is treated as 0-based, and a negative offset starts from the end of the string working backwards. The optional argument is the number of characters to return. In the absence of the argument, the rest of the string starting from is returned. If is less than 1, null is returned. @author jtaylor @since 0.1

        Filter filter = scan.getFilter();


        assertEquals(
            new RowKeyComparisonFilter(
                constantComparison(CompareOp.EQUAL,
                    new SubstrFunction(
                        Arrays.<Expression>asList(
                            new RowKeyColumnExpression(BaseConnectionlessQueryTest.ENTITY_ID,new RowKeyValueAccessor(BaseConnectionlessQueryTest.ATABLE.getPKColumns(),1)),
                            LiteralExpression.newConstant(1),
                            LiteralExpression.newConstant(3))
                        ),

View Full Code Here

        assertEquals(
            singleKVFilter( // single b/c one column is a row key column
            or(
                constantComparison(
                    CompareOp.EQUAL,
                    new SubstrFunction(Arrays.<Expression> asList(
                        new RowKeyColumnExpression(
                            BaseConnectionlessQueryTest.ENTITY_ID,
                            new RowKeyValueAccessor(BaseConnectionlessQueryTest.ATABLE.getPKColumns(), 1)),
                        LiteralExpression.newConstant(1),
                        LiteralExpression.newConstant(3))),

View Full Code Here

public class DescColumnSortOrderExpressionTest {
    
    @Test
    public void substr() throws Exception {
        List<Expression> args = Lists.newArrayList(getInvertedLiteral("blah", PDataType.CHAR), getLiteral(3), getLiteral(2));
        evaluateAndAssertResult(new SubstrFunction(args), "ah");
    }

View Full Code Here

    @Test
    public void substrLtrim() throws Exception {
        List<Expression> ltrimArgs = Lists.newArrayList(getInvertedLiteral("   blah", PDataType.CHAR));
        Expression ltrim = new LTrimFunction(ltrimArgs);
        List<Expression> substrArgs = Lists.newArrayList(ltrim, getLiteral(3), getLiteral(2));
        evaluateAndAssertResult(new SubstrFunction(substrArgs), "ah");
    }

View Full Code Here

TOP

Related Classes of com.salesforce.phoenix.expression.function.SubstrFunction

com.salesforce.phoenix.compile.WhereClauseCompileTest

com.salesforce.phoenix.expression.DescColumnSortOrderExpressionTest

com.salesforce.phoenix.expression.Expression

com.salesforce.phoenix.expression.LiteralExpression

com.salesforce.phoenix.schema.ColumnModifier

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.