/* * Licensed 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 com.facebook.presto.sql.planner.iterative.rule; import com.facebook.presto.block.BlockEncodingManager; import com.facebook.presto.metadata.FunctionRegistry; import com.facebook.presto.sql.analyzer.FeaturesConfig; import com.facebook.presto.sql.planner.assertions.PlanMatchPattern; import com.facebook.presto.sql.planner.iterative.Rule; import com.facebook.presto.sql.planner.iterative.rule.test.RuleTester; import com.facebook.presto.sql.planner.plan.Assignments; import com.facebook.presto.type.TypeRegistry; import com.google.common.collect.ImmutableList; import com.google.common.collect.ImmutableMap; import org.testng.annotations.AfterClass; import org.testng.annotations.BeforeClass; import org.testng.annotations.Test; import static com.facebook.presto.spi.type.BigintType.BIGINT; import static com.facebook.presto.spi.type.BooleanType.BOOLEAN; import static com.facebook.presto.sql.planner.assertions.PlanMatchPattern.aggregation; import static com.facebook.presto.sql.planner.assertions.PlanMatchPattern.apply; import static com.facebook.presto.sql.planner.assertions.PlanMatchPattern.functionCall; import static com.facebook.presto.sql.planner.assertions.PlanMatchPattern.project; import static com.facebook.presto.sql.planner.assertions.PlanMatchPattern.values; import static com.facebook.presto.sql.planner.iterative.rule.test.PlanBuilder.expression; import static io.airlift.testing.Closeables.closeAllRuntimeException; public class TestTransformExistsApplyToScalarApply { private RuleTester tester; private Rule transformExistsApplyToScalarApply; @BeforeClass public void setUp() { tester = new RuleTester(); TypeRegistry typeManager = new TypeRegistry(); FunctionRegistry registry = new FunctionRegistry(typeManager, new BlockEncodingManager(typeManager), new FeaturesConfig()); transformExistsApplyToScalarApply = new TransformExistsApplyToScalarApply(registry); } @AfterClass(alwaysRun = true) public void tearDown() { closeAllRuntimeException(tester); tester = null; transformExistsApplyToScalarApply = null; } @Test public void testDoesNotFire() { tester.assertThat(transformExistsApplyToScalarApply) .on(p -> p.values(p.symbol("a", BIGINT))) .doesNotFire(); tester.assertThat(transformExistsApplyToScalarApply) .on(p -> p.apply( Assignments.identity(p.symbol("a", BIGINT), p.symbol("b", BIGINT)), ImmutableList.of(p.symbol("a", BIGINT)), p.values(p.symbol("a", BIGINT)), p.values(p.symbol("a", BIGINT))) ) .doesNotFire(); tester.assertThat(transformExistsApplyToScalarApply) .on(p -> p.apply( Assignments.identity(p.symbol("a", BIGINT)), ImmutableList.of(p.symbol("a", BIGINT)), p.values(p.symbol("a", BIGINT)), p.values(p.symbol("a", BIGINT))) ) .doesNotFire(); tester.assertThat(transformExistsApplyToScalarApply) .on(p -> p.apply( Assignments.of(p.symbol("b", BOOLEAN), expression("\"a\"")), ImmutableList.of(), p.values(), p.values(p.symbol("a", BIGINT))) ) .doesNotFire(); } @Test public void testRewrite() throws Exception { tester.assertThat(transformExistsApplyToScalarApply) .on(p -> p.apply( Assignments.of(p.symbol("b", BOOLEAN), expression("EXISTS(SELECT \"a\")")), ImmutableList.of(), p.values(), p.values(p.symbol("a", BIGINT))) ) .matches(apply( ImmutableList.of(), ImmutableMap.of("b", PlanMatchPattern.expression("\"b\"")), values(ImmutableMap.of()), project( ImmutableMap.of("b", PlanMatchPattern.expression("(\"count_expr\" > CAST(0 AS bigint))")), aggregation(ImmutableMap.of("count_expr", functionCall("count", ImmutableList.of())), values(ImmutableMap.of("a", 0)))))); } }