Interface PaginationRenderingPlan

All Known Implementing Classes:

PaginationRenderingPlan.CombinedLimit, PaginationRenderingPlan.FetchPlusOffset, PaginationRenderingPlan.First, PaginationRenderingPlan.FirstSkip, PaginationRenderingPlan.LimitOffset, PaginationRenderingPlan.None, PaginationRenderingPlan.OffsetFetch, PaginationRenderingPlan.RowsTo, PaginationRenderingPlan.SkipFirst, PaginationRenderingPlan.Top, PaginationRenderingPlan.TopStartAt, PaginationRenderingPlan.Window

public sealed interface PaginationRenderingPlan
permits PaginationRenderingPlan.OffsetFetch, PaginationRenderingPlan.LimitOffset, PaginationRenderingPlan.CombinedLimit, PaginationRenderingPlan.Top, PaginationRenderingPlan.TopStartAt, PaginationRenderingPlan.FirstSkip, PaginationRenderingPlan.SkipFirst, PaginationRenderingPlan.First, PaginationRenderingPlan.RowsTo, PaginationRenderingPlan.FetchPlusOffset, PaginationRenderingPlan.Window, PaginationRenderingPlan.None

Immutable semantic plan for SQL AST pagination rendering.

The plan describes syntax and placement. It does not own or receive mutable translator state. Providers select a plan; AbstractSqlAstTranslator performs the actual traversal and rendering.

Since:

8.0

Nested Class Summary

Nested Classes

Modifier and Type	Interface	Description
static final record	PaginationRenderingPlan.CombinedLimit	A combined trailing limit clause whose first operand is the offset and second operand is the row count, for example select ... limit 5, 10.
static final record	PaginationRenderingPlan.FetchPlusOffset	A trailing fetch clause whose count is increased by the offset.
static final record	PaginationRenderingPlan.First	A select-clause first form without native offset syntax.
static final record	PaginationRenderingPlan.FirstSkip	A select-clause first ... skip ... form, for example select first 10 skip 5 ....
static final record	PaginationRenderingPlan.LimitOffset	Separate trailing limit and offset clauses, for example select ... limit 10 offset 5.
static final record	PaginationRenderingPlan.None	No SQL AST pagination syntax.
static final record	PaginationRenderingPlan.OffsetFetch	ANSI offset/fetch syntax rendered at the end of the query part.
static final record	PaginationRenderingPlan.RowsTo	A trailing inclusive row range, for example select ... rows 5 to 14 for a ten-row range beginning at the database-specific first-row value.
static final record	PaginationRenderingPlan.SkipFirst	A select-clause skip ... first ... form, for example select skip 5 first 10 ....
static final record	PaginationRenderingPlan.Top	A top clause rendered immediately after select.
static final record	PaginationRenderingPlan.TopStartAt	A select-clause top ... start at ... form, for example select top 10 start at 5 ....
static final record	PaginationRenderingPlan.Window	Emulate pagination by wrapping the query part and filtering a derived row number.