/*
* Licensed to CRATE Technology GmbH ("Crate") under one or more contributor
* license agreements. See the NOTICE file distributed with this work for
* additional information regarding copyright ownership. Crate licenses
* this file to you under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License. You may
* obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
* WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
* License for the specific language governing permissions and limitations
* under the License.
*
* However, if you have executed another commercial license agreement
* with Crate these terms will supersede the license and you may use the
* software solely pursuant to the terms of the relevant commercial agreement.
*/
package io.crate.operation.scalar;
import io.crate.analyze.symbol.Literal;
import org.junit.Test;
import static io.crate.testing.SymbolMatchers.isLiteral;
public class FormatFunctionTest extends AbstractScalarFunctionsTest {
@Test
@SuppressWarnings("unchecked")
public void testNormalizeSymbol() throws Exception {
assertNormalize("format('%tY', cast('2014-03-02' as timestamp))", isLiteral("2014"));
}
@Test
@SuppressWarnings("unchecked")
public void testEvaluate() throws Exception {
assertEvaluate("format('%s bla %s', name, age)",
"Arthur bla 38",
Literal.of("Arthur"),
Literal.of(38L));
assertEvaluate("format('%s bla %s', name, age)",
"Arthur bla 42",
Literal.of("Arthur"),
Literal.of(42L));
}
}