Repository: beam Updated Branches: refs/heads/DSL_SQL e12d7664a -> caf647daf
[BEAM-2565] add integration test for conditional functions Project: http://git-wip-us.apache.org/repos/asf/beam/repo Commit: http://git-wip-us.apache.org/repos/asf/beam/commit/0c857ba4 Tree: http://git-wip-us.apache.org/repos/asf/beam/tree/0c857ba4 Diff: http://git-wip-us.apache.org/repos/asf/beam/diff/0c857ba4 Branch: refs/heads/DSL_SQL Commit: 0c857ba43250df222e14d907ee161ec093016c0f Parents: e12d766 Author: James Xu <[email protected]> Authored: Mon Jul 17 17:34:05 2017 +0800 Committer: JingsongLi <[email protected]> Committed: Tue Jul 18 16:31:39 2017 +0800 ---------------------------------------------------------------------- ...mSqlConditionalFunctionsIntegrationTest.java | 60 ++++++++++++++++++++ 1 file changed, 60 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/beam/blob/0c857ba4/dsls/sql/src/test/java/org/apache/beam/dsls/sql/integrationtest/BeamSqlConditionalFunctionsIntegrationTest.java ---------------------------------------------------------------------- diff --git a/dsls/sql/src/test/java/org/apache/beam/dsls/sql/integrationtest/BeamSqlConditionalFunctionsIntegrationTest.java b/dsls/sql/src/test/java/org/apache/beam/dsls/sql/integrationtest/BeamSqlConditionalFunctionsIntegrationTest.java new file mode 100644 index 0000000..6233aeb --- /dev/null +++ b/dsls/sql/src/test/java/org/apache/beam/dsls/sql/integrationtest/BeamSqlConditionalFunctionsIntegrationTest.java @@ -0,0 +1,60 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF 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. + */ +package org.apache.beam.dsls.sql.integrationtest; + +import org.junit.Test; + +/** + * Integration test for conditional functions. + */ +public class BeamSqlConditionalFunctionsIntegrationTest + extends BeamSqlBuiltinFunctionsIntegrationTestBase { + @Test + public void testConditionalFunctions() throws Exception { + ExpressionChecker checker = new ExpressionChecker() + .addExpr( + "CASE 1 WHEN 1 THEN 'hello' ELSE 'world' END", + "hello" + ) + .addExpr( + "CASE 2 " + + "WHEN 1 THEN 'hello' " + + "WHEN 3 THEN 'bond' " + + "ELSE 'world' END", + "world" + ) + .addExpr( + "CASE " + + "WHEN 1 = 1 THEN 'hello' " + + "ELSE 'world' END", + "hello" + ) + .addExpr( + "CASE " + + "WHEN 1 > 1 THEN 'hello' " + + "ELSE 'world' END", + "world" + ) + .addExpr("NULLIF(5, 4) ", 5) + .addExpr("COALESCE(1, 5) ", 1) + .addExpr("COALESCE(NULL, 5) ", 5) + ; + + checker.buildRunAndCheck(); + } +}
