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 ClassesModifier and TypeInterfaceDescriptionstatic final recordA combined trailing limit clause whose first operand is the offset and second operand is the row count, for exampleselect ... limit 5, 10.static final recordA trailing fetch clause whose count is increased by the offset.static final recordA select-clausefirstform without native offset syntax.static final recordA select-clausefirst ... skip ...form, for exampleselect first 10 skip 5 ....static final recordSeparate trailinglimitandoffsetclauses, for exampleselect ... limit 10 offset 5.static final recordNo SQL AST pagination syntax.static final recordANSI offset/fetch syntax rendered at the end of the query part.static final recordA trailing inclusive row range, for exampleselect ... rows 5 to 14for a ten-row range beginning at the database-specific first-row value.static final recordA select-clauseskip ... first ...form, for exampleselect skip 5 first 10 ....static final recordAtopclause rendered immediately afterselect.static final recordA select-clausetop ... start at ...form, for exampleselect top 10 start at 5 ....static final recordEmulate pagination by wrapping the query part and filtering a derived row number.