Top Fields Constructors Methods
org.jooq.impl

pack-priv final Class Limit

extends AbstractQueryPart
implements UTransient
Class Inheritance
All Implemented Interfaces
org.jooq.impl.QOM.UTransient, org.jooq.impl.QOM.UEmpty, org.jooq.QueryPart, java.io.Serializable
Static Imports
java.lang.Boolean.TRUE, org.jooq.RenderContext.CastMode.NEVER, .SQLDialect.FIREBIRD, .SQLDialect.H2, .SQLDialect.MARIADB, .SQLDialect.POSTGRES, org.jooq.conf.ParamType.INLINED, org.jooq.impl.DSL.one, .DSL.val, .DSL.zero, .Internal.iadd, .Keywords.K_FETCH_FIRST, .Keywords.K_FETCH_NEXT, .Keywords.K_FIRST, .Keywords.K_LIMIT, .Keywords.K_OFFSET, .Keywords.K_PERCENT, .Keywords.K_ROWS, .Keywords.K_ROWS_ONLY, .Keywords.K_ROWS_WITH_TIES, .Keywords.K_SKIP, .Keywords.K_START_AT, .Keywords.K_TO, .Keywords.K_TOP, .Keywords.K_WITH_TIES, .SQLDataType.BIGINT, .Tools.isScalarSubquery

Author
Lukas Eder

Field Summary

Modifier and TypeField and Description
pack-priv Field<? extends Number>
limit

Deprecated as a consequence of Field being deprecated.
private Field<? extends Number>
limitOrMax

Deprecated as a consequence of Field being deprecated.
private static final Lazy<Param<Integer>>
pack-priv Field<? extends Number>
offset

Deprecated as a consequence of Field being deprecated.
private Field<? extends Number>
offsetOrZero

Deprecated as a consequence of Field being deprecated.
private Field<? extends Number>
offsetPlusOne

Deprecated as a consequence of Field being deprecated.
private static final Lazy<Param<Integer>>
pack-priv boolean
pack-priv boolean
private static final Lazy<Param<Integer>>

Constructor Summary

AccessConstructor and Description
pack-priv

Method Summary

Modifier and TypeMethod and Description
public final void
accept(Context<?> ctx)

Implements org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.
private final void
private void
private final void
pack-priv final void
pack-priv final Limit
from(Limit other)

pack-priv final Long
pack-priv final Field<?>
getLowerRownum()

Deprecated as a consequence of Field being deprecated.
The lower bound, such that ROW_NUMBER() > getLowerRownum()
pack-priv final Field<?>
getUpperRownum()

Deprecated as a consequence of Field being deprecated.
The upper bound, such that ROW_NUMBER() <= getUpperRownum()
pack-priv final boolean
isApplicable()

Whether this LIMIT clause is applicable.

pack-priv final boolean
isExpression()

Whether the LIMIT or OFFSET clause is an expression as opposed to a bind variable.

pack-priv final boolean
isSubquery()

Whether the LIMIT or OFFSET clause is a subquery.

pack-priv final boolean
limitOne()

Whether this limit has a limit of one

pack-priv final boolean
limitZero()

Whether this limit has a limit of zero

pack-priv final boolean
offsetZero()

Whether this limit has an offset of zero

pack-priv final boolean
pack-priv final void
pack-priv final void
setLimit(Field<? extends Number> l)

Deprecated as a consequence of Field being deprecated.
pack-priv final void
setOffset(Number offset)

pack-priv final void
setOffset(Field<? extends Number> offset)

Deprecated as a consequence of Field being deprecated.
pack-priv final void
setPercent(boolean percent)

pack-priv final void
setWithTies(boolean withTies)

pack-priv final boolean
Inherited from org.jooq.impl.AbstractQueryPart:
clausesconfigurationcreatecreatecreatedeclaresCTEdeclaresFieldsdeclaresTablesdeclaresWindowsequalsgeneratesCasthashCoderendersContenttoStringtranslate

Field Detail

limitback to summary
pack-priv Field<? extends Number> limit

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

limitOrMaxback to summary
private Field<? extends Number> limitOrMax

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

MAXback to summary
private static final Lazy<Param<Integer>> MAX
offsetback to summary
pack-priv Field<? extends Number> offset

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

offsetOrZeroback to summary
private Field<? extends Number> offsetOrZero

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

offsetPlusOneback to summary
private Field<? extends Number> offsetPlusOne

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

ONEback to summary
private static final Lazy<Param<Integer>> ONE
percentback to summary
pack-priv boolean percent
withTiesback to summary
pack-priv boolean withTies
ZEROback to summary
private static final Lazy<Param<Integer>> ZERO

Constructor Detail

Limitback to summary
pack-priv Limit()

Method Detail

acceptback to summary
public final void accept(Context<?> ctx)

Implements org.jooq.QueryPartInternal.accept.

Doc from org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.

Annotations
@Override
acceptDefaultback to summary
private final void acceptDefault(Context<?> ctx, RenderContext.CastMode castMode)
acceptDefaultLimitMandatoryback to summary
private void acceptDefaultLimitMandatory(Context<?> ctx, RenderContext.CastMode castMode)
acceptStandardback to summary
private final void acceptStandard(Context<?> ctx, RenderContext.CastMode castMode)
clearback to summary
pack-priv final void clear()
fromback to summary
pack-priv final Limit from(Limit other)
getLimitback to summary
pack-priv final Long getLimit()
getLowerRownumback to summary
pack-priv final Field<?> getLowerRownum()

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

The lower bound, such that ROW_NUMBER() > getLowerRownum()

getUpperRownumback to summary
pack-priv final Field<?> getUpperRownum()

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

The upper bound, such that ROW_NUMBER() <= getUpperRownum()

isApplicableback to summary
pack-priv final boolean isApplicable()

Whether this LIMIT clause is applicable. If false, then no LIMIT clause should be rendered.

isExpressionback to summary
pack-priv final boolean isExpression()

Whether the LIMIT or OFFSET clause is an expression as opposed to a bind variable.

isSubqueryback to summary
pack-priv final boolean isSubquery()

Whether the LIMIT or OFFSET clause is a subquery.

limitOneback to summary
pack-priv final boolean limitOne()

Whether this limit has a limit of one

limitZeroback to summary
pack-priv final boolean limitZero()

Whether this limit has a limit of zero

offsetZeroback to summary
pack-priv final boolean offsetZero()

Whether this limit has an offset of zero

percentback to summary
pack-priv final boolean percent()
setLimitback to summary
pack-priv final void setLimit(Number l)
setLimitback to summary
pack-priv final void setLimit(Field<? extends Number> l)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

setOffsetback to summary
pack-priv final void setOffset(Number offset)
setOffsetback to summary
pack-priv final void setOffset(Field<? extends Number> offset)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

setPercentback to summary
pack-priv final void setPercent(boolean percent)
setWithTiesback to summary
pack-priv final void setWithTies(boolean withTies)
withTiesback to summary
pack-priv final boolean withTies()