jOOQ 3.18.7 · org.jooq.impl.SelectQueryImpl

Modifier and Type	Class and Description
private static enum	SelectQueryImpl.CopyClause
private static record	SelectQueryImpl.SelectFieldIndexes

Modifier and Type	Field and Description
private static final Clause[]	CLAUSES Deprecated as a consequence of `Clause` being deprecated.
private final ConditionProviderImpl	condition Deprecated as a consequence of `ConditionProviderImpl` being deprecated.
private boolean	distinct
private final QueryPartList<SelectFieldOrAsterisk>	distinctOn
private static final Set<SQLDialect>	EMULATE_DISTINCT_ON
pack-priv static final Set<SQLDialect>	EMULATE_SELECT_INTO_AS_CTAS
private ForLock	forLock Deprecated as a consequence of `ForLock` being deprecated.
private final TableList	from
private final GroupFieldList	groupBy
private boolean	groupByDistinct
private final ConditionProviderImpl	having Deprecated as a consequence of `ConditionProviderImpl` being deprecated.
private String	hint
private Table<?>	intoTable
private final Limit	limit
private final Map<QueryPart, QueryPart>	localQueryPartMapping
private static final JooqLogger	log Hides org.jooq.impl.AbstractResultQuery.log.
private static final Set<SQLDialect>	NO_IMPLICIT_GROUP_BY_ON_HAVING
private static final Set<SQLDialect>	NO_SUPPORT_CTE_IN_UNION
pack-priv static final Set<SQLDialect>	NO_SUPPORT_FOR_UPDATE_OF_FIELDS
pack-priv static final Set<SQLDialect>	NO_SUPPORT_UNION_ORDER_BY_ALIAS
private static final Set<SQLDialect>	NO_SUPPORT_UNION_PARENTHESES
pack-priv static final Set<SQLDialect>	NO_SUPPORT_WINDOW_CLAUSE
pack-priv static final Set<SQLDialect>	NO_SUPPORT_WITH_READ_ONLY
private String	option
private static final Set<SQLDialect>	OPTIONAL_FROM_CLAUSE
private final SortFieldList	orderBy
private final ConditionProviderImpl	qualify Deprecated as a consequence of `ConditionProviderImpl` being deprecated.
private static final Set<SQLDialect>	REQUIRES_DERIVED_TABLE_DML
private final QueryPartList<Field<?>>	seek
private boolean	seekBefore
private final SelectFieldList<SelectFieldOrAsterisk>	select
private static final Set<SQLDialect>	SUPPORT_FULL_WITH_TIES
private static final Set<SQLDialect>	SUPPORT_SELECT_INTO_TABLE
private final List<QueryPartList<Select<?>>>	union
private static final Set<SQLDialect>	UNION_PARENTHESIS
private final Limit	unionLimit
private final List<CombineOperator>	unionOp
private final SortFieldList	unionOrderBy
private final QueryPartList<Field<?>>	unionSeek
private boolean	unionSeekBefore
private WindowList	window
pack-priv final WithImpl	with
private boolean	withCheckOption
private boolean	withReadOnly

Access	Constructor and Description
pack-priv	SelectQueryImpl(Configuration configuration, WithImpl with)
pack-priv	SelectQueryImpl(Configuration configuration, WithImpl with, boolean distinct)
pack-priv	SelectQueryImpl(Configuration configuration, WithImpl with, TableLike<? extends R> from)
pack-priv	SelectQueryImpl(Configuration configuration, WithImpl with, TableLike<? extends R> from, boolean distinct)

Method Summary

