Interface Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
- All Superinterfaces:
FieldOrRow,Fields,Named,QueryPart,Row,SelectField<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>,SelectFieldOrAsterisk,Serializable,Typed<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>
Row value expressions are mainly useful for use in predicates, when comparing several values in one go, which can be more elegant than expanding the row value expression predicate in other equivalent syntaxes. This is especially true for non-equality predicates. For instance, the following two predicates are equivalent in SQL:
(A, B) > (X, Y)
(A > X) OR (A = X AND B > Y)
Example:
// Assuming import static org.jooq.impl.DSL.*;
using(configuration)
.select()
.from(CUSTOMER)
.where(row(CUSTOMER.FIRST_NAME, CUSTOMER.LAST_NAME).in(
select(ACTOR.FIRST_NAME, ACTOR.LAST_NAME).from(ACTOR)
))
.fetch();
Note: Not all databases support row value expressions, but many row value expression operations can be emulated on all databases. See relevant row value expression method Javadocs for details.
Instances can be created using DSL.row(Object...) and overloads.
- Author:
- Lukas Eder
-
Method Summary
Modifier and TypeMethodDescription@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16, Field<T17> minValue17, Field<T18> minValue18, Field<T19> minValue19)Check if this row value expression is within a range of two other row value expressions.@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>between(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue)Check if this row value expression is within a range of two records.@NotNull Conditionbetween(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue, Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)Check if this row value expression is within a range of two records.@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>between(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue)Check if this row value expression is within a range of two other row value expressions.@NotNull Conditionbetween(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue, Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)Check if this row value expression is within a range of two other row value expressions.@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16, T17 minValue17, T18 minValue18, T19 minValue19)Check if this row value expression is within a range of two other row value expressions.@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>betweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16, Field<T17> minValue17, Field<T18> minValue18, Field<T19> minValue19)Check if this row value expression is within a symmetric range of two other row value expressions.@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>betweenSymmetric(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue)Check if this row value expression is within a symmetric range of two records.@NotNull ConditionbetweenSymmetric(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue, Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)Check if this row value expression is within a symmetric range of two records.@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>betweenSymmetric(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue)Check if this row value expression is within a symmetric range of two other row value expressions.@NotNull ConditionbetweenSymmetric(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue, Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)Check if this row value expression is within a symmetric range of two other row value expressions.@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>betweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16, T17 minValue17, T18 minValue18, T19 minValue19)Check if this row value expression is within a symmetric range of two other row value expressions.@NotNull Conditioncompare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression using a dynamic comparator.@NotNull Conditioncompare(Comparator comparator, QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect using a dynamic comparator.@NotNull Conditioncompare(Comparator comparator, Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record using a dynamic comparator.@NotNull Conditioncompare(Comparator comparator, Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression using a dynamic comparator.@NotNull Conditioncompare(Comparator comparator, Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect using a dynamic comparator.@NotNull Conditioncompare(Comparator comparator, T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression using a dynamic comparator.@NotNull Conditioneq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for equality.@NotNull Conditioneq(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for equality.@NotNull Conditioneq(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for equality.@NotNull Conditioneq(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for equality.@NotNull Conditioneq(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for equality.@NotNull Conditioneq(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for equality.@NotNull Conditionequal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for equality.@NotNull Conditionequal(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for equality.@NotNull Conditionequal(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for equality.@NotNull Conditionequal(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for equality.@NotNull Conditionequal(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for equality.@NotNull Conditionequal(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for equality.field1()Get the first field.field10()Get the tenth field.field11()Get the eleventh field.field12()Get the twelfth field.field13()Get the thirteenth field.field14()Get the fourteenth field.field15()Get the fifteenth field.field16()Get the sixteenth field.field17()Get the seventeenth field.field18()Get the eighteenth field.field19()Get the ninteenth field.field2()Get the second field.field3()Get the third field.field4()Get the fourth field.field5()Get the fifth field.field6()Get the sixth field.field7()Get the seventh field.field8()Get the eighth field.field9()Get the ninth field.@NotNull Conditionge(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for order.@NotNull Conditionge(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.@NotNull Conditionge(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for order.@NotNull Conditionge(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for order.@NotNull Conditionge(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.@NotNull Conditionge(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for order.@NotNull ConditiongreaterOrEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for order.@NotNull ConditiongreaterOrEqual(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.@NotNull ConditiongreaterOrEqual(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for order.@NotNull ConditiongreaterOrEqual(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for order.@NotNull ConditiongreaterOrEqual(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.@NotNull ConditiongreaterOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for order.@NotNull ConditiongreaterThan(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for order.@NotNull ConditiongreaterThan(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.@NotNull ConditiongreaterThan(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for order.@NotNull ConditiongreaterThan(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for order.@NotNull ConditiongreaterThan(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.@NotNull ConditiongreaterThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for order.@NotNull Conditiongt(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for order.@NotNull Conditiongt(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.@NotNull Conditiongt(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for order.@NotNull Conditiongt(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for order.@NotNull Conditiongt(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.@NotNull Conditiongt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for order.@NotNull Conditionin(Collection<? extends Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> rows)Compare this row value expression with a set of row value expressions for equality.@NotNull Conditionin(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>... record)Compare this row value expression with a set of records for equality.@NotNull Conditionin(Result<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> result)Compare this row value expression with a set of records for equality.@NotNull Conditionin(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>... rows)Compare this row value expression with a set of row value expressions for equality.@NotNull Conditionin(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for equality.@NotNull ConditionisDistinctFrom(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionisDistinctFrom(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionisDistinctFrom(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionisDistinctFrom(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionisDistinctFrom(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionisNotDistinctFrom(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionisNotDistinctFrom(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionisNotDistinctFrom(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionisNotDistinctFrom(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionisNotDistinctFrom(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for distinctness.@NotNull Conditionle(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for order.@NotNull Conditionle(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.@NotNull Conditionle(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for order.@NotNull Conditionle(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for order.@NotNull Conditionle(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.@NotNull Conditionle(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for order.@NotNull ConditionlessOrEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for order.@NotNull ConditionlessOrEqual(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.@NotNull ConditionlessOrEqual(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for order.@NotNull ConditionlessOrEqual(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for order.@NotNull ConditionlessOrEqual(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.@NotNull ConditionlessOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for order.@NotNull ConditionlessThan(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for order.@NotNull ConditionlessThan(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.@NotNull ConditionlessThan(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for order.@NotNull ConditionlessThan(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for order.@NotNull ConditionlessThan(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.@NotNull ConditionlessThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for order.@NotNull Conditionlt(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for order.@NotNull Conditionlt(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.@NotNull Conditionlt(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for order.@NotNull Conditionlt(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for order.@NotNull Conditionlt(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.@NotNull Conditionlt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for order.<U> @NotNull SelectField<U>mapping(Class<U> uType, Function19<? super T1,? super T2,? super T3,? super T4,? super T5,? super T6,? super T7,? super T8,? super T9,? super T10,? super T11,? super T12,? super T13,? super T14,? super T15,? super T16,? super T17,? super T18,? super T19,? extends U> function)A convenience method to define a localRecord19to custom typeRecordMapperthat can be used when projectingRowtypes inSELECTorRETURNINGclauses.<U> @NotNull SelectField<U>mapping(Function19<? super T1,? super T2,? super T3,? super T4,? super T5,? super T6,? super T7,? super T8,? super T9,? super T10,? super T11,? super T12,? super T13,? super T14,? super T15,? super T16,? super T17,? super T18,? super T19,? extends U> function)A convenience method to define a localRecord19to custom typeRecordMapperthat can be used when projectingRowtypes inSELECTorRETURNINGclauses.@NotNull Conditionne(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for non-equality.@NotNull Conditionne(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for non-equality.@NotNull Conditionne(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for non-equality.@NotNull Conditionne(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for non-equality.@NotNull Conditionne(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for non-equality.@NotNull Conditionne(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for non-equality.@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>notBetween(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16, Field<T17> minValue17, Field<T18> minValue18, Field<T19> minValue19)Check if this row value expression is not within a range of two other row value expressions.@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>notBetween(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue)Check if this row value expression is within a range of two records.@NotNull ConditionnotBetween(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue, Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)Check if this row value expression is within a range of two records.@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>notBetween(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue)Check if this row value expression is not within a range of two other row value expressions.@NotNull ConditionnotBetween(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue, Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)Check if this row value expression is not within a range of two other row value expressions.@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>notBetween(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16, T17 minValue17, T18 minValue18, T19 minValue19)Check if this row value expression is not within a range of two other row value expressions.@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>notBetweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16, Field<T17> minValue17, Field<T18> minValue18, Field<T19> minValue19)Check if this row value expression is not within a symmetric range of two other row value expressions.@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>notBetweenSymmetric(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue)Check if this row value expression is not within a symmetric range of two records.@NotNull ConditionnotBetweenSymmetric(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue, Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)Check if this row value expression is not within a symmetric range of two records.@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>notBetweenSymmetric(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue)Check if this row value expression is not within a symmetric range of two other row value expressions.@NotNull ConditionnotBetweenSymmetric(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue, Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)Check if this row value expression is not within a symmetric range of two other row value expressions.@NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>notBetweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16, T17 minValue17, T18 minValue18, T19 minValue19)Check if this row value expression is not within a symmetric range of two other row value expressions.@NotNull ConditionnotEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for non-equality.@NotNull ConditionnotEqual(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for non-equality.@NotNull ConditionnotEqual(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for non-equality@NotNull ConditionnotEqual(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for non-equality.@NotNull ConditionnotEqual(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for non-equality.@NotNull ConditionnotEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for.@NotNull ConditionnotIn(Collection<? extends Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> rows)Compare this row value expression with a set of row value expressions for equality.@NotNull ConditionnotIn(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>... record)Compare this row value expression with a set of records for non-equality.@NotNull ConditionnotIn(Result<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> result)Compare this row value expression with a set of records for equality.@NotNull ConditionnotIn(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>... rows)Compare this row value expression with a set of row value expressions for equality.@NotNull ConditionnotIn(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for non-equality.@NotNull Statementset(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Assign a value to this set of variables.@NotNull Statementset(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Assign a value to this set of variables.@NotNull Statementset(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Assign a value to this set of variables.@NotNull Statementset(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> value)Assign a value to this set of variables.@NotNull Statementset(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Assign a value to this set of variables.Methods inherited from interface org.jooq.Fields
dataType, dataType, dataType, dataTypes, field, field, field, field, field, field, field, field, field, field, fields, fields, fields, fields, fields, fieldsRow, fieldStream, indexOf, indexOf, indexOf, type, type, type, typesMethods inherited from interface org.jooq.Named
getComment, getCommentPart, getName, getQualifiedName, getUnqualifiedNameMethods inherited from interface org.jooq.SelectField
as, as, asMethods inherited from interface org.jooq.Typed
getBinding, getConverter, getDataType, getDataType, getType
-
Method Details
-
mapping
@NotNull @Internal <U> @NotNull SelectField<U> mapping(Function19<? super T1,? super T2,? super T3,? super T4,? super T5,? super T6,? super T7,? super T8,? super T9,? super T10,? super T11,? super T12,? super T13,? super T14,? super T15,? super T16,? super T17,? super T18,? super T19,? extends U> function)A convenience method to define a localRecord19to custom typeRecordMapperthat can be used when projectingRowtypes inSELECTorRETURNINGclauses.EXPERIMENTAL. Unlike
mapping(Class, Function19), this method attempts to work without an explicitClassreference for the underlyingConverter.toType(). There may be some edge cases where this doesn't work. Please report any bugs here: https://github.com/jOOQ/jOOQ/issues/new/chooseKnown issues include:
- When nesting rows in arrays, the class literal is required for reflective array creation.
-
mapping
@NotNull <U> @NotNull SelectField<U> mapping(Class<U> uType, Function19<? super T1,? super T2,? super T3,? super T4,? super T5,? super T6,? super T7,? super T8,? super T9,? super T10,? super T11,? super T12,? super T13,? super T14,? super T15,? super T16,? super T17,? super T18,? super T19,? extends U> function)A convenience method to define a localRecord19to custom typeRecordMapperthat can be used when projectingRowtypes inSELECTorRETURNINGclauses. -
field1
Get the first field. -
field2
Get the second field. -
field3
Get the third field. -
field4
Get the fourth field. -
field5
Get the fifth field. -
field6
Get the sixth field. -
field7
Get the seventh field. -
field8
Get the eighth field. -
field9
Get the ninth field. -
field10
Get the tenth field. -
field11
Get the eleventh field. -
field12
Get the twelfth field. -
field13
Get the thirteenth field. -
field14
Get the fourteenth field. -
field15
Get the fifteenth field. -
field16
Get the sixteenth field. -
field17
Get the seventeenth field. -
field18
Get the eighteenth field. -
field19
Get the ninteenth field. -
compare
@NotNull @Support @NotNull Condition compare(Comparator comparator, Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression using a dynamic comparator.See the explicit comparison methods for details. Note, not all
Comparatortypes are supported -
compare
@NotNull @Support @NotNull Condition compare(Comparator comparator, Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record using a dynamic comparator.See the explicit comparison methods for details. Note, not all
Comparatortypes are supported -
compare
@NotNull @Support @NotNull Condition compare(Comparator comparator, T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression using a dynamic comparator.See the explicit comparison methods for details. Note, not all
Comparatortypes are supported -
compare
@NotNull @Support @NotNull Condition compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression using a dynamic comparator.See the explicit comparison methods for details. Note, not all
Comparatortypes are supported -
compare
@NotNull @Support @NotNull Condition compare(Comparator comparator, Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect using a dynamic comparator.See the explicit comparison methods for details. Note, not all
Comparatortypes are supported -
compare
@NotNull @Support @NotNull Condition compare(Comparator comparator, QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect using a dynamic comparator.See the explicit comparison methods for details. Note, not all
Comparatortypes are supported -
equal
@NotNull @Support @NotNull Condition equal(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for equality.Row equality comparison predicates can be emulated in those databases that do not support such predicates natively:
(A, B) = (1, 2)is equivalent toA = 1 AND B = 2 -
equal
@NotNull @Support @NotNull Condition equal(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for equality.- See Also:
equal(Row19)
-
equal
@NotNull @Support @NotNull Condition equal(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for equality.- See Also:
equal(Row19)
-
equal
@NotNull @Support @NotNull Condition equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for equality.- See Also:
equal(Row19)
-
equal
@NotNull @Support @NotNull Condition equal(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for equality.- See Also:
equal(Row19)
-
equal
@NotNull @Support @NotNull Condition equal(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for equality. -
eq
@NotNull @Support @NotNull Condition eq(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for equality.- See Also:
equal(Row19)
-
eq
@NotNull @Support @NotNull Condition eq(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for equality.- See Also:
equal(Row19)
-
eq
@NotNull @Support @NotNull Condition eq(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for equality.- See Also:
equal(Row19)
-
eq
@NotNull @Support @NotNull Condition eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for equality.- See Also:
equal(Row19)
-
eq
@NotNull @Support @NotNull Condition eq(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for equality.- See Also:
equal(Row19)
-
eq
@NotNull @Support @NotNull Condition eq(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for equality. -
notEqual
@NotNull @Support @NotNull Condition notEqual(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for non-equality.Row non-equality comparison predicates can be emulated in those databases that do not support such predicates natively:
(A, B) <> (1, 2)is equivalent toNOT(A = 1 AND B = 2) -
notEqual
@NotNull @Support @NotNull Condition notEqual(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for non-equality- See Also:
notEqual(Row19)
-
notEqual
@NotNull @Support @NotNull Condition notEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for. non-equality- See Also:
notEqual(Row19)
-
notEqual
@NotNull @Support @NotNull Condition notEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for non-equality.- See Also:
notEqual(Row19)
-
notEqual
@NotNull @Support @NotNull Condition notEqual(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for non-equality.- See Also:
notEqual(Row19)
-
notEqual
@NotNull @Support @NotNull Condition notEqual(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for non-equality. -
ne
@NotNull @Support @NotNull Condition ne(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for non-equality.- See Also:
notEqual(Row19)
-
ne
@NotNull @Support @NotNull Condition ne(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for non-equality.- See Also:
notEqual(Row19)
-
ne
@NotNull @Support @NotNull Condition ne(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for non-equality.- See Also:
notEqual(Row19)
-
ne
@NotNull @Support @NotNull Condition ne(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for non-equality.- See Also:
notEqual(Row19)
-
ne
@NotNull @Support @NotNull Condition ne(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for non-equality.- See Also:
notEqual(Row19)
-
ne
@NotNull @Support @NotNull Condition ne(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for non-equality. -
isDistinctFrom
@NotNull @Support @NotNull Condition isDistinctFrom(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for distinctness. -
isDistinctFrom
@NotNull @Support @NotNull Condition isDistinctFrom(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with another row value expression for distinctness. -
isDistinctFrom
@NotNull @Support @NotNull Condition isDistinctFrom(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for distinctness. -
isDistinctFrom
@NotNull @Support @NotNull Condition isDistinctFrom(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for distinctness. -
isDistinctFrom
@NotNull @Support @NotNull Condition isDistinctFrom(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with another row value expression for distinctness. -
isNotDistinctFrom
@NotNull @Support @NotNull Condition isNotDistinctFrom(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for distinctness. -
isNotDistinctFrom
@NotNull @Support @NotNull Condition isNotDistinctFrom(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with another row value expression for distinctness. -
isNotDistinctFrom
@NotNull @Support @NotNull Condition isNotDistinctFrom(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for distinctness. -
isNotDistinctFrom
@NotNull @Support @NotNull Condition isNotDistinctFrom(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for distinctness. -
isNotDistinctFrom
@NotNull @Support @NotNull Condition isNotDistinctFrom(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with another row value expression for distinctness. -
lessThan
@NotNull @Support @NotNull Condition lessThan(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for order.Row order comparison predicates can be emulated in those databases that do not support such predicates natively:
(A, B, C) < (1, 2, 3)is equivalent toA < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2 AND C < 3) -
lessThan
@NotNull @Support @NotNull Condition lessThan(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for order.- See Also:
lessThan(Row19)
-
lessThan
@NotNull @Support @NotNull Condition lessThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for order.- See Also:
lessThan(Row19)
-
lessThan
@NotNull @Support @NotNull Condition lessThan(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for order.- See Also:
lessThan(Row19)
-
lessThan
@NotNull @Support @NotNull Condition lessThan(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.- See Also:
lessThan(Row19)
-
lessThan
@NotNull @Support @NotNull Condition lessThan(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order. -
lt
@NotNull @Support @NotNull Condition lt(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for order.- See Also:
lessThan(Row19)
-
lt
@NotNull @Support @NotNull Condition lt(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for order.- See Also:
lessThan(Row19)
-
lt
@NotNull @Support @NotNull Condition lt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for order.- See Also:
lessThan(Row19)
-
lt
@NotNull @Support @NotNull Condition lt(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for order.- See Also:
lessThan(Row19)
-
lt
@NotNull @Support @NotNull Condition lt(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.- See Also:
lessThan(Row19)
-
lt
@NotNull @Support @NotNull Condition lt(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order. -
lessOrEqual
@NotNull @Support @NotNull Condition lessOrEqual(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for order.Row order comparison predicates can be emulated in those databases that do not support such predicates natively:
(A, B) <= (1, 2)is equivalent toA < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2) -
lessOrEqual
@NotNull @Support @NotNull Condition lessOrEqual(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for order.- See Also:
lessOrEqual(Row19)
-
lessOrEqual
@NotNull @Support @NotNull Condition lessOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for order.- See Also:
lessOrEqual(Row19)
-
lessOrEqual
@NotNull @Support @NotNull Condition lessOrEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for order.- See Also:
lessOrEqual(Row19)
-
lessOrEqual
@NotNull @Support @NotNull Condition lessOrEqual(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.- See Also:
lessOrEqual(Row19)
-
lessOrEqual
@NotNull @Support @NotNull Condition lessOrEqual(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order. -
le
@NotNull @Support @NotNull Condition le(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for order.- See Also:
lessOrEqual(Row19)
-
le
@NotNull @Support @NotNull Condition le(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for order.- See Also:
lessOrEqual(Row19)
-
le
@NotNull @Support @NotNull Condition le(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for order.- See Also:
lessOrEqual(Row19)
-
le
@NotNull @Support @NotNull Condition le(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for order.- See Also:
lessOrEqual(Row19)
-
le
@NotNull @Support @NotNull Condition le(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.- See Also:
lessOrEqual(Row19)
-
le
@NotNull @Support @NotNull Condition le(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order. -
greaterThan
@NotNull @Support @NotNull Condition greaterThan(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for order.Row order comparison predicates can be emulated in those databases that do not support such predicates natively:
(A, B, C) > (1, 2, 3)is equivalent toA > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2 AND C > 3) -
greaterThan
@NotNull @Support @NotNull Condition greaterThan(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for order.- See Also:
greaterThan(Row19)
-
greaterThan
@NotNull @Support @NotNull Condition greaterThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for order.- See Also:
greaterThan(Row19)
-
greaterThan
@NotNull @Support @NotNull Condition greaterThan(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for order.- See Also:
greaterThan(Row19)
-
greaterThan
@NotNull @Support @NotNull Condition greaterThan(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.- See Also:
greaterThan(Row19)
-
greaterThan
@NotNull @Support @NotNull Condition greaterThan(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order. -
gt
@NotNull @Support @NotNull Condition gt(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for order.- See Also:
greaterThan(Row19)
-
gt
@NotNull @Support @NotNull Condition gt(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for order.- See Also:
greaterThan(Row19)
-
gt
@NotNull @Support @NotNull Condition gt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for order.- See Also:
greaterThan(Row19)
-
gt
@NotNull @Support @NotNull Condition gt(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for order.- See Also:
greaterThan(Row19)
-
gt
@NotNull @Support @NotNull Condition gt(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.- See Also:
greaterThan(Row19)
-
gt
@NotNull @Support @NotNull Condition gt(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order. -
greaterOrEqual
@NotNull @Support @NotNull Condition greaterOrEqual(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for order.Row order comparison predicates can be emulated in those databases that do not support such predicates natively:
(A, B) >= (1, 2)is equivalent toA > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2) -
greaterOrEqual
@NotNull @Support @NotNull Condition greaterOrEqual(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for order.- See Also:
greaterOrEqual(Row19)
-
greaterOrEqual
@NotNull @Support @NotNull Condition greaterOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for order.- See Also:
greaterOrEqual(Row19)
-
greaterOrEqual
@NotNull @Support @NotNull Condition greaterOrEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for order.- See Also:
greaterOrEqual(Row19)
-
greaterOrEqual
@NotNull @Support @NotNull Condition greaterOrEqual(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.- See Also:
greaterOrEqual(Row19)
-
greaterOrEqual
@NotNull @Support @NotNull Condition greaterOrEqual(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order. -
ge
@NotNull @Support @NotNull Condition ge(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Compare this row value expression with another row value expression for order.- See Also:
greaterOrEqual(Row19)
-
ge
@NotNull @Support @NotNull Condition ge(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Compare this row value expression with a record for order.- See Also:
greaterOrEqual(Row19)
-
ge
@NotNull @Support @NotNull Condition ge(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Compare this row value expression with another row value expression for order.- See Also:
greaterOrEqual(Row19)
-
ge
@NotNull @Support @NotNull Condition ge(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Compare this row value expression with another row value expression for order.- See Also:
greaterOrEqual(Row19)
-
ge
@NotNull @Support @NotNull Condition ge(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order.- See Also:
greaterOrEqual(Row19)
-
ge
@NotNull @Support @NotNull Condition ge(QuantifiedSelect<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for order. -
between
@NotNull @Support @NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16, T17 minValue17, T18 minValue18, T19 minValue19)Check if this row value expression is within a range of two other row value expressions.- See Also:
between(Row19, Row19)
-
between
@NotNull @Support @NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16, Field<T17> minValue17, Field<T18> minValue18, Field<T19> minValue19)Check if this row value expression is within a range of two other row value expressions.- See Also:
between(Row19, Row19)
-
between
@NotNull @Support @NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> between(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue)Check if this row value expression is within a range of two other row value expressions.- See Also:
between(Row19, Row19)
-
between
@NotNull @Support @NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> between(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue)Check if this row value expression is within a range of two records.- See Also:
between(Row19, Row19)
-
between
@NotNull @Support @NotNull Condition between(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue, Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)Check if this row value expression is within a range of two other row value expressions.This is the same as calling
between(minValue).and(maxValue)The expression
A BETWEEN B AND Cis equivalent to the expressionA >= B AND A <= Cfor those SQL dialects that do not properly support theBETWEENpredicate for row value expressions -
between
@NotNull @Support @NotNull Condition between(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue, Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)Check if this row value expression is within a range of two records.This is the same as calling
between(minValue).and(maxValue)- See Also:
between(Row19, Row19)
-
betweenSymmetric
@NotNull @Support @NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> betweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16, T17 minValue17, T18 minValue18, T19 minValue19)Check if this row value expression is within a symmetric range of two other row value expressions.- See Also:
betweenSymmetric(Row19, Row19)
-
betweenSymmetric
@NotNull @Support @NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> betweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16, Field<T17> minValue17, Field<T18> minValue18, Field<T19> minValue19)Check if this row value expression is within a symmetric range of two other row value expressions.- See Also:
betweenSymmetric(Row19, Row19)
-
betweenSymmetric
@NotNull @Support @NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> betweenSymmetric(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue)Check if this row value expression is within a symmetric range of two other row value expressions.- See Also:
betweenSymmetric(Row19, Row19)
-
betweenSymmetric
@NotNull @Support @NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> betweenSymmetric(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue)Check if this row value expression is within a symmetric range of two records.- See Also:
betweenSymmetric(Row19, Row19)
-
betweenSymmetric
@NotNull @Support @NotNull Condition betweenSymmetric(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue, Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)Check if this row value expression is within a symmetric range of two other row value expressions.This is the same as calling
betweenSymmetric(minValue).and(maxValue)The expression
A BETWEEN SYMMETRIC B AND Cis equivalent to the expression(A >= B AND A <= C) OR (A >= C AND A <= B)for those SQL dialects that do not properly support theBETWEENpredicate for row value expressions -
betweenSymmetric
@NotNull @Support @NotNull Condition betweenSymmetric(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue, Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)Check if this row value expression is within a symmetric range of two records.This is the same as calling
betweenSymmetric(minValue).and(maxValue)- See Also:
betweenSymmetric(Row19, Row19)
-
notBetween
@NotNull @Support @NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> notBetween(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16, T17 minValue17, T18 minValue18, T19 minValue19)Check if this row value expression is not within a range of two other row value expressions.- See Also:
between(Row19, Row19)
-
notBetween
@NotNull @Support @NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> notBetween(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16, Field<T17> minValue17, Field<T18> minValue18, Field<T19> minValue19)Check if this row value expression is not within a range of two other row value expressions.- See Also:
notBetween(Row19, Row19)
-
notBetween
@NotNull @Support @NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> notBetween(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue)Check if this row value expression is not within a range of two other row value expressions.- See Also:
notBetween(Row19, Row19)
-
notBetween
@NotNull @Support @NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> notBetween(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue)Check if this row value expression is within a range of two records.- See Also:
notBetween(Row19, Row19)
-
notBetween
@NotNull @Support @NotNull Condition notBetween(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue, Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)Check if this row value expression is not within a range of two other row value expressions.This is the same as calling
notBetween(minValue).and(maxValue)The expression
A NOT BETWEEN B AND Cis equivalent to the expressionA < B OR A > Cfor those SQL dialects that do not properly support theBETWEENpredicate for row value expressions -
notBetween
@NotNull @Support @NotNull Condition notBetween(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue, Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)Check if this row value expression is within a range of two records.This is the same as calling
notBetween(minValue).and(maxValue)- See Also:
notBetween(Row19, Row19)
-
notBetweenSymmetric
@NotNull @Support @NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> notBetweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16, T17 minValue17, T18 minValue18, T19 minValue19)Check if this row value expression is not within a symmetric range of two other row value expressions.- See Also:
notBetweenSymmetric(Row19, Row19)
-
notBetweenSymmetric
@NotNull @Support @NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> notBetweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16, Field<T17> minValue17, Field<T18> minValue18, Field<T19> minValue19)Check if this row value expression is not within a symmetric range of two other row value expressions.- See Also:
notBetweenSymmetric(Row19, Row19)
-
notBetweenSymmetric
@NotNull @Support @NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> notBetweenSymmetric(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue)Check if this row value expression is not within a symmetric range of two other row value expressions.- See Also:
notBetweenSymmetric(Row19, Row19)
-
notBetweenSymmetric
@NotNull @Support @NotNull BetweenAndStep19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> notBetweenSymmetric(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue)Check if this row value expression is not within a symmetric range of two records.- See Also:
notBetweenSymmetric(Row19, Row19)
-
notBetweenSymmetric
@NotNull @Support @NotNull Condition notBetweenSymmetric(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue, Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)Check if this row value expression is not within a symmetric range of two other row value expressions.This is the same as calling
notBetweenSymmetric(minValue).and(maxValue)The expression
A NOT BETWEEN SYMMETRIC B AND Cis equivalent to the expression(A < B OR A > C) AND (A < C OR A > B)for those SQL dialects that do not properly support theBETWEENpredicate for row value expressions -
notBetweenSymmetric
@NotNull @Support @NotNull Condition notBetweenSymmetric(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> minValue, Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> maxValue)Check if this row value expression is not within a symmetric range of two records.This is the same as calling
notBetweenSymmetric(minValue).and(maxValue)- See Also:
notBetweenSymmetric(Row19, Row19)
-
in
@NotNull @Support @NotNull Condition in(Collection<? extends Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> rows)Compare this row value expression with a set of row value expressions for equality.Row IN predicates can be emulated in those databases that do not support such predicates natively:
(A, B) IN ((1, 2), (3, 4))is equivalent to((A, B) = (1, 2)) OR ((A, B) = (3, 4)), which is equivalent to(A = 1 AND B = 2) OR (A = 3 AND B = 4)Note that generating dynamic SQL with arbitrary-length
INpredicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE). In order to prevent such problems, you could useSettings.isInListPadding()to produce less distinct SQL strings (see also [#5600]), or you could avoidINlists, and replace them with:INpredicates on temporary tablesINpredicates on unnested array bind variables
-
in
@NotNull @Support @NotNull Condition in(Result<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> result)Compare this row value expression with a set of records for equality.Row IN predicates can be emulated in those databases that do not support such predicates natively:
(A, B) IN ((1, 2), (3, 4))is equivalent to((A, B) = (1, 2)) OR ((A, B) = (3, 4)), which is equivalent to(A = 1 AND B = 2) OR (A = 3 AND B = 4)Note that generating dynamic SQL with arbitrary-length
INpredicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE). In order to prevent such problems, you could useSettings.isInListPadding()to produce less distinct SQL strings (see also [#5600]), or you could avoidINlists, and replace them with:INpredicates on temporary tablesINpredicates on unnested array bind variables
-
in
@NotNull @Support @NotNull Condition in(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>... rows)Compare this row value expression with a set of row value expressions for equality.Note that generating dynamic SQL with arbitrary-length
INpredicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE). In order to prevent such problems, you could useSettings.isInListPadding()to produce less distinct SQL strings (see also [#5600]), or you could avoidINlists, and replace them with:INpredicates on temporary tablesINpredicates on unnested array bind variables
-
in
@NotNull @Support @NotNull Condition in(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>... record)Compare this row value expression with a set of records for equality.Note that generating dynamic SQL with arbitrary-length
INpredicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE). In order to prevent such problems, you could useSettings.isInListPadding()to produce less distinct SQL strings (see also [#5600]), or you could avoidINlists, and replace them with:INpredicates on temporary tablesINpredicates on unnested array bind variables
- See Also:
in(Collection)
-
in
@NotNull @Support @NotNull Condition in(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for equality.- See Also:
in(Collection)
-
notIn
@NotNull @Support @NotNull Condition notIn(Collection<? extends Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> rows)Compare this row value expression with a set of row value expressions for equality.Row NOT IN predicates can be emulated in those databases that do not support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4))is equivalent toNOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is equivalent toNOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))Note that generating dynamic SQL with arbitrary-length
NOT INpredicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE). In order to prevent such problems, you could useSettings.isInListPadding()to produce less distinct SQL strings (see also [#5600]), or you could avoidINlists, and replace them with:NOT INpredicates on temporary tablesNOT INpredicates on unnested array bind variables
-
notIn
@NotNull @Support @NotNull Condition notIn(Result<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> result)Compare this row value expression with a set of records for equality.Row NOT IN predicates can be emulated in those databases that do not support such predicates natively:
(A, B) NOT IN ((1, 2), (3, 4))is equivalent toNOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is equivalent toNOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))Note that generating dynamic SQL with arbitrary-length
NOT INpredicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE). In order to prevent such problems, you could useSettings.isInListPadding()to produce less distinct SQL strings (see also [#5600]), or you could avoidINlists, and replace them with:NOT INpredicates on temporary tablesNOT INpredicates on unnested array bind variables
-
notIn
@NotNull @Support @NotNull Condition notIn(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>... rows)Compare this row value expression with a set of row value expressions for equality.Note that generating dynamic SQL with arbitrary-length
NOT INpredicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE). In order to prevent such problems, you could useSettings.isInListPadding()to produce less distinct SQL strings (see also [#5600]), or you could avoidINlists, and replace them with:NOT INpredicates on temporary tablesNOT INpredicates on unnested array bind variables
-
notIn
@NotNull @Support @NotNull Condition notIn(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>... record)Compare this row value expression with a set of records for non-equality.Note that generating dynamic SQL with arbitrary-length
NOT INpredicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g.SQLDialect.ORACLE). In order to prevent such problems, you could useSettings.isInListPadding()to produce less distinct SQL strings (see also [#5600]), or you could avoidINlists, and replace them with:NOT INpredicates on temporary tablesNOT INpredicates on unnested array bind variables
- See Also:
notIn(Collection)
-
notIn
@NotNull @Support @NotNull Condition notIn(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> select)Compare this row value expression with a subselect for non-equality.- See Also:
notIn(Collection)
-
set
@NotNull @Support({AURORA_POSTGRES,DB2,EXASOL,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER}) @NotNull Statement set(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> row)Assign a value to this set of variables. -
set
@NotNull @Support({AURORA_POSTGRES,DB2,EXASOL,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER}) @NotNull Statement set(Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> record)Assign a value to this set of variables. -
set
@NotNull @Support({AURORA_POSTGRES,DB2,EXASOL,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER}) @NotNull Statement set(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19)Assign a value to this set of variables. -
set
@NotNull @Support({AURORA_POSTGRES,DB2,EXASOL,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER}) @NotNull Statement set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19)Assign a value to this set of variables. -
set
@NotNull @Support({AURORA_POSTGRES,DB2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER}) @NotNull Statement set(Select<? extends Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> value)Assign a value to this set of variables.
-