Moderne licensed

Find constant predicates that are always true or always false

Recipe IDorg.openrewrite.sql.antipattern.FindConstantPredicate

Artifactorg.openrewrite.recipe:rewrite-sql

A comparison whose operands are both constant, such as 1 = 1 or 1 = 0, evaluates the same for every row regardless of the data. Combined with OR an always-true constant makes the whole condition always true, so every row matches and the other filters are ignored; an always-false constant used as a filter can never be satisfied, so the query returns nothing. An always-true constant on its own or joined with AND, a common query-builder idiom, is not flagged.

Single recipeProprietary

Usage

This recipe has no required configuration options. You’ll need the Moderne CLI configured before running the command below.

mod run . --recipe org.openrewrite.sql.antipattern.FindConstantPredicate

If the recipe isn’t available locally, install it with:

mod config recipes jar install org.openrewrite.recipe:rewrite-sql:2.14.1

Data tables

Structured output this recipe can produce.

SQL anti-patternsSQL statements matching performance anti-pattern rules.org.openrewrite.sql.table.SqlAntiPatterns
Source files that had resultsSource files that were modified by the recipe run.org.openrewrite.table.SourcesFileResults
Source files that had search resultsSearch results that were found during the recipe run.org.openrewrite.table.SearchResults
Source files that errored on a recipeThe details of all errors produced by a recipe run.org.openrewrite.table.SourcesFileErrors
Recipe performanceStatistics used in analyzing the performance of recipes.org.openrewrite.table.RecipeRunStats