Top Inners Fields Constructors Methods
org.jooq.impl

pack-priv final Class Expression<T>

extends AbstractTransformable<T>
implements QOM.UOperator2<Field<T>, Field<?>, Expression<T>>
Class Inheritance
All Implemented Interfaces
org.jooq.impl.QOM.UOperator2, org.jooq.impl.QOM.UOperator, org.jooq.QueryPart, java.io.Serializable
Static Imports
org.jooq.DatePart.MONTH, .DatePart.SECOND, .SQLDialect.CUBRID, .SQLDialect.DERBY, .SQLDialect.POSTGRES, .SQLDialect.YUGABYTEDB, org.jooq.conf.RenderOptionalKeyword.ON, org.jooq.impl.DSL.inline, .DSL.inlined, .DSL.keyword, .DSL.val, .ExpressionOperator.ADD, .ExpressionOperator.MULTIPLY, .ExpressionOperator.SUBTRACT, .Keywords.K_AS, .Keywords.K_CAST, .Keywords.K_DAY, .Keywords.K_DAY_MICROSECOND, .Keywords.K_DAY_MILLISECOND, .Keywords.K_DAY_TO_SECOND, .Keywords.K_INTERVAL, .Keywords.K_MILLISECOND, .Keywords.K_MONTH, .Keywords.K_SECOND, .Keywords.K_TO, .Keywords.K_YEAR_MONTH, .Keywords.K_YEAR_TO_MONTH, .Names.N_ADD_DAYS, .Names.N_ADD_MONTHS, .Names.N_ADD_SECONDS, .Names.N_DATEADD, .Names.N_DATE_ADD, .Names.N_SQL_TSI_FRAC_SECOND, .Names.N_SQL_TSI_MILLI_SECOND, .Names.N_SQL_TSI_MONTH, .Names.N_SQL_TSI_SECOND, .Names.N_STRFTIME, .Names.N_TIMESTAMPADD, .Names.N_TIMESTAMP_ADD, .Names.N_TIMESTAMP_SUB, .SQLDataType.INTEGER, .SQLDataType.TIMESTAMP, .Tools.castIfNeeded

Deprecated

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

Nested and Inner Type Summary

Modifier and TypeClass and Description
private static class
Expression.DateExpression<T>

Deprecated as a consequence of AbstractField being deprecated.
Return the expression to be rendered when the RHS is an interval type
pack-priv static record

Field Summary

Modifier and TypeField and Description
pack-priv static final Set<SQLDialect>
private final boolean
private final Field<T>
lhs

Deprecated as a consequence of Field being deprecated.
private final ExpressionOperator
private final Field<?>
rhs

Deprecated as a consequence of Field being deprecated.
pack-priv static final Set<SQLDialect>
private static final Pattern

Constructor Summary

AccessConstructor and Description
pack-priv
Expression(ExpressionOperator operator, boolean internal, Field<T> lhs, Field<?> rhs)

Deprecated as a consequence of Field being deprecated.

Method Summary

Modifier and TypeMethod and Description
public final Field<T>
$arg1()

Implements org.jooq.impl.QOM.UOperator2.$arg1.

Deprecated as a consequence of Field being deprecated.
public final Expression<T>
$arg1(Field<T> newValue)

Overrides default org.jooq.impl.QOM.UOperator2.$arg1.

Deprecated as a consequence of Field and Expression being deprecated.
public final Field<?>
$arg2()

Implements org.jooq.impl.QOM.UOperator2.$arg2.

Deprecated as a consequence of Field being deprecated.
public final Expression<T>
$arg2(Field<?> newValue)

Overrides default org.jooq.impl.QOM.UOperator2.$arg2.

Deprecated as a consequence of Field and Expression being deprecated.
public final Function2<? super Field<T>, ? super Field<?>, ? extends Expression<T>>
pack-priv final void
pack-priv static final <Q1 extends QueryPart, Q2 extends Q1> void
acceptAssociative(Context<?> ctx, Q2 exp, Function<? super Q2, ? extends Expression.Expr<Q1>> expProvider, Consumer<? super Context<?>> formatSeparator)

pack-priv static final DataType<?>
getExpressionDataType(AbstractField<?> l, ExpressionOperator operator, AbstractField<?> r)

Deprecated as a consequence of AbstractField being deprecated.
pack-priv final DataType<?>
getExpressionDataType()

Overrides org.jooq.impl.AbstractTypedNamed.getExpressionDataType.

