@Generated(value="This class was generated using jOOQ-tools") public interface Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> extends Row
18
.
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.
Modifier and Type | Method and Description |
---|---|
BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
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)
Check if this row value expression is within a range of two other row
value expressions.
|
BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
between(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue)
Check if this row value expression is within a range of two records.
|
Condition |
between(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue,
Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)
Check if this row value expression is within a range of two records.
|
BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
between(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue)
Check if this row value expression is within a range of two other row
value expressions.
|
Condition |
between(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue,
Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)
Check if this row value expression is within a range of two other row
value expressions.
|
BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
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)
Check if this row value expression is within a range of two other row
value expressions.
|
BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
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)
Check if this row value expression is within a symmetric range of two
other row value expressions.
|
BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
betweenSymmetric(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue)
Check if this row value expression is within a symmetric range of two
records.
|
Condition |
betweenSymmetric(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue,
Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)
Check if this row value expression is within a symmetric range of two
records.
|
BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
betweenSymmetric(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue)
Check if this row value expression is within a symmetric range of two
other row value expressions.
|
Condition |
betweenSymmetric(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue,
Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)
Check if this row value expression is within a symmetric range of two
other row value expressions.
|
BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
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)
Check if this row value expression is within a symmetric range of two
other row value expressions.
|
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)
Compare this row value expression with another row value expression
using a dynamic comparator.
|
Condition |
compare(Comparator comparator,
QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
Condition |
compare(Comparator comparator,
Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
Compare this row value expression with a record
using a dynamic comparator.
|
Condition |
compare(Comparator comparator,
Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
Compare this row value expression with another row value expression
using a dynamic comparator.
|
Condition |
compare(Comparator comparator,
Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect
using a dynamic comparator.
|
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)
Compare this row value expression with another row value expression
using a dynamic comparator.
|
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)
Compare this row value expression with another row value expression for
equality.
|
Condition |
eq(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
eq(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
Compare this row value expression with a record for equality.
|
Condition |
eq(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
Compare this row value expression with another row value expression for
equality.
|
Condition |
eq(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for equality.
|
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)
Compare this row value expression with another row value expression for
equality.
|
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)
Compare this row value expression with another row value expression for
equality.
|
Condition |
equal(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for equality.
|
Condition |
equal(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
Compare this row value expression with a record for equality.
|
Condition |
equal(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
Compare this row value expression with another row value expression for
equality.
|
Condition |
equal(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for equality.
|
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)
Compare this row value expression with another row value expression for
equality.
|
Field<T1> |
field1()
Get the first field.
|
Field<T10> |
field10()
Get the tenth field.
|
Field<T11> |
field11()
Get the eleventh field.
|
Field<T12> |
field12()
Get the twelfth field.
|
Field<T13> |
field13()
Get the thirteenth field.
|
Field<T14> |
field14()
Get the fourteenth field.
|
Field<T15> |
field15()
Get the fifteenth field.
|
Field<T16> |
field16()
Get the sixteenth field.
|
Field<T17> |
field17()
Get the seventeenth field.
|
Field<T18> |
field18()
Get the eighteenth field.
|
Field<T2> |
field2()
Get the second field.
|
Field<T3> |
field3()
Get the third field.
|
Field<T4> |
field4()
Get the fourth field.
|
Field<T5> |
field5()
Get the fifth field.
|
Field<T6> |
field6()
Get the sixth field.
|
Field<T7> |
field7()
Get the seventh field.
|
Field<T8> |
field8()
Get the eighth field.
|
Field<T9> |
field9()
Get the ninth field.
|
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)
Compare this row value expression with another row value expression for
order.
|
Condition |
ge(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
Condition |
ge(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
Compare this row value expression with a record for order.
|
Condition |
ge(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
Compare this row value expression with another row value expression for
order.
|
Condition |
ge(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
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)
Compare this row value expression with another row value expression for
order.
|
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)
Compare this row value expression with another row value expression for
order.
|
Condition |
greaterOrEqual(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
Condition |
greaterOrEqual(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
Compare this row value expression with a record for order.
|
Condition |
greaterOrEqual(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
Compare this row value expression with another row value expression for
order.
|
Condition |
greaterOrEqual(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
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)
Compare this row value expression with another row value expression for
order.
|
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)
Compare this row value expression with another row value expression for
order.
|
Condition |
greaterThan(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
Condition |
greaterThan(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
Compare this row value expression with a record for order.
|
Condition |
greaterThan(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
Compare this row value expression with another row value expression for
order.
|
Condition |
greaterThan(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
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)
Compare this row value expression with another row value expression for
order.
|
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)
Compare this row value expression with another row value expression for
order.
|
Condition |
gt(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
Condition |
gt(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
Compare this row value expression with a record for order.
|
Condition |
gt(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
Compare this row value expression with another row value expression for
order.
|
Condition |
gt(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
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)
Compare this row value expression with another row value expression for
order.
|
Condition |
in(java.util.Collection<? extends Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> rows)
Compare this row value expression with a set of row value expressions for
equality.
|
Condition |
in(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>... record)
Compare this row value expression with a set of records for equality.
|
Condition |
in(Result<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
in(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>... rows)
Compare this row value expression with a set of row value expressions for
equality.
|
Condition |
in(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for equality.
|
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)
Compare this row value expression with another row value expression for
order.
|
Condition |
le(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
Condition |
le(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
Compare this row value expression with a record for order.
|
Condition |
le(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
Compare this row value expression with another row value expression for
order.
|
Condition |
le(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
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)
Compare this row value expression with another row value expression for
order.
|
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)
Compare this row value expression with another row value expression for
order.
|
Condition |
lessOrEqual(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
Condition |
lessOrEqual(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
Compare this row value expression with a record for order.
|
Condition |
lessOrEqual(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
Compare this row value expression with another row value expression for
order.
|
Condition |
lessOrEqual(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
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)
Compare this row value expression with another row value expression for
order.
|
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)
Compare this row value expression with another row value expression for
order.
|
Condition |
lessThan(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
Condition |
lessThan(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
Compare this row value expression with a record for order.
|
Condition |
lessThan(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
Compare this row value expression with another row value expression for
order.
|
Condition |
lessThan(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
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)
Compare this row value expression with another row value expression for
order.
|
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)
Compare this row value expression with another row value expression for
order.
|
Condition |
lt(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
Condition |
lt(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
Compare this row value expression with a record for order.
|
Condition |
lt(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
Compare this row value expression with another row value expression for
order.
|
Condition |
lt(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for order.
|
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)
Compare this row value expression with another row value expression for
order.
|
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)
Compare this row value expression with another row value expression for
non-equality.
|
Condition |
ne(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
ne(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
Compare this row value expression with a record for non-equality.
|
Condition |
ne(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
Compare this row value expression with another row value expression for
non-equality.
|
Condition |
ne(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for non-equality.
|
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)
Compare this row value expression with another row value expression for
non-equality.
|
BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
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)
Check if this row value expression is not within a range of two other
row value expressions.
|
BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
notBetween(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue)
Check if this row value expression is within a range of two records.
|
Condition |
notBetween(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue,
Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)
Check if this row value expression is within a range of two records.
|
BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
notBetween(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue)
Check if this row value expression is not within a range of two other
row value expressions.
|
Condition |
notBetween(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue,
Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)
Check if this row value expression is not within a range of two other
row value expressions.
|
BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
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)
Check if this row value expression is not within a range of two other
row value expressions.
|
BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
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)
Check if this row value expression is not within a symmetric range of two
other row value expressions.
|
BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
notBetweenSymmetric(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue)
Check if this row value expression is not within a symmetric range of two
records.
|
Condition |
notBetweenSymmetric(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue,
Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)
Check if this row value expression is not within a symmetric range of two
records.
|
BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
notBetweenSymmetric(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue)
Check if this row value expression is not within a symmetric range of two
other row value expressions.
|
Condition |
notBetweenSymmetric(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue,
Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)
Check if this row value expression is not within a symmetric range of two
other row value expressions.
|
BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
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)
Check if this row value expression is not within a symmetric range of two
other row value expressions.
|
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)
Compare this row value expression with another row value expression for
non-equality.
|
Condition |
notEqual(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for non-equality.
|
Condition |
notEqual(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
Compare this row value expression with a record for non-equality
|
Condition |
notEqual(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
Compare this row value expression with another row value expression for
non-equality.
|
Condition |
notEqual(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for non-equality.
|
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)
Compare this row value expression with another row value expression for.
|
Condition |
notIn(java.util.Collection<? extends Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> rows)
Compare this row value expression with a set of row value expressions for
equality.
|
Condition |
notIn(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>... record)
Compare this row value expression with a set of records for non-equality.
|
Condition |
notIn(Result<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> result)
Compare this row value expression with a set of records for
equality.
|
Condition |
notIn(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>... rows)
Compare this row value expression with a set of row value expressions for
equality.
|
Condition |
notIn(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
Compare this row value expression with a subselect for non-equality.
|
@Support Condition compare(Comparator comparator, Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
See the explicit comparison methods for details. Note, not all
Comparator
types are supported
@Support Condition compare(Comparator comparator, Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
See the explicit comparison methods for details. Note, not all
Comparator
types are supported
@Support 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)
See the explicit comparison methods for details. Note, not all
Comparator
types are supported
@Support 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)
See the explicit comparison methods for details. Note, not all
Comparator
types are supported
@Support Condition compare(Comparator comparator, Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
See the explicit comparison methods for details. Note, not all
Comparator
types are supported
@Support Condition compare(Comparator comparator, QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
See the explicit comparison methods for details. Note, not all
Comparator
types are supported
@Support Condition equal(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
Row equality comparison predicates can be emulated in those databases
that do not support such predicates natively:
(A, B) = (1, 2)
is equivalent to
A = 1 AND B = 2
@Support Condition equal(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
equal(Row18)
@Support 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)
equal(Row18)
@Support 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)
equal(Row18)
@Support Condition equal(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
equal(Row18)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA}) Condition equal(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
@Support Condition eq(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
equal(Row18)
@Support Condition eq(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
equal(Row18)
@Support 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)
equal(Row18)
@Support 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)
equal(Row18)
@Support Condition eq(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
equal(Row18)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA}) Condition eq(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
@Support Condition notEqual(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
Row non-equality comparison predicates can be emulated in those
databases that do not support such predicates natively:
(A, B) <> (1, 2)
is equivalent to
NOT(A = 1 AND B = 2)
@Support Condition notEqual(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
notEqual(Row18)
@Support 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)
notEqual(Row18)
@Support 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)
notEqual(Row18)
@Support Condition notEqual(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
notEqual(Row18)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA}) Condition notEqual(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
@Support Condition ne(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
notEqual(Row18)
@Support Condition ne(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
notEqual(Row18)
@Support 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)
notEqual(Row18)
@Support 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)
notEqual(Row18)
@Support Condition ne(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
notEqual(Row18)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA}) Condition ne(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
@Support Condition lessThan(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
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 to
A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2 AND C < 3)
@Support Condition lessThan(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
lessThan(Row18)
@Support 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)
lessThan(Row18)
@Support 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)
lessThan(Row18)
@Support Condition lessThan(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
lessThan(Row18)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition lessThan(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
@Support Condition lt(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
lessThan(Row18)
@Support Condition lt(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
lessThan(Row18)
@Support 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)
lessThan(Row18)
@Support 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)
lessThan(Row18)
@Support Condition lt(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
lessThan(Row18)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition lt(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
@Support Condition lessOrEqual(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
Row order comparison predicates can be emulated in those
databases that do not support such predicates natively:
(A, B) <= (1, 2)
is equivalent to
A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2)
@Support Condition lessOrEqual(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
lessOrEqual(Row18)
@Support 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)
lessOrEqual(Row18)
@Support 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)
lessOrEqual(Row18)
@Support Condition lessOrEqual(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
lessOrEqual(Row18)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition lessOrEqual(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
@Support Condition le(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
lessOrEqual(Row18)
@Support Condition le(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
lessOrEqual(Row18)
@Support 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)
lessOrEqual(Row18)
@Support 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)
lessOrEqual(Row18)
@Support Condition le(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
lessOrEqual(Row18)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition le(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
@Support Condition greaterThan(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
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 to
A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2 AND C > 3)
@Support Condition greaterThan(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
greaterThan(Row18)
@Support 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)
greaterThan(Row18)
@Support 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)
greaterThan(Row18)
@Support Condition greaterThan(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
greaterThan(Row18)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition greaterThan(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
@Support Condition gt(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
greaterThan(Row18)
@Support Condition gt(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
greaterThan(Row18)
@Support 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)
greaterThan(Row18)
@Support 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)
greaterThan(Row18)
@Support Condition gt(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
greaterThan(Row18)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition gt(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
@Support Condition greaterOrEqual(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
Row order comparison predicates can be emulated in those
databases that do not support such predicates natively:
(A, B) >= (1, 2)
is equivalent to
A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2)
@Support Condition greaterOrEqual(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
greaterOrEqual(Row18)
@Support 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)
greaterOrEqual(Row18)
@Support 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)
greaterOrEqual(Row18)
@Support Condition greaterOrEqual(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
greaterOrEqual(Row18)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition greaterOrEqual(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
@Support Condition ge(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> row)
greaterOrEqual(Row18)
@Support Condition ge(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> record)
greaterOrEqual(Row18)
@Support 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)
greaterOrEqual(Row18)
@Support 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)
greaterOrEqual(Row18)
@Support Condition ge(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
greaterOrEqual(Row18)
@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE}) Condition ge(QuantifiedSelect<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
@Support BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> 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)
between(Row18, Row18)
@Support BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> 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)
between(Row18, Row18)
@Support BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> between(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue)
between(Row18, Row18)
@Support BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> between(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue)
between(Row18, Row18)
@Support Condition between(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue, Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)
This is the same as calling between(minValue).and(maxValue)
The expression A BETWEEN B AND C
is equivalent to the
expression A >= B AND A <= C
for those SQL dialects that do
not properly support the BETWEEN
predicate for row value
expressions
@Support Condition between(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue, Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)
This is the same as calling between(minValue).and(maxValue)
between(Row18, Row18)
@Support BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> 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)
betweenSymmetric(Row18, Row18)
@Support BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> 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)
betweenSymmetric(Row18, Row18)
@Support BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> betweenSymmetric(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue)
betweenSymmetric(Row18, Row18)
@Support BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> betweenSymmetric(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue)
betweenSymmetric(Row18, Row18)
@Support Condition betweenSymmetric(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue, Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)
This is the same as calling betweenSymmetric(minValue).and(maxValue)
The expression A BETWEEN SYMMETRIC B AND C
is equivalent to
the expression (A >= B AND A <= C) OR (A >= C AND A <= B)
for those SQL dialects that do not properly support the
BETWEEN
predicate for row value expressions
@Support Condition betweenSymmetric(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue, Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)
This is the same as calling betweenSymmetric(minValue).and(maxValue)
betweenSymmetric(Row18, Row18)
@Support BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> 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)
between(Row18, Row18)
@Support BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> 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)
notBetween(Row18, Row18)
@Support BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> notBetween(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue)
notBetween(Row18, Row18)
@Support BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> notBetween(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue)
notBetween(Row18, Row18)
@Support Condition notBetween(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue, Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)
This is the same as calling notBetween(minValue).and(maxValue)
The expression A NOT BETWEEN B AND C
is equivalent to the
expression A < B OR A > C
for those SQL dialects that do
not properly support the BETWEEN
predicate for row value
expressions
@Support Condition notBetween(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue, Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)
This is the same as calling notBetween(minValue).and(maxValue)
notBetween(Row18, Row18)
@Support BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> 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)
notBetweenSymmetric(Row18, Row18)
@Support BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> 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)
notBetweenSymmetric(Row18, Row18)
@Support BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> notBetweenSymmetric(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue)
notBetweenSymmetric(Row18, Row18)
@Support BetweenAndStep18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> notBetweenSymmetric(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue)
notBetweenSymmetric(Row18, Row18)
@Support Condition notBetweenSymmetric(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue, Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)
This is the same as calling notBetweenSymmetric(minValue).and(maxValue)
The expression A NOT BETWEEN SYMMETRIC B AND C
is equivalent
to the expression (A < B OR A > C) AND (A < C OR A > B)
for
those SQL dialects that do not properly support the BETWEEN
predicate for row value expressions
@Support Condition notBetweenSymmetric(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> minValue, Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> maxValue)
This is the same as calling notBetweenSymmetric(minValue).and(maxValue)
notBetweenSymmetric(Row18, Row18)
@Support Condition in(java.util.Collection<? extends Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> rows)
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
IN
predicates 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
use Settings.isInListPadding()
to produce less distinct SQL
strings (see also
[#5600]), or you
could avoid IN
lists, and replace them with:
IN
predicates on temporary tablesIN
predicates on unnested array bind variables@Support Condition in(Result<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> result)
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
IN
predicates 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
use Settings.isInListPadding()
to produce less distinct SQL
strings (see also
[#5600]), or you
could avoid IN
lists, and replace them with:
IN
predicates on temporary tablesIN
predicates on unnested array bind variables@Support Condition in(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>... rows)
Note that generating dynamic SQL with arbitrary-length
IN
predicates 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
use Settings.isInListPadding()
to produce less distinct SQL
strings (see also
[#5600]), or you
could avoid IN
lists, and replace them with:
IN
predicates on temporary tablesIN
predicates on unnested array bind variablesin(Collection)
@Support Condition in(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>... record)
Note that generating dynamic SQL with arbitrary-length
IN
predicates 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
use Settings.isInListPadding()
to produce less distinct SQL
strings (see also
[#5600]), or you
could avoid IN
lists, and replace them with:
IN
predicates on temporary tablesIN
predicates on unnested array bind variablesin(Collection)
@Support Condition in(Select<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> select)
in(Collection)
@Support Condition notIn(java.util.Collection<? extends Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> rows)
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 to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4)))
, which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
Note that generating dynamic SQL with arbitrary-length
NOT IN
predicates 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
use Settings.isInListPadding()
to produce less distinct SQL
strings (see also
[#5600]), or you
could avoid IN
lists, and replace them with:
NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variables@Support Condition notIn(Result<? extends Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> result)
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 to
NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4)))
, which is
equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
Note that generating dynamic SQL with arbitrary-length
NOT IN
predicates 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
use Settings.isInListPadding()
to produce less distinct SQL
strings (see also
[#5600]), or you
could avoid IN
lists, and replace them with:
NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variables@Support Condition notIn(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>... rows)
Note that generating dynamic SQL with arbitrary-length
NOT IN
predicates 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
use Settings.isInListPadding()
to produce less distinct SQL
strings (see also
[#5600]), or you
could avoid IN
lists, and replace them with:
NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variablesnotIn(Collection)
@Support Condition notIn(Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>... record)
Note that generating dynamic SQL with arbitrary-length
NOT IN
predicates 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
use Settings.isInListPadding()
to produce less distinct SQL
strings (see also
[#5600]), or you
could avoid IN
lists, and replace them with:
NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variablesnotIn(Collection)
Copyright © 2018. All Rights Reserved.