/* * Licensed to 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.string; import io.crate.analyze.symbol.Literal; import io.crate.operation.scalar.AbstractScalarFunctionsTest; import io.crate.types.DataTypes; import org.junit.Test; import static io.crate.testing.SymbolMatchers.isLiteral; public class StringCaseFunctionTest extends AbstractScalarFunctionsTest { @Test public void testNormalizeLowerFunc() throws Exception { assertNormalize("lower('ABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜΑΒΓ')", isLiteral("abcdefghijklmnopqrstuvwxyzäöüαβγ")); } @Test public void testEvaluateLowerFunc() throws Exception { assertEvaluate("lower(name)", "abcdefghijklmnopqrstuvwxyzäöüαβγ", Literal.of(DataTypes.STRING, "ABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜΑΒΓ") ); } @Test public void testEvaluateLowerFuncWhenColIsNull() throws Exception { assertEvaluate("lower(name)", null, Literal.of(DataTypes.STRING, null)); } @Test public void testNormalizeUpperFunc() throws Exception { assertNormalize("upper('abcdefghijklmnopqrstuvwxyzäöüαβγ')", isLiteral("ABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜΑΒΓ")); } @Test public void testEvaluateUpperFunc() throws Exception { assertEvaluate("upper(name)", "ABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜΑΒΓ", Literal.of(DataTypes.STRING, "abcdefghijklmnopqrstuvwxyzäöüαβγ") ); } @Test public void testEvaluateUpperFuncWhenColIsNull() throws Exception { assertEvaluate("upper(name)", null, Literal.of(DataTypes.STRING, null)); } }