Top Fields Constructors Methods
org.jooq.impl

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

extends AbstractField<Result<R extends Record>>
implements QOM.Multiset<R extends Record>
Class Inheritance
All Implemented Interfaces
org.jooq.impl.QOM.Multiset, org.jooq.Field, org.jooq.TableElement, org.jooq.Named, org.jooq.QueryPart, java.io.Serializable, org.jooq.FieldOrConstraint, org.jooq.FieldOrRowOrSelect, org.jooq.FieldOrRow, org.jooq.OrderField, org.jooq.GroupField, org.jooq.SelectField, org.jooq.Typed, org.jooq.SelectFieldOrAsterisk
Static Imports
java.lang.Boolean.TRUE, java.util.Arrays.asList, org.jooq.SQLDialect.MYSQL, org.jooq.SQLDialect.*, .SQLDialect.POSTGRES, .SQLDialect.YUGABYTEDB, org.jooq.impl.DSL.function, .DSL.inline, .DSL.jsonArray, .DSL.jsonEntry, .DSL.jsonbArray, .DSL.row, .DSL.select, .DSL.selectFrom, .DSL.toHex, .DSL.when, .DSL.xmlagg, .DSL.xmlattributes, .DSL.xmlelement, .DSL.xmlserializeContent, .DerivedTable.NO_SUPPORT_CORRELATED_DERIVED_TABLE, .JSONArrayAgg.patchOracleArrayAggBug, .Keywords.K_MULTISET, .Names.NQ_RESULT, .Names.N_HEX, .Names.N_JSON_QUERY, .Names.N_MULTISET, .Names.N_RECORD, .Names.N_RESULT, .SQLDataType.BLOB, .SQLDataType.CLOB, .SQLDataType.JSON, .SQLDataType.JSONB, .SQLDataType.VARCHAR, .Tools.emulateMultiset, .Tools.fieldName, .Tools.fieldNameString, .Tools.fieldNames, .Tools.map, .Tools.selectQueryImpl, .Tools.visitSubquery, .Tools.BooleanDataKey.DATA_MULTISET_CONDITION, .Tools.BooleanDataKey.DATA_MULTISET_CONTENT

Deprecated

as a consequence of AbstractField and QOM.Multiset being deprecated. See corresponding docs for further information.

Author
Lukas Eder

Field Summary

Modifier and TypeField and Description
pack-priv static final Set<SQLDialect>
FORCE_LIMIT_IN_DERIVED_TABLE

pack-priv static final Set<SQLDialect>
NO_SUPPORT_JSON_COMPARE

pack-priv static final Set<SQLDialect>
NO_SUPPORT_JSONB_COMPARE

pack-priv static final Set<SQLDialect>
NO_SUPPORT_XML_COMPARE

pack-priv final Select<R>
select

pack-priv final TableLike<R>
table

Constructor Summary

AccessConstructor and Description
pack-priv
Multiset(TableLike<R> table)

private
Multiset(TableLike<R> table, Select<R> select)

Method Summary

Modifier and TypeMethod and Description
public final TableLike<R>
$table()

Implements org.jooq.impl.QOM.Multiset.$table.

public final void
accept(Context<?> ctx)

Implements abstract org.jooq.impl.AbstractField.accept.

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
accept0(Context<?> ctx, boolean multisetCondition)

private static final void
acceptMultisetSubqueryForXMLEmulation(Context<?> ctx, boolean multisetCondition, Select<Record1<XML>> s)

pack-priv static final Field<?>
castForJSON(Context<?> ctx, Field<?> field)

Deprecated as a consequence of Field being deprecated.
pack-priv static final Field<?>
castForXML(Context<?> ctx, Field<?> field)

Deprecated as a consequence of Field being deprecated.
private static final boolean
isSimple(Select<?> s)

pack-priv static final JSONArrayAggOrderByStep<JSON>
jsonArrayaggEmulation(Context<?> ctx, Fields fields, boolean agg, boolean distinct)

Deprecated as a consequence of JSONArrayAggOrderByStep being deprecated.
pack-priv static final JSONArrayAggOrderByStep<JSONB>
jsonbArrayaggEmulation(Context<?> ctx, Fields fields, boolean agg, boolean distinct)