Modifier and Type	Method and Description
public final boolean	$distinct() Implements org.jooq.Select.$distinct. Experimental query object model accessor method, see also `QOM`.
public final Select<R>	$distinct(boolean newDistinct) Implements org.jooq.Select.$distinct. Experimental query object model accessor method, see also `QOM`.
public final QOM.UnmodifiableList<SelectFieldOrAsterisk>	$distinctOn() Implements org.jooq.Select.$distinctOn. Experimental query object model accessor method, see also `QOM`.
public final Select<R>	$distinctOn(Collection<? extends SelectFieldOrAsterisk> newDistinctOn) Implements org.jooq.Select.$distinctOn. Experimental query object model accessor method, see also `QOM`.
public final QOM.UnmodifiableList<Table<?>>	$from() Implements org.jooq.Select.$from. Experimental query object model accessor method, see also `QOM`.
public final SelectQueryImpl<R>	$from(Collection<? extends Table<?>> newFrom) Implements org.jooq.Select.$from. Deprecated as a consequence of `SelectQueryImpl` being deprecated. Experimental query object model accessor method, see also `QOM`.
public final QOM.UnmodifiableList<GroupField>	$groupBy() Implements org.jooq.Select.$groupBy. Experimental query object model accessor method, see also `QOM`.
public final Select<R>	$groupBy(Collection<? extends GroupField> newGroupBy) Implements org.jooq.Select.$groupBy. Experimental query object model accessor method, see also `QOM`.
public final boolean	$groupByDistinct() Implements org.jooq.Select.$groupByDistinct. Experimental query object model accessor method, see also `QOM`.
public final Select<R>	$groupByDistinct(boolean newGroupByDistinct) Implements org.jooq.Select.$groupByDistinct. Experimental query object model accessor method, see also `QOM`.
public final Condition	$having() Implements org.jooq.Select.$having. Deprecated as a consequence of `Condition` being deprecated. Experimental query object model accessor method, see also `QOM`.
public final Select<R>	$having(Condition newHaving) Implements org.jooq.Select.$having. Deprecated as a consequence of `Condition` being deprecated. Experimental query object model accessor method, see also `QOM`.
public final Field<? extends Number>	$limit() Implements org.jooq.Select.$limit. Deprecated as a consequence of `Field` being deprecated. Experimental query object model accessor method, see also `QOM`.
public final Select<R>	$limit(Field<? extends Number> newLimit) Implements org.jooq.Select.$limit. Deprecated as a consequence of `Field` being deprecated. Experimental query object model accessor method, see also `QOM`.
public final boolean	$limitPercent() Implements org.jooq.Select.$limitPercent. Experimental query object model accessor method, see also `QOM`.
public final Select<R>	$limitPercent(boolean newLimitPercent) Implements org.jooq.Select.$limitPercent. Experimental query object model accessor method, see also `QOM`.
public final boolean	$limitWithTies() Implements org.jooq.Select.$limitWithTies. Experimental query object model accessor method, see also `QOM`.
public final Select<R>	$limitWithTies(boolean newLimitWithTies) Implements org.jooq.Select.$limitWithTies. Experimental query object model accessor method, see also `QOM`.
public final Field<? extends Number>	$offset() Implements org.jooq.Select.$offset. Deprecated as a consequence of `Field` being deprecated. Experimental query object model accessor method, see also `QOM`.
public final Select<R>	$offset(Field<? extends Number> newOffset) Implements org.jooq.Select.$offset. Deprecated as a consequence of `Field` being deprecated. Experimental query object model accessor method, see also `QOM`.
public final QOM.UnmodifiableList<SortField<?>>	$orderBy() Implements org.jooq.Select.$orderBy. Experimental query object model accessor method, see also `QOM`.
public final Select<R>	$orderBy(Collection<? extends SortField<?>> newOrderBy) Implements org.jooq.Select.$orderBy. Experimental query object model accessor method, see also `QOM`.
public final Condition	$qualify() Implements org.jooq.Select.$qualify. Deprecated as a consequence of `Condition` being deprecated. Experimental query object model accessor method, see also `QOM`.
public final Select<R>	$qualify(Condition newQualify) Implements org.jooq.Select.$qualify. Deprecated as a consequence of `Condition` being deprecated. Experimental query object model accessor method, see also `QOM`.
public final QOM.UnmodifiableList<SelectFieldOrAsterisk>	$select() Implements org.jooq.Select.$select. Experimental query object model accessor method, see also `QOM`.
public final SelectQueryImpl<?>	$select(Collection<? extends SelectFieldOrAsterisk> newSelect) Implements org.jooq.Select.$select. Deprecated as a consequence of `SelectQueryImpl` being deprecated. Experimental query object model accessor method, see also `QOM`.
public final Condition	$where() Implements org.jooq.Select.$where. Deprecated as a consequence of `Condition` being deprecated. Experimental query object model accessor method, see also `QOM`.
public final Select<R>	$where(Condition newWhere) Implements org.jooq.Select.$where. Deprecated as a consequence of `Condition` being deprecated. Experimental query object model accessor method, see also `QOM`.
public final QOM.UnmodifiableList<? extends WindowDefinition>	$window() Implements org.jooq.Select.$window. Experimental query object model accessor method, see also `QOM`.
public final Select<R>	$window(Collection<? extends WindowDefinition> newWindow) Implements org.jooq.Select.$window. Experimental query object model accessor method, see also `QOM`.
public final WithImpl	$with() Implements org.jooq.Select.$with. Experimental query object model accessor method, see also `QOM`.
public final SelectQueryImpl<?>	$with(QOM.With newWith) Implements org.jooq.Select.$with. Deprecated as a consequence of `SelectQueryImpl` being deprecated. Experimental query object model accessor method, see also `QOM`.
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.
pack-priv final void	accept0(Context<?> context)
public final void	addConditions(Condition The condition conditions) Implements org.jooq.SelectQuery.addConditions. Deprecated as a consequence of `Condition` being deprecated. Adds a new condition to the query, connecting them to existing conditions with `Operator#AND`.
public final void	addConditions(Condition... The condition conditions) Implements org.jooq.SelectQuery.addConditions. Deprecated as a consequence of `Condition` being deprecated. Adds new conditions to the query, connecting them to existing conditions with `Operator#AND`.
public final void	addConditions(Collection<? extends Condition> The condition conditions) Implements org.jooq.SelectQuery.addConditions. Adds new conditions to the query, connecting them to existing conditions with `Operator#AND`.
public final void	addConditions(Operator operator, Condition The condition conditions) Implements org.jooq.SelectQuery.addConditions. Deprecated as a consequence of `Condition` being deprecated. Adds a new condition to the query, connecting them to existing conditions with the provided operator.
public final void	addConditions(Operator operator, Condition... The condition conditions) Implements org.jooq.SelectQuery.addConditions. Deprecated as a consequence of `Condition` being deprecated. Adds new conditions to the query, connecting them to existing conditions with the provided operator.
public final void	addConditions(Operator operator, Collection<? extends Condition> The condition conditions) Implements org.jooq.SelectQuery.addConditions. Adds new conditions to the query, connecting them to existing conditions with the provided operator.
public final void	addDistinctOn(SelectFieldOrAsterisk... fields) Implements org.jooq.SelectQuery.addDistinctOn. Add a PostgreSQL-specific `DISTINCT ON (fields…)` clause.
public final void	addDistinctOn(Collection<? extends SelectFieldOrAsterisk> fields) Implements org.jooq.SelectQuery.addDistinctOn. Add a PostgreSQL-specific `DISTINCT ON (fields…)` clause.
public final void	addFrom(Collection<? extends TableLike<?>> The added tables f) Implements org.jooq.SelectQuery.addFrom. Add tables to the table product.
public final void	addFrom(TableLike<?> The added tables f) Implements org.jooq.SelectQuery.addFrom. Add tables to the table product.
public final void	addFrom(TableLike<?>... The added tables f) Implements org.jooq.SelectQuery.addFrom. Add tables to the table product.
public final void	addGroupBy(Collection<? extends GroupField> The grouping fields fields) Implements org.jooq.SelectQuery.addGroupBy. Adds grouping fields.
public final void	addGroupBy(GroupField... The grouping fields fields) Implements org.jooq.SelectQuery.addGroupBy. Adds grouping fields.
public final void	addHaving(Condition The condition conditions) Implements org.jooq.SelectQuery.addHaving. Deprecated as a consequence of `Condition` being deprecated. Adds a new condition to the having clause of the query, connecting it with each other with `Operator#AND`.
public final void	addHaving(Condition... The condition conditions) Implements org.jooq.SelectQuery.addHaving. Deprecated as a consequence of `Condition` being deprecated. Adds new conditions to the having clause of the query, connecting them with each other with `Operator#AND`.
public final void	addHaving(Collection<? extends Condition> The condition conditions) Implements org.jooq.SelectQuery.addHaving. Adds new conditions to the having clause of the query, connecting them with each other with `Operator#AND`.
public final void	addHaving(Operator The operator to use to add the conditions to the existing conditions operator, Condition The condition conditions) Implements org.jooq.SelectQuery.addHaving. Deprecated as a consequence of `Condition` being deprecated. Adds a new condition to the having clause of query, connecting it with each other with `operator`.
public final void	addHaving(Operator The operator to use to add the conditions to the existing conditions operator, Condition... The condition conditions) Implements org.jooq.SelectQuery.addHaving. Deprecated as a consequence of `Condition` being deprecated. Adds new conditions to the having clause of query, connecting them with each other with `operator`.
public final void	addHaving(Operator The operator to use to add the conditions to the existing conditions operator, Collection<? extends Condition> The condition conditions) Implements org.jooq.SelectQuery.addHaving. Adds new conditions to the having clause of query, connecting them with each other with `operator`.
public final void	addHint(String h) Implements org.jooq.SelectQuery.addHint. Add an Oracle-style hint to the select clause.
public final void	addJoin(TableLike<?> The joined table table, Condition The joining condition conditions) Implements org.jooq.SelectQuery.addJoin. Deprecated as a consequence of `Condition` being deprecated. Joins the existing table product to a new table using a condition, connecting them with each other with `Operator#AND`.
public final void	addJoin(TableLike<?> The joined table table, Condition... The joining conditions conditions) Implements org.jooq.SelectQuery.addJoin. Deprecated as a consequence of `Condition` being deprecated. Joins the existing table product to a new table using a condition, connecting them with each other with `Operator#AND`.
public final void	addJoin(TableLike<?> The joined table table, JoinType The type of join type, Condition The joining condition conditions) Implements org.jooq.SelectQuery.addJoin. Deprecated as a consequence of `Condition` being deprecated. Joins the existing table product to a new table using a condition, connecting them with each other with `Operator#AND`.
public final void	addJoin(TableLike<?> The joined table table, JoinType The type of join type, Condition... The joining conditions conditions) Implements org.jooq.SelectQuery.addJoin. Deprecated as a consequence of `Condition` being deprecated. Joins the existing table product to a new table using a condition, connecting them with each other with `Operator#AND`.
private final void	addJoin0(TableLike<?> table, JoinType type, Object conditions, Field<?>[] partitionBy) Deprecated as a consequence of `Field` being deprecated.
public final void	addJoinOnKey(TableLike<?> The joined table table, JoinType The type of join type) Implements org.jooq.SelectQuery.addJoinOnKey. Joins the existing table product to a new table using a foreign key.
public final void	addJoinOnKey(TableLike<?> The joined table table, JoinType The type of join type, TableField<?, ?>... The foreign key fields keyFields) Implements org.jooq.SelectQuery.addJoinOnKey. Deprecated as a consequence of `TableField` being deprecated. Joins the existing table product to a new table using a foreign key.
public final void	addJoinOnKey(TableLike<?> The joined table table, JoinType The type of join type, ForeignKey<?, ?> The foreign key key) Implements org.jooq.SelectQuery.addJoinOnKey. Joins the existing table product to a new table using a foreign key.
public final void	addJoinUsing(TableLike<?> The joined table table, Collection<? extends Field<?>> The fields for the `USING` clause fields) Implements org.jooq.SelectQuery.addJoinUsing. Joins the existing table product to a new table with a `USING` clause.
public final void	addJoinUsing(TableLike<?> The joined table table, JoinType The type of join type, Collection<? extends Field<?>> The fields for the `USING` clause fields) Implements org.jooq.SelectQuery.addJoinUsing. Joins the existing table product to a new table with a `USING` clause.
public final void	addLimit(Number The number of rows to return l) Implements org.jooq.SelectQuery.addLimit. Limit the results of this select.
public final void	addLimit(Field<? extends Number> The number of rows to return l) Implements org.jooq.SelectQuery.addLimit. Deprecated as a consequence of `Field` being deprecated. Limit the results of this select.
public final void	addLimit(Number The lowest offset starting at 0 offset, Number The number of rows to return l) Implements org.jooq.SelectQuery.addLimit. Limit the results of this select.
public final void	addLimit(Number The lowest offset starting at 0 offset, Field<? extends Number> The number of rows to return l) Implements org.jooq.SelectQuery.addLimit. Deprecated as a consequence of `Field` being deprecated. Limit the results of this select.
public final void	addLimit(Field<? extends Number> The lowest offset starting at 0 offset, Number The number of rows to return l) Implements org.jooq.SelectQuery.addLimit. Deprecated as a consequence of `Field` being deprecated. Limit the results of this select.
public final void	addLimit(Field<? extends Number> The lowest offset starting at 0 offset, Field<? extends Number> The number of rows to return l) Implements org.jooq.SelectQuery.addLimit. Deprecated as a consequence of `Field` being deprecated. Limit the results of this select.
public final void	addOffset(Number offset) Implements org.jooq.SelectQuery.addOffset. Add a 0-based `OFFSET` clause to the query.
public final void	addOffset(Field<? extends Number> offset) Implements org.jooq.SelectQuery.addOffset. Deprecated as a consequence of `Field` being deprecated. Add a 0-based `OFFSET` clause to the query.
public final void	addOption(String o) Implements org.jooq.SelectQuery.addOption. Add a SQL Server-style query hint to the select clause.
public final void	addOrderBy(Collection<? extends OrderField<?>> The ordering fields fields) Implements org.jooq.SelectQuery.addOrderBy. Adds ordering fields.
public final void	addOrderBy(OrderField<?>... The ordering fields fields) Implements org.jooq.SelectQuery.addOrderBy. Adds ordering fields.
public final void	addOrderBy(int... The ordering fields fieldIndexes) Implements org.jooq.SelectQuery.addOrderBy. Adds ordering fields.
public final void	addQualify(Condition The condition conditions) Implements org.jooq.SelectQuery.addQualify. Deprecated as a consequence of `Condition` being deprecated. Adds a new condition to the qualify clause of the query, connecting it with each other with `Operator#AND`.
public final void	addQualify(Condition... The condition conditions) Implements org.jooq.SelectQuery.addQualify. Deprecated as a consequence of `Condition` being deprecated. Adds new conditions to the qualify clause of the query, connecting them with each other with `Operator#AND`.
public final void	addQualify(Collection<? extends Condition> The condition conditions) Implements org.jooq.SelectQuery.addQualify. Adds new conditions to the qualify clause of the query, connecting them with each other with `Operator#AND`.
public final void	addQualify(Operator The operator to use to add the conditions to the existing conditions operator, Condition The condition conditions) Implements org.jooq.SelectQuery.addQualify. Deprecated as a consequence of `Condition` being deprecated. Adds a new condition to the qualify clause of query, connecting it with each other with `operator`.
public final void	addQualify(Operator The operator to use to add the conditions to the existing conditions operator, Condition... The condition conditions) Implements org.jooq.SelectQuery.addQualify. Deprecated as a consequence of `Condition` being deprecated. Adds new conditions to the qualify clause of query, connecting them with each other with `operator`.
public final void	addQualify(Operator The operator to use to add the conditions to the existing conditions operator, Collection<? extends Condition> The condition conditions) Implements org.jooq.SelectQuery.addQualify. Adds new conditions to the qualify clause of query, connecting them with each other with `operator`.
public final void	addSeekAfter(Field<?>... The seeking fields fields) Implements org.jooq.SelectQuery.addSeekAfter. Deprecated as a consequence of `Field` being deprecated. Adds seeking fields.
public final void	addSeekAfter(Collection<? extends Field<?>> The seeking fields fields) Implements org.jooq.SelectQuery.addSeekAfter. Adds seeking fields.
public final void	addSeekBefore(Field<?>... The seeking fields fields) Implements org.jooq.SelectQuery.addSeekBefore. Deprecated Adds seeking fields.
public final void	addSeekBefore(Collection<? extends Field<?>> The seeking fields fields) Implements org.jooq.SelectQuery.addSeekBefore. Deprecated Adds seeking fields.
public final void	addSelect(Collection<? extends SelectFieldOrAsterisk> fields) Implements org.jooq.SelectQuery.addSelect. Add a list of select fields.
public final void	addSelect(SelectFieldOrAsterisk... fields) Implements org.jooq.SelectQuery.addSelect. Add a list of select fields.
public final void	addWindow(WindowDefinition... The definitions definitions) Implements org.jooq.SelectQuery.addWindow. Deprecated as a consequence of `WindowDefinition` being deprecated. Adds new window definitions to the window clause of the query.
public final void	addWindow(Collection<? extends WindowDefinition> The definitions definitions) Implements org.jooq.SelectQuery.addWindow. Adds new window definitions to the window clause of the query.
pack-priv final void	addWindow0(Collection<? extends WindowDefinition> definitions)
private final void	appendResolveSomeAsterisks0(Scope ctx, boolean resolveSupported, SelectFieldList<SelectFieldOrAsterisk> result, boolean resolveExcept, boolean resolveUnqualifiedCombined, SelectFieldList<SelectFieldOrAsterisk> list, SelectFieldOrAsterisk s)
private final boolean	applySeekOnDerivedTable()
public final <T> Field<T>	asField() Implements org.jooq.FieldLike.asField. Deprecated as a consequence of `Field` being deprecated. The underlying field representation of this object.
public final <T> Field<T>	asField(String alias) Implements org.jooq.FieldLike.asField. Deprecated as a consequence of `Field` being deprecated. The underlying field representation of this object.
public <T> Field<T>	asField(Function<? super Field<T>, ? extends String> aliasFunction) Implements org.jooq.FieldLike.asField. Deprecated as a consequence of `Field` being deprecated. The underlying field representation of this object.
public final Field<Result<R>>	asMultiset() Implements org.jooq.TableLike.asMultiset. Deprecated as a consequence of `Field` being deprecated. Turn this `TableLike` expression into a `DSL#multiset(TableLike)`.
public final Field<Result<R>>	asMultiset(String alias) Implements org.jooq.TableLike.asMultiset. Deprecated as a consequence of `Field` being deprecated. Turn this `TableLike` expression into a `DSL#multiset(TableLike)`.
public final Field<Result<R>>	asMultiset(Name alias) Implements org.jooq.TableLike.asMultiset. Deprecated as a consequence of `Field` being deprecated. Turn this `TableLike` expression into a `DSL#multiset(TableLike)`.
public final Field<Result<R>>	asMultiset(Field<?> alias) Implements org.jooq.TableLike.asMultiset. Deprecated as a consequence of `Field` being deprecated. Turn this `TableLike` expression into a `DSL#multiset(TableLike)`.
public final Table<R>	asTable() Implements org.jooq.TableLike.asTable. The underlying table representation of this object.
public final Table<R>	asTable(String alias) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final Table<R>	asTable(String alias, String... fieldAliases) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final Table<R>	asTable(String alias, Collection<? extends String> fieldAliases) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final Table<R>	asTable(Name alias) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final Table<R>	asTable(Name alias, Name... fieldAliases) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final Table<R>	asTable(Name alias, Collection<? extends Name> fieldAliases) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final Table<R>	asTable(Table<?> alias) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final Table<R>	asTable(Table<?> alias, Field<?>... fieldAliases) Implements org.jooq.TableLike.asTable. Deprecated as a consequence of `Field` being deprecated. The underlying aliased table representation of this object.
public final Table<R>	asTable(Table<?> alias, Collection<? extends Field<?>> fieldAliases) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final Table<R>	asTable(String alias, Function<? super Field<?>, ? extends String> aliasFunction) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final Table<R>	asTable(String alias, BiFunction<? super Field<?>, ? super Integer, ? extends String> aliasFunction) Implements org.jooq.TableLike.asTable. The underlying aliased table representation of this object.
public final Clause[]	clauses(Context<?> ctx) Overrides org.jooq.impl.AbstractQueryPart.clauses. Implements org.jooq.QueryPartInternal.clauses. Deprecated as a consequence of `Clause` being deprecated. The `Clause`s that are represented by this query part.
private final SelectQueryImpl<R>	combine(CombineOperator op, Select<? extends R> other) Deprecated as a consequence of `SelectQueryImpl` being deprecated.
private final SelectQueryImpl<R>	copy(Consumer<? super SelectQueryImpl<R>> finisher) Deprecated as a consequence of `SelectQueryImpl` being deprecated.
private final SelectQueryImpl<R>	copy(Consumer<? super SelectQueryImpl<R>> finisher, WithImpl newWith) Deprecated as a consequence of `SelectQueryImpl` being deprecated.
private final SelectQueryImpl<R>	copyAfter(SelectQueryImpl.CopyClause clause, boolean scalarSelect, SelectQueryImpl<R> result) Deprecated as a consequence of `SelectQueryImpl` being deprecated.
private final SelectQueryImpl<R>	copyBetween(SelectQueryImpl.CopyClause start, SelectQueryImpl.CopyClause end, boolean scalarSelect, SelectQueryImpl<R> result) Deprecated as a consequence of `SelectQueryImpl` being deprecated.
private final SelectQueryImpl<R>	copyTo(SelectQueryImpl.CopyClause clause, boolean scalarSelect, SelectQueryImpl<R> result) Deprecated as a consequence of `SelectQueryImpl` being deprecated.
private final boolean	derivedTableRequired(Context<?> context, Select<?> s1)
private final Select<?>	distinctOnEmulation()
public final SelectQueryImpl<R>	except(Select<? extends R> other) Implements org.jooq.Select.except. Deprecated as a consequence of `SelectQueryImpl` being deprecated. Apply the `EXCEPT` (or `MINUS`) set operation.
public final SelectQueryImpl<R>	exceptAll(Select<? extends R> other) Implements org.jooq.Select.exceptAll. Deprecated as a consequence of `SelectQueryImpl` being deprecated. Apply the `EXCEPT ALL` set operation.
public final Row	fieldsRow() Overrides default org.jooq.impl.ResultQueryTrait.fieldsRow. Implements org.jooq.Fields.fieldsRow. Get all fields known to this type as a `Row`.
pack-priv final ForLock	forLock() Deprecated as a consequence of `ForLock` being deprecated.
public final Field<?>[]	getFields(ThrowingSupplier<? extends ResultSetMetaData, SQLException> rs) Overrides default org.jooq.impl.ResultQueryTrait.getFields. Deprecated as a consequence of `Field` being deprecated. Get a list of fields provided a result set.
public final Field<?>[]	getFields() Implements org.jooq.impl.ResultQueryTrait.getFields. Deprecated as a consequence of `Field` being deprecated. Get a list of fields if we don't have a result set.
pack-priv final TableList	getFrom()
pack-priv final GroupFieldList	getGroupBy()
pack-priv final ConditionProviderImpl	getHaving() Deprecated as a consequence of `ConditionProviderImpl` being deprecated.
pack-priv final Limit	getLimit()
pack-priv final SortFieldList	getNonEmptyOrderBy(Configuration configuration)
pack-priv final SortFieldList	getNonEmptyOrderByForDistinct(Configuration configuration)
pack-priv final SortFieldList	getOrderBy()
pack-priv final ConditionProviderImpl	getQualify() Deprecated as a consequence of `ConditionProviderImpl` being deprecated.
pack-priv final Class<? extends R>	getRecordType0() Implements abstract org.jooq.impl.AbstractResultQuery.getRecordType0.
private final Field<?>	getResolveProjection(Scope ctx, Field<?> f) Deprecated as a consequence of `Field` being deprecated.
pack-priv final QueryPartList<Field<?>>	getSeek()
pack-priv final Condition	getSeekCondition(Context<?> ctx) Deprecated as a consequence of `Condition` being deprecated.
public final List<Field<?>>	getSelect() Implements org.jooq.Select.getSelect. All fields selected in this query
pack-priv final SelectFieldList<SelectFieldOrAsterisk>	getSelectAsSpecified() The select list as specified by the API user.
private final SelectQueryImpl.SelectFieldIndexes	getSelectFieldIndexes(Context<?> ctx) [#11904] Get a mapping { projected field index -> generated field index }
pack-priv final SelectFieldList<Field<?>>	getSelectResolveAllAsterisks(Scope ctx) The select list with resolved explicit asterisks (if they contain the except clause and that is not supported).
pack-priv final SelectFieldList<SelectFieldOrAsterisk>	getSelectResolveImplicitAsterisks() The select list with resolved implicit asterisks.
private final SelectFieldList<SelectFieldOrAsterisk>	getSelectResolveSomeAsterisks0(Scope ctx, boolean resolveSupported)
pack-priv final SelectFieldList<SelectFieldOrAsterisk>	getSelectResolveUnsupportedAsterisks(Context<?> ctx) The select list with resolved explicit asterisks (if they contain the except clause and that is not supported).
pack-priv final ConditionProviderImpl	getWhere(Context<?> ctx) Deprecated as a consequence of `ConditionProviderImpl` being deprecated.
private final boolean	hasInlineDerivedTables(TableList tablelist)
private final boolean	hasInlineDerivedTables(JoinTable<J extends JoinTable<J>> join)
pack-priv final boolean	hasUnions()
private final void	initLockMode()
public final SelectQueryImpl<R>	intersect(Select<? extends R> other) Implements org.jooq.Select.intersect. Deprecated as a consequence of `SelectQueryImpl` being deprecated. Apply the `INTERSECT` set operation.
public final SelectQueryImpl<R>	intersectAll(Select<? extends R> other) Implements org.jooq.Select.intersectAll. Deprecated as a consequence of `SelectQueryImpl` being deprecated. Apply the `INTERSECT ALL` set operation.
private final boolean	knownTableSource()
private final void	pushWindow(Context<?> context)
private final <Q extends QueryPartList<? super Field<?>>> Q	resolveAsterisk(Q result)
private final <Q extends QueryPartList<? super Field<?>>> Q	resolveAsterisk(Q result, QueryPartCollectionView<? extends Field<?>> except)
public final void	setDistinct(boolean distinct) Implements org.jooq.SelectQuery.setDistinct. Add "distinct" keyword to the select clause.
public final void	setForKeyShare(boolean forKeyShare) Implements org.jooq.SelectQuery.setForKeyShare. Sets the "FOR KEY SHARE" lock mode onto the query.
public final void	setForLockModeNoWait() Implements org.jooq.SelectQuery.setForLockModeNoWait. Some RDBMS allow for specifying the locking mode for the applied `FOR <lock_mode>` clause.
public final void	setForLockModeOf(Field<?>... The fields that should be locked fields) Implements org.jooq.SelectQuery.setForLockModeOf. Deprecated as a consequence of `Field` being deprecated. Some RDBMS allow for specifying the fields that should be locked by the `FOR <lock_mode>` clause, instead of the full row.
public final void	setForLockModeOf(Collection<? extends Field<?>> fields) Implements org.jooq.SelectQuery.setForLockModeOf. Some RDBMS allow for specifying the fields that should be locked by the `FOR <lock_mode>` clause, instead of the full row.
public final void	setForLockModeOf(Table<?>... The tables that should be locked tables) Implements org.jooq.SelectQuery.setForLockModeOf. Some RDBMS allow for specifying the tables that should be locked by the `FOR <lock_mode>` clause, instead of the full row.
public final void	setForLockModeSkipLocked() Implements org.jooq.SelectQuery.setForLockModeSkipLocked. Some RDBMS allow for specifying the locking mode for the applied `FOR <lock_mode>` clause.
public final void	setForLockModeWait(int The number of seconds to wait for a lock seconds) Implements org.jooq.SelectQuery.setForLockModeWait. Some RDBMS allow for specifying the locking mode for the applied `FOR <lock_mode>` clause.
public final void	setForNoKeyUpdate(boolean forNoKeyUpdate) Implements org.jooq.SelectQuery.setForNoKeyUpdate. Sets the "FOR NO KEY UPDATE" lock mode onto the query.
public final void	setForShare(boolean The flag's value forShare) Implements org.jooq.SelectQuery.setForShare. Sets the "FOR SHARE" lock mode onto the query.
public final void	setForUpdate(boolean The flag's value forUpdate) Implements org.jooq.SelectQuery.setForUpdate. Sets the "FOR UPDATE" lock mode onto the query.
public final void	setForUpdateNoWait() Implements org.jooq.SelectQuery.setForUpdateNoWait. Some RDBMS allow for specifying the locking mode for the applied `FOR UPDATE` clause.
public final void	setForUpdateOf(Field<?>... The fields that should be locked fields) Implements org.jooq.SelectQuery.setForUpdateOf. Deprecated as a consequence of `Field` being deprecated. Some RDBMS allow for specifying the fields that should be locked by the `FOR UPDATE` clause, instead of the full row.
public final void	setForUpdateOf(Collection<? extends Field<?>> fields) Implements org.jooq.SelectQuery.setForUpdateOf. Some RDBMS allow for specifying the fields that should be locked by the `FOR UPDATE` clause, instead of the full row.
public final void	setForUpdateOf(Table<?>... The tables that should be locked tables) Implements org.jooq.SelectQuery.setForUpdateOf. Some RDBMS allow for specifying the tables that should be locked by the `FOR UPDATE` clause, instead of the full row.
public final void	setForUpdateSkipLocked() Implements org.jooq.SelectQuery.setForUpdateSkipLocked. Some RDBMS allow for specifying the locking mode for the applied `FOR UPDATE` clause.
public final void	setForUpdateWait(int The number of seconds to wait for a lock seconds) Implements org.jooq.SelectQuery.setForUpdateWait. Some RDBMS allow for specifying the locking mode for the applied `FOR UPDATE` clause.
public final void	setGroupByDistinct(boolean groupByDistinct) Implements org.jooq.SelectQuery.setGroupByDistinct. Specifies the `GROUP BY DISTINCT` clause.
pack-priv final void	setHint(String hint)
public final void	setInto(Table<?> table) Implements org.jooq.SelectQuery.setInto. Add a T-SQL style `INTO` clause to the `SELECT` statement to create a new table from a `SELECT` statement.
public final void	setLimitPercent(boolean percent) Implements org.jooq.SelectQuery.setLimitPercent. Add the `PERCENT` clause to a `LIMIT` clause.
pack-priv final void	setOption(String option)
public final void	setWithCheckOption() Implements org.jooq.SelectQuery.setWithCheckOption. Add a `WITH CHECK OPTION` clause to the end of the subquery.
public final void	setWithReadOnly() Implements org.jooq.SelectQuery.setWithReadOnly. Add a `WITH READ ONLY` clause to the end of the subquery.
public final void	setWithTies(boolean withTies) Implements org.jooq.SelectQuery.setWithTies. Add the `WITH TIES` clause to a `LIMIT` clause.
private static final Collection<? extends Field<?>>	subtract(List<? extends Field<?>> left, List<? extends Field<?>> right)
private final void	toSQLOrderBy(final Context<?> ctx, final List<Field<?>> originalFields, final List<Field<?>> alternativeFields, final boolean wrapQueryExpressionInDerivedTable, final boolean wrapQueryExpressionBodyInDerivedTable, final boolean isUnionOrderBy, QueryPartListView<SortField<?>> actualOrderBy, Limit actualLimit)
private final void	toSQLReference0(Context<?> context, List<Field<?>> originalFields, List<Field<?>> alternativeFields) This method renders the main part of a query without the LIMIT clause.
private final void	toSQLReferenceLimitDefault(Context<?> context, List<Field<?>> originalFields, List<Field<?>> alternativeFields) The default LIMIT / OFFSET clause in most dialects
private final void	toSQLReferenceLimitWithWindowFunctions(Context<?> ctx) Emulate the LIMIT / OFFSET clause using window functions, specifically when the WITH TIES clause is specified.
private final void	transformInlineDerivedTable0(Table<?> table, TableList result, ConditionProviderImpl where) Deprecated as a consequence of `ConditionProviderImpl` being deprecated.
private final TableList	transformInlineDerivedTables(TableList tablelist, ConditionProviderImpl where) Deprecated as a consequence of `ConditionProviderImpl` being deprecated.
private final Table<?>	transformInlineDerivedTables0(Table<?> table, ConditionProviderImpl where, boolean keepDerivedTable) Deprecated as a consequence of `ConditionProviderImpl` being deprecated.
public final SelectQueryImpl<R>	union(Select<? extends R> other) Implements org.jooq.Select.union. Deprecated as a consequence of `SelectQueryImpl` being deprecated. Apply the `UNION` set operation.
public final SelectQueryImpl<R>	unionAll(Select<? extends R> other) Implements org.jooq.Select.unionAll. Deprecated as a consequence of `SelectQueryImpl` being deprecated. Apply the `UNION ALL` set operation.
private final boolean	unionOpNesting()
private final boolean	unionParensRequired(Context<?> context)
private final boolean	unionParensRequired(SelectQueryImpl<?> s) Deprecated as a consequence of `SelectQueryImpl` being deprecated.
private final void	unionParenthesis(Context<?> ctx, char parenthesis, List<Field<?>> fields, boolean derivedTableRequired, boolean parensRequired)
private final boolean	wrapQueryExpressionBodyInDerivedTable(Context<?> ctx)

pack-priv final Class SelectQueryImpl<R extends org.jooq.Record>

Nested and Inner Type Summary

Field Summary

Constructor Summary

Method Summary