← All recipes
Moderne licensed

Find row limiters without an ORDER BY

Recipe IDorg.openrewrite.sql.antipattern.FindLimitWithoutOrderBy
Artifactorg.openrewrite.recipe:rewrite-sql

A LIMIT, OFFSET, FETCH, or TOP clause selects a subset of rows, but without an ORDER BY the engine is free to return any rows in any order, so the result is arbitrary and can differ from one execution to the next. Queries that can only ever produce a single row, such as a bare aggregate with no GROUP BY, and limiters inside an EXISTS subquery, where order does not matter, are 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.FindLimitWithoutOrderBy

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