public enum RowLimitKind extends Enum<RowLimitKind>
StatementGraph. Slices 70 and 71 cover the four single-SELECT
row-limit shapes that do not change column lineage:
LIMIT — PostgreSQL / MySQL / SQLite / BigQuery /
Snowflake / Redshift LIMIT N (count on
TLimitClause.getRow_count()) and the inline-offset
variants LIMIT N OFFSET M and MySQL/Hive/Informix
LIMIT M, N. When offset is present it lands on
RowLimit.getOffset().FETCH_FIRST — ANSI / Oracle / DB2 / SQL Server
FETCH FIRST N ROWS ONLY (and the FETCH NEXT N
ROWS ONLY synonym), PostgreSQL FETCH FIRST routed
through TLimitClause.getSelectFetchFirstValue(), and
Informix FIRST n / SKIP m FIRST n (Informix
routes FIRST through the same PG slot). When offset is present
(PG OFFSET m FETCH FIRST n, Informix SKIP m
FIRST n) it lands on RowLimit.getOffset().TOP — SQL Server SELECT TOP N. PERCENT and
WITH TIES surfaces are rejected separately for now
(ROW_LIMIT_TOP_PERCENT_NOT_SUPPORTED,
ROW_LIMIT_TOP_WITH_TIES_NOT_SUPPORTED).OFFSET_FETCH — Oracle / SQL Server
OFFSET m ROWS [FETCH NEXT n ROWS ONLY] routed through
the dedicated TOffsetClause + TFetchFirstClause
AST pair, and PG's OFFSET m offset-only shape routed
through TLimitClause.getOffset() when
row_count is null. RowLimit.getCount() may be
null for offset-only forms.Set-op outer row-limit (e.g. UNION ALL ... LIMIT 5) is
still rejected by rejectSetOpRowLimit with
SET_OP_ROW_LIMIT_NOT_SUPPORTED; slice 72 lifts it. Branch-level
row-limit inside a set-op (e.g.
(SELECT ... LIMIT 10) UNION ALL (SELECT ... LIMIT 5)) admits
per branch — each branch's StatementGraph carries its own
RowLimit.
| Enum Constant and Description |
|---|
FETCH_FIRST |
LIMIT |
OFFSET_FETCH |
TOP |
| Modifier and Type | Method and Description |
|---|---|
static RowLimitKind |
valueOf(String name)
Returns the enum constant of this type with the specified name.
|
static RowLimitKind[] |
values()
Returns an array containing the constants of this enum type, in
the order they are declared.
|
public static final RowLimitKind LIMIT
public static final RowLimitKind FETCH_FIRST
public static final RowLimitKind TOP
public static final RowLimitKind OFFSET_FETCH
public static RowLimitKind[] values()
for (RowLimitKind c : RowLimitKind.values()) System.out.println(c);
public static RowLimitKind valueOf(String name)
name - the name of the enum constant to be returned.IllegalArgumentException - if this enum type has no constant with the specified nameNullPointerException - if the argument is null