Deprecated as a consequence of JSONArrayAggOrderByStep being deprecated.
pack-priv static final <J> JSONArrayAggOrderByStep<J>
jsonxArrayaggEmulation(Context<?> ctx, Fields fields, boolean agg, Function<? super Field<?>, ? extends JSONArrayAggOrderByStep<J>> jsonxArrayAgg, Function<? super Collection<? extends JSONEntry<?>>, ? extends JSONObjectNullStep<J>> jsonxObject, Function<? super Collection<? extends Field<?>>, ? extends JSONArrayNullStep<J>> jsonxArray)

Deprecated as a consequence of JSONArrayAggOrderByStep being deprecated.
pack-priv static final Name
nResult(Scope ctx)

pack-priv static final <J> Field<J>
returningClob(Scope ctx, JSONObjectReturningStep<J> j)

Deprecated as a consequence of JSONObjectReturningStep and Field being deprecated.
pack-priv static final <J> Field<J>
returningClob(Scope ctx, JSONArrayReturningStep<J> j)

Deprecated as a consequence of JSONArrayReturningStep and Field being deprecated.
pack-priv static final <J> Field<J>
returningClob(Scope ctx, JSONArrayAggReturningStep<J> j)

Deprecated as a consequence of JSONArrayAggReturningStep and Field being deprecated.
pack-priv static final XMLAggOrderByStep<XML>
xmlaggEmulation(Context<?> ctx, Fields fields, boolean agg)

Deprecated as a consequence of XMLAggOrderByStep being deprecated.
pack-priv static final Name
xsiNil(Context<?> ctx)

Inherited from org.jooq.impl.AbstractField:
$alias$aliasedabsacosaddaddasasasasascasciiasinatanatan2atan2avgavgOverbetweenbetweenbetweenbetweenbetweenSymmetricbetweenSymmetricbetweenSymmetricbetweenSymmetricbitAndbitAndbitLengthbitNandbitNandbitNorbitNorbitNotbitOrbitOrbitXNorbitXNorbitXorbitXorcastcastcastceilchangedcharLengthclausescoalescecoalescecoercecoercecoercecollatecollatecollatecommentcommentcomparecomparecomparecompareconcatconcatconcatcontainscontainscontainsIgnoreCasecontainsIgnoreCaseconvertconvertconvertconvertFromconvertFromconvertToconvertTocoscoshcotcothcountcountDistinctcountOverdecodedecodedecodedecodedegdescdivdivdividedivideendsWithendsWithendsWithIgnoreCaseendsWithIgnoreCaseeqeqeqeqequalequalequalequalequalIgnoreCaseequalIgnoreCaseexpextractfieldfirstValuefloorfromgegegegegetgetValuegreaterOrEqualgreaterOrEqualgreaterOrEqualgreaterOrEqualgreaterThangreaterThangreaterThangreaterThangreatestgreatestgtgtgtgtinininininisDistinctFromisDistinctFromisDistinctFromisDocumentisFalseisJsonisNotDistinctFromisNotDistinctFromisNotDistinctFromisNotDocumentisNotJsonisNotNullisNullisNullableisPossiblyNullableisTruelaglaglaglaglastValueleleleleleadleadleadleadleastleastlengthlessOrEquallessOrEquallessOrEquallessOrEquallessThanlessThanlessThanlessThanlikelikelikelikelikelikeIgnoreCaselikeIgnoreCaselikeIgnoreCaselikeIgnoreCaselikeRegexlikeRegexlnloglowerlpadlpadlpadlpadltltltltltrimmaxmaxOvermedianminminOverminusminusmodmodmodulomodulomulmulmultiplymultiplynenenenenegnotBetweennotBetweennotBetweennotBetweennotBetweenSymmetricnotBetweenSymmetricnotBetweenSymmetricnotBetweenSymmetricnotContainsnotContainsnotContainsIgnoreCasenotContainsIgnoreCasenotEqualnotEqualnotEqualnotEqualnotEqualIgnoreCasenotEqualIgnoreCasenotInnotInnotInnotInnotInnotLikenotLikenotLikenotLikenotLikenotLikeIgnoreCasenotLikeIgnoreCasenotLikeIgnoreCasenotLikeIgnoreCasenotLikeRegexnotLikeRegexnotSimilarTonotSimilarTonotSimilarTonotSimilarTonotSimilarTonullifnullifnullsFirstnullsLastnvlnvlnvl2nvl2octetLengthoriginalparenthesisedpluspluspositionpositionpowpowpowerpowerprojectionSizeradremremrepeatrepeatreplacereplacereplacereplaceresetroundroundrpadrpadrpadrpadrtrimshlshlshrshrsignsimilarTosimilarTosimilarTosimilarTosimilarTosinsinhsortsortsortAscsortAscsortDefaultsortDescsortDescsqrtstartsWithstartsWithstartsWithIgnoreCasestartsWithIgnoreCasestddevPopstddevPopOverstddevSampstddevSampOversubsubsubstringsubstringsubstringsubstringsubtractsubtractsumsumOvertantanhtimestimestrimunaryMinusunaryPlusuppervarPopvarPopOvervarSampvarSampOver