[#11959] A workaround to get access to the actual data type of an expression.
private final Field<Number>
lhsAsNumber()

Deprecated as a consequence of Field being deprecated.
In some expressions, the lhs can be safely assumed to be a single number
private final Field<Number>
rhsAsNumber()

Deprecated as a consequence of Field being deprecated.
In some expressions, the rhs can be safely assumed to be a single number
public final Field<T>
transform(TransformUnneededArithmeticExpressions transform)

Implements org.jooq.impl.Transformable.transform.

Deprecated as a consequence of Field being deprecated.
pack-priv static final <T, R extends QOM.UOperator2<Field<T>, Field<T>, R>> Field<T>
transform(R expression, Field<T> lhs, ExpressionOperator operator, Field<T> rhs, boolean internal, TransformUnneededArithmeticExpressions transform)

Deprecated as a consequence of Field being deprecated.
Inherited from org.jooq.impl.AbstractTransformable:
accept

Field Detail

HASH_OP_FOR_BIT_XORback to summary
pack-priv static final Set<SQLDialect> HASH_OP_FOR_BIT_XOR
internalback to summary
private final boolean internal
lhsback to summary
private final Field<T> lhs

Deprecated

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

operatorback to summary
private final ExpressionOperator operator
rhsback to summary
private final Field<?> rhs

Deprecated

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

SUPPORT_YEAR_TO_SECONDback to summary
pack-priv static final Set<SQLDialect> SUPPORT_YEAR_TO_SECOND
TRUNC_TO_MICROSback to summary
private static final Pattern TRUNC_TO_MICROS

Constructor Detail

Expressionback to summary
pack-priv Expression(ExpressionOperator operator, boolean internal, Field<T> lhs, Field<?> rhs)

Deprecated

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

Method Detail

$arg1back to summary
public final Field<T> $arg1()

Implements org.jooq.impl.QOM.UOperator2.$arg1.

Deprecated

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

Annotations
@Override
$arg1back to summary
public final Expression<T> $arg1(Field<T> newValue)

Overrides default org.jooq.impl.QOM.UOperator2.$arg1.

Deprecated

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

Annotations
@Override
$arg2back to summary
public final Field<?> $arg2()

Implements org.jooq.impl.QOM.UOperator2.$arg2.

Deprecated

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

Annotations
@Override
$arg2back to summary
public final Expression<T> $arg2(Field<?> newValue)

Overrides default org.jooq.impl.QOM.UOperator2.$arg2.

Deprecated

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

Annotations
@Override
$constructorback to summary
public final Function2<? super Field<T>, ? super Field<?>, ? extends Expression<T>> $constructor()

Implements org.jooq.impl.QOM.UOperator2.$constructor.

Annotations
@Override
accept0back to summary
pack-priv final void accept0(Context<?> ctx)

Implements abstract org.jooq.impl.AbstractTransformable.accept0.

Annotations
@Override
acceptAssociativeback to summary
pack-priv static final <Q1 extends QueryPart, Q2 extends Q1> void acceptAssociative(Context<?> ctx, Q2 exp, Function<? super Q2, ? extends Expression.Expr<Q1>> expProvider, Consumer<? super Context<?>> formatSeparator)
Annotations
@SuppressWarnings:unchecked
getExpressionDataTypeback to summary
pack-priv static final DataType<?> getExpressionDataType(AbstractField<?> l, ExpressionOperator operator, AbstractField<?> r)

Deprecated

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

getExpressionDataTypeback to summary
pack-priv final DataType<?> getExpressionDataType()

Overrides org.jooq.impl.AbstractTypedNamed.getExpressionDataType.

Doc from org.jooq.impl.AbstractTypedNamed.getExpressionDataType.

[#11959] A workaround to get access to the actual data type of an expression.

Annotations
@Override
lhsAsNumberback to summary
private final Field<Number> lhsAsNumber()

Deprecated

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

In some expressions, the lhs can be safely assumed to be a single number

Annotations
@SuppressWarnings:unchecked
rhsAsNumberback to summary
private final Field<Number> rhsAsNumber()

Deprecated

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

In some expressions, the rhs can be safely assumed to be a single number

Annotations
@SuppressWarnings:unchecked
transformback to summary
public final Field<T> transform(TransformUnneededArithmeticExpressions transform)

Implements org.jooq.impl.Transformable.transform.

Deprecated

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

Annotations
@Override
transformback to summary
pack-priv static final <T, R extends QOM.UOperator2<Field<T>, Field<T>, R>> Field<T> transform(R expression, Field<T> lhs, ExpressionOperator operator, Field<T> rhs, boolean internal, TransformUnneededArithmeticExpressions transform)

Deprecated

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

org.jooq.impl back to summary

private Class Expression.DateExpression<T>

extends AbstractField<T>
implements UTransient
Class Inheritance
All Implemented Interfaces
org.jooq.impl.QOM.UTransient, org.jooq.impl.QOM.UEmpty, org.jooq.QueryPart, java.io.Serializable

Deprecated

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

Return the expression to be rendered when the RHS is an interval type

Field Summary

Modifier and TypeField and Description
private final Field<T>
lhs

Deprecated as a consequence of Field being deprecated.
private final ExpressionOperator
private final Field<?>
rhs

Deprecated as a consequence of Field being deprecated.

Constructor Summary

AccessConstructor and Description
pack-priv
DateExpression(Field<T> lhs, ExpressionOperator operator, Field<?> rhs)

Deprecated as a consequence of Field being deprecated.

Method Summary

Modifier and TypeMethod and Description
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
private final void
acceptNumberExpression(Context<?> ctx)

Return the expression to be rendered when the RHS is a number type

private final void
private final <U> Field<U>
p(U u)

Deprecated as a consequence of Field being deprecated.
private final DayToSecond
private final Interval
private final Field<Number>
rhsAsNumber()

Deprecated as a consequence of Field being deprecated.
In some expressions, the rhs can be safely assumed to be a single number
private final YearToMonth
private final YearToSecond
Inherited from org.jooq.impl.AbstractField:
$alias$aliasedabsacosaddaddasasasasascasciiasinatanatan2atan2avgavgOverbetweenbetweenbetweenbetweenbetweenSymmetricbetweenSymmetricbetweenSymmetricbetweenSymmetricbitAndbitAndbitLengthbitNandbitNandbitNorbitNorbitNotbitOrbitOrbitXNorbitXNorbitXorbitXorcastcastcastceilchangedcharLengthclausescoalescecoalescecoercecoercecoercecollatecollatecollatecommentcommentcomparecomparecomparecompareconcatconcatconcatcontainscontainscontainsIgnoreCasecontainsIgnoreCaseconvertconvertconvertconvertFromconvertFromconvertToconvertTocoscoshcotcothcountcountDistinctcountOverdecodedecodedecodedecodedegdescdivdivdividedivideendsWithendsWithendsWithIgnoreCaseendsWithIgnoreCaseeqeqeqeqequalequalequalequalequalIgnoreCaseequalIgnoreCaseexpextractfieldfirstValuefloorfromgegegegegetgetValuegreaterOrEqualgreaterOrEqualgreaterOrEqualgreaterOrEqualgreaterThangreaterThangreaterThangreaterThangreatestgreatestgtgtgtgtinininininisDistinctFromisDistinctFromisDistinctFromisDocumentisFalseisJsonisNotDistinctFromisNotDistinctFromisNotDistinctFromisNotDocumentisNotJsonisNotNullisNullisNullableisPossiblyNullableisTruelaglaglaglaglastValueleleleleleadleadleadleadleastleastlengthlessOrEquallessOrEquallessOrEquallessOrEquallessThanlessThanlessThanlessThanlikelikelikelikelikelikeIgnoreCaselikeIgnoreCaselikeIgnoreCaselikeIgnoreCaselikeRegexlikeRegexlnloglowerlpadlpadlpadlpadltltltltltrimmaxmaxOvermedianminminOverminusminusmodmodmodulomodulomulmulmultiplymultiplynenenenenegnotBetweennotBetweennotBetweennotBetweennotBetweenSymmetricnotBetweenSymmetricnotBetweenSymmetricnotBetweenSymmetricnotContainsnotContainsnotContainsIgnoreCasenotContainsIgnoreCasenotEqualnotEqualnotEqualnotEqualnotEqualIgnoreCasenotEqualIgnoreCasenotInnotInnotInnotInnotInnotLikenotLikenotLikenotLikenotLikenotLikeIgnoreCasenotLikeIgnoreCasenotLikeIgnoreCasenotLikeIgnoreCasenotLikeRegexnotLikeRegexnotSimilarTonotSimilarTonotSimilarTonotSimilarTonotSimilarTonullifnullifnullsFirstnullsLastnvlnvlnvl2nvl2octetLengthoriginalparenthesisedpluspluspositionpositionpowpowpowerpowerprojectionSizeradremremrepeatrepeatreplacereplacereplacereplaceresetroundroundrpadrpadrpadrpadrtrimshlshlshrshrsignsimilarTosimilarTosimilarTosimilarTosimilarTosinsinhsortsortsortAscsortAscsortDefaultsortDescsortDescsqrtstartsWithstartsWithstartsWithIgnoreCasestartsWithIgnoreCasestddevPopstddevPopOverstddevSampstddevSampOversubsubsubstringsubstringsubstringsubstringsubtractsubtractsumsumOvertantanhtimestimestrimunaryMinusunaryPlusuppervarPopvarPopOvervarSampvarSampOver

Field Detail

lhsback to summary
private final Field<T> lhs

Deprecated

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

operatorback to summary
private final ExpressionOperator operator
rhsback to summary
private final Field<?> rhs

Deprecated

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

Constructor Detail

DateExpressionback to summary
pack-priv DateExpression(Field<T> lhs, ExpressionOperator operator, Field<?> rhs)

Deprecated

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

Method Detail

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
acceptIntervalExpressionback to summary
private final void acceptIntervalExpression(Context<?> ctx)
Annotations
@SuppressWarnings:unchecked, rawtypes
acceptNumberExpressionback to summary
private final void acceptNumberExpression(Context<?> ctx)

Return the expression to be rendered when the RHS is a number type

Annotations
@SuppressWarnings:unchecked, rawtypes
acceptYTSExpressionback to summary
private final void acceptYTSExpression(Context<?> ctx)
pback to summary
private final <U> Field<U> p(U u)

Deprecated

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

rhsAsDTSback to summary
private final DayToSecond rhsAsDTS()
Annotations
@SuppressWarnings:unchecked
rhsAsIntervalback to summary
private final Interval rhsAsInterval()
Annotations
@SuppressWarnings:unchecked
rhsAsNumberback to summary
private final Field<Number> rhsAsNumber()

Deprecated

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

In some expressions, the rhs can be safely assumed to be a single number

Annotations
@SuppressWarnings:unchecked
rhsAsYTMback to summary
private final YearToMonth rhsAsYTM()
Annotations
@SuppressWarnings:unchecked
rhsAsYTSback to summary
private final YearToSecond rhsAsYTS()
Annotations
@SuppressWarnings:unchecked
org.jooq.impl back to summary

pack-priv final Record Expression.Expr<Q extends org.jooq.QueryPart>

extends Record
Class Inheritance
Record Components
lhs:Q 
op:QueryPart 
rhs:Q 

Field Summary

Modifier and TypeField and Description
private final Q
lhs

Record Component accessed by lhs().

private final QueryPart
op

Record Component accessed by op().

private final Q
rhs

Record Component accessed by rhs().

Constructor Summary

AccessConstructor and Description
pack-priv
Expr(Q lhs, QueryPart op, Q rhs)

Method Summary

Modifier and TypeMethod and Description
public final boolean
equals(Object
the reference object with which to compare.
o
)

Implements abstract java.lang.Record.equals.

Indicates whether some other object is "equal to" this one.
public final int
hashCode()

Implements abstract java.lang.Record.hashCode.

Returns a hash code value for the record.
public Q
lhs()

Record Component getter of lhs.

public QueryPart
op()

Record Component getter of op.

public Q
rhs()

Record Component getter of rhs.

public final String
toString()

Implements abstract java.lang.Record.toString.

Returns a string representation of the record.

Field Detail

lhsback to summary
private final Q lhs

Record Component accessed by lhs().

opback to summary
private final QueryPart op

Record Component accessed by op().

rhsback to summary
private final Q rhs

Record Component accessed by rhs().

Constructor Detail

Exprback to summary
pack-priv Expr(Q lhs, QueryPart op, Q rhs)

Method Detail

equalsback to summary
public final boolean equals(Object o)

Implements abstract java.lang.Record.equals.

Doc from java.lang.Record.equals.

Indicates whether some other object is "equal to" this one. In addition to the general contract of Object.equals, record classes must further obey the invariant that when a record instance is "copied" by passing the result of the record component accessor methods to the canonical constructor, as follows:

    R copy = new R(r.c1(), r.c2(), ..., r.cn());
then it must be the case that r.equals(copy).
Parameters
o:Object

the reference object with which to compare.

Returns:boolean

true if this record is equal to the argument; false otherwise.

hashCodeback to summary
public final int hashCode()

Implements abstract java.lang.Record.hashCode.

Doc from java.lang.Record.hashCode.

Returns a hash code value for the record. Obeys the general contract of Object.hashCode. For records, hashing behavior is constrained by the refined contract of Record.equals, so that any two records created from the same components must have the same hash code.

Returns:int

a hash code value for this record.

lhsback to summary
public Q lhs()

Record Component getter of lhs.

opback to summary
public QueryPart op()

Record Component getter of op.

rhsback to summary
public Q rhs()

Record Component getter of rhs.

toStringback to summary
public final String toString()

Implements abstract java.lang.Record.toString.

Doc from java.lang.Record.toString.

Returns a string representation of the record. In accordance with the general contract of Object#toString(), the toString method returns a string that "textually represents" this record. The result should be a concise but informative representation that is easy for a person to read.

In addition to this general contract, record classes must further participate in the invariant that any two records which are equal must produce equal strings. This invariant is necessarily relaxed in the rare case where corresponding equal component values might fail to produce equal strings for themselves.

Returns:String

a string representation of the object.