Field Detail

FORCE_LIMIT_IN_DERIVED_TABLEback to summary
pack-priv static final Set<SQLDialect> FORCE_LIMIT_IN_DERIVED_TABLE
NO_SUPPORT_JSON_COMPAREback to summary
pack-priv static final Set<SQLDialect> NO_SUPPORT_JSON_COMPARE
NO_SUPPORT_JSONB_COMPAREback to summary
pack-priv static final Set<SQLDialect> NO_SUPPORT_JSONB_COMPARE
NO_SUPPORT_XML_COMPAREback to summary
pack-priv static final Set<SQLDialect> NO_SUPPORT_XML_COMPARE
selectback to summary
pack-priv final Select<R> select
tableback to summary
pack-priv final TableLike<R> table

Constructor Detail

Multisetback to summary
pack-priv Multiset(TableLike<R> table)
Multisetback to summary
private Multiset(TableLike<R> table, Select<R> select)
Annotations
@SuppressWarnings:unchecked

Method Detail

$tableback to summary
public final TableLike<R> $table()

Implements org.jooq.impl.QOM.Multiset.$table.

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

Implements abstract org.jooq.impl.AbstractField.accept.

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
accept0back to summary
private final void accept0(Context<?> ctx, boolean multisetCondition)
Annotations
@SuppressWarnings:unchecked
acceptMultisetSubqueryForXMLEmulationback to summary
private static final void acceptMultisetSubqueryForXMLEmulation(Context<?> ctx, boolean multisetCondition, Select<Record1<XML>> s)
castForJSONback to summary
pack-priv static final Field<?> castForJSON(Context<?> ctx, Field<?> field)

Deprecated

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

Annotations
@SuppressWarnings:unchecked
castForXMLback to summary
pack-priv static final Field<?> castForXML(Context<?> ctx, Field<?> field)

Deprecated

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

Annotations
@SuppressWarnings:unchecked
isSimpleback to summary
private static final boolean isSimple(Select<?> s)
jsonArrayaggEmulationback to summary
pack-priv static final JSONArrayAggOrderByStep<JSON> jsonArrayaggEmulation(Context<?> ctx, Fields fields, boolean agg, boolean distinct)

Deprecated

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

jsonbArrayaggEmulationback to summary
pack-priv static final JSONArrayAggOrderByStep<JSONB> jsonbArrayaggEmulation(Context<?> ctx, Fields fields, boolean agg, boolean distinct)

Deprecated

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

jsonxArrayaggEmulationback to summary
pack-priv static final <J> JSONArrayAggOrderByStep<J> jsonxArrayaggEmulation(Context<?> ctx, Fields fields, boolean agg, Function<? super Field<?>, ? extends JSONArrayAggOrderByStep<J>> jsonxArrayAgg, Function<? super Collection<? extends JSONEntry<?>>, ? extends JSONObjectNullStep<J>> jsonxObject, Function<? super Collection<? extends Field<?>>, ? extends JSONArrayNullStep<J>> jsonxArray)

Deprecated

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

nResultback to summary
pack-priv static final Name nResult(Scope ctx)
returningClobback to summary
pack-priv static final <J> Field<J> returningClob(Scope ctx, JSONObjectReturningStep<J> j)

Deprecated

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

returningClobback to summary
pack-priv static final <J> Field<J> returningClob(Scope ctx, JSONArrayReturningStep<J> j)

Deprecated

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

returningClobback to summary
pack-priv static final <J> Field<J> returningClob(Scope ctx, JSONArrayAggReturningStep<J> j)

Deprecated

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

xmlaggEmulationback to summary
pack-priv static final XMLAggOrderByStep<XML> xmlaggEmulation(Context<?> ctx, Fields fields, boolean agg)

Deprecated

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

xsiNilback to summary
pack-priv static final Name xsiNil(Context<?> ctx)