/* * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. * * Other licenses: * ----------------------------------------------------------------------------- * Commercial licenses for this work are available. These replace the above * ASL 2.0 and offer limited warranties, support, maintenance, and commercial * database integrations. * * For more information, please visit: http://www.jooq.org/licenses * * * * * * * * * * * * * */ package org.jooq; // ... import static org.jooq.SQLDialect.CUBRID; // ... import static org.jooq.SQLDialect.DERBY; import static org.jooq.SQLDialect.FIREBIRD; import static org.jooq.SQLDialect.H2; // ... import static org.jooq.SQLDialect.HSQLDB; // ... import static org.jooq.SQLDialect.MARIADB; import static org.jooq.SQLDialect.MYSQL; // ... import static org.jooq.SQLDialect.POSTGRES; // ... // ... // ... import org.jooq.Comparator; import org.jooq.conf.Settings; import org.jooq.impl.DSL; import java.util.Collection; import javax.annotation.Generated; /** * A model type for a row value expression with degree <code>10</code>. * <p> * 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. * * @author Lukas Eder */ @Generated("This class was generated using jOOQ-tools") public interface Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> extends Row { // ------------------------------------------------------------------------ // Field accessors // ------------------------------------------------------------------------ /** * Get the first field. */ Field<T1> field1(); /** * Get the second field. */ Field<T2> field2(); /** * Get the third field. */ Field<T3> field3(); /** * Get the fourth field. */ Field<T4> field4(); /** * Get the fifth field. */ Field<T5> field5(); /** * Get the sixth field. */ Field<T6> field6(); /** * Get the seventh field. */ Field<T7> field7(); /** * Get the eighth field. */ Field<T8> field8(); /** * Get the ninth field. */ Field<T9> field9(); /** * Get the tenth field. */ Field<T10> field10(); // ------------------------------------------------------------------------ // Generic comparison predicates // ------------------------------------------------------------------------ /** * Compare this row value expression with another row value expression * using a dynamic comparator. * <p> * See the explicit comparison methods for details. Note, not all * {@link Comparator} types are supported * * @see #equal(Row10) * @see #notEqual(Row10) * @see #lessThan(Row10) * @see #lessOrEqual(Row10) * @see #greaterThan(Row10) * @see #greaterOrEqual(Row10) */ @Support Condition compare(Comparator comparator, Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row); /** * Compare this row value expression with a record * using a dynamic comparator. * <p> * See the explicit comparison methods for details. Note, not all * {@link Comparator} types are supported * * @see #equal(Record10) * @see #notEqual(Record10) * @see #lessThan(Record10) * @see #lessOrEqual(Record10) * @see #greaterThan(Record10) * @see #greaterOrEqual(Record10) */ @Support Condition compare(Comparator comparator, Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> record); /** * Compare this row value expression with another row value expression * using a dynamic comparator. * <p> * See the explicit comparison methods for details. Note, not all * {@link Comparator} types are supported * * @see #equal(Row10) * @see #notEqual(Row10) * @see #lessThan(Row10) * @see #lessOrEqual(Row10) * @see #greaterThan(Row10) * @see #greaterOrEqual(Row10) */ @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); /** * Compare this row value expression with another row value expression * using a dynamic comparator. * <p> * See the explicit comparison methods for details. Note, not all * {@link Comparator} types are supported * * @see #equal(Row10) * @see #notEqual(Row10) * @see #lessThan(Row10) * @see #lessOrEqual(Row10) * @see #greaterThan(Row10) * @see #greaterOrEqual(Row10) */ @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); /** * Compare this row value expression with a subselect * using a dynamic comparator. * <p> * See the explicit comparison methods for details. Note, not all * {@link Comparator} types are supported * * @see #equal(Select) * @see #notEqual(Select) * @see #lessThan(Select) * @see #lessOrEqual(Select) * @see #greaterThan(Select) * @see #greaterOrEqual(Select) */ @Support Condition compare(Comparator comparator, Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with a subselect * using a dynamic comparator. * <p> * See the explicit comparison methods for details. Note, not all * {@link Comparator} types are supported * * @see #equal(Select) * @see #notEqual(Select) * @see #lessThan(Select) * @see #lessOrEqual(Select) * @see #greaterThan(Select) * @see #greaterOrEqual(Select) */ @Support Condition compare(Comparator comparator, QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); // ------------------------------------------------------------------------ // Equal / Not equal comparison predicates // ------------------------------------------------------------------------ /** * Compare this row value expression with another row value expression for * equality. * <p> * Row equality comparison predicates can be emulated in those databases * that do not support such predicates natively: * <code>(A, B) = (1, 2)</code> is equivalent to * <code>A = 1 AND B = 2</code> */ @Support Condition equal(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row); /** * Compare this row value expression with a record for equality. * * @see #equal(Row10) */ @Support Condition equal(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> record); /** * Compare this row value expression with another row value expression for * equality. * * @see #equal(Row10) */ @Support Condition equal(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10); /** * Compare this row value expression with another row value expression for * equality. * * @see #equal(Row10) */ @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); /** * Compare this row value expression with a subselect for equality. * * @see #equal(Row10) */ @Support Condition equal(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with a subselect for equality. * * @see DSL#all(Field) * @see DSL#all(Select) * @see DSL#all(Object...) * @see DSL#any(Field) * @see DSL#any(Select) * @see DSL#any(Object...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) Condition equal(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with another row value expression for * equality. * * @see #equal(Row10) */ @Support Condition eq(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row); /** * Compare this row value expression with a record for equality. * * @see #equal(Row10) */ @Support Condition eq(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> record); /** * Compare this row value expression with another row value expression for * equality. * * @see #equal(Row10) */ @Support Condition eq(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10); /** * Compare this row value expression with another row value expression for * equality. * * @see #equal(Row10) */ @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); /** * Compare this row value expression with a subselect for equality. * * @see #equal(Row10) */ @Support Condition eq(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with a subselect for equality. * * @see DSL#all(Field) * @see DSL#all(Select) * @see DSL#all(Object...) * @see DSL#any(Field) * @see DSL#any(Select) * @see DSL#any(Object...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) Condition eq(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with another row value expression for * non-equality. * <p> * Row non-equality comparison predicates can be emulated in those * databases that do not support such predicates natively: * <code>(A, B) <> (1, 2)</code> is equivalent to * <code>NOT(A = 1 AND B = 2)</code> */ @Support Condition notEqual(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row); /** * Compare this row value expression with a record for non-equality * * @see #notEqual(Row10) */ @Support Condition notEqual(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> record); /** * Compare this row value expression with another row value expression for. * non-equality * * @see #notEqual(Row10) */ @Support Condition notEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10); /** * Compare this row value expression with another row value expression for * non-equality. * * @see #notEqual(Row10) */ @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); /** * Compare this row value expression with a subselect for non-equality. * * @see #notEqual(Row10) */ @Support Condition notEqual(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with a subselect for non-equality. * * @see DSL#all(Field) * @see DSL#all(Select) * @see DSL#all(Object...) * @see DSL#any(Field) * @see DSL#any(Select) * @see DSL#any(Object...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) Condition notEqual(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with another row value expression for * non-equality. * * @see #notEqual(Row10) */ @Support Condition ne(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row); /** * Compare this row value expression with a record for non-equality. * * @see #notEqual(Row10) */ @Support Condition ne(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> record); /** * Compare this row value expression with another row value expression for * non-equality. * * @see #notEqual(Row10) */ @Support Condition ne(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10); /** * Compare this row value expression with another row value expression for * non-equality. * * @see #notEqual(Row10) */ @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); /** * Compare this row value expression with a subselect for non-equality. * * @see #notEqual(Row10) */ @Support Condition ne(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with a subselect for non-equality. * * @see DSL#all(Field) * @see DSL#all(Select) * @see DSL#all(Object...) * @see DSL#any(Field) * @see DSL#any(Select) * @see DSL#any(Object...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) Condition ne(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); // ------------------------------------------------------------------------ // Ordering comparison predicates // ------------------------------------------------------------------------ /** * Compare this row value expression with another row value expression for * order. * <p> * Row order comparison predicates can be emulated in those * databases that do not support such predicates natively: * <code>(A, B, C) < (1, 2, 3)</code> is equivalent to * <code>A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2 AND C < 3)</code> */ @Support Condition lessThan(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row); /** * Compare this row value expression with a record for order. * * @see #lessThan(Row10) */ @Support Condition lessThan(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> record); /** * Compare this row value expression with another row value expression for * order. * * @see #lessThan(Row10) */ @Support Condition lessThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10); /** * Compare this row value expression with another row value expression for * order. * * @see #lessThan(Row10) */ @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); /** * Compare this row value expression with a subselect for order. * * @see #lessThan(Row10) */ @Support Condition lessThan(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with a subselect for order. * * @see DSL#all(Field) * @see DSL#all(Select) * @see DSL#all(Object...) * @see DSL#any(Field) * @see DSL#any(Select) * @see DSL#any(Object...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) Condition lessThan(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with another row value expression for * order. * * @see #lessThan(Row10) */ @Support Condition lt(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row); /** * Compare this row value expression with a record for order. * * @see #lessThan(Row10) */ @Support Condition lt(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> record); /** * Compare this row value expression with another row value expression for * order. * * @see #lessThan(Row10) */ @Support Condition lt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10); /** * Compare this row value expression with another row value expression for * order. * * @see #lessThan(Row10) */ @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); /** * Compare this row value expression with a subselect for order. * * @see #lessThan(Row10) */ @Support Condition lt(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with a subselect for order. * * @see DSL#all(Field) * @see DSL#all(Select) * @see DSL#all(Object...) * @see DSL#any(Field) * @see DSL#any(Select) * @see DSL#any(Object...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) Condition lt(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with another row value expression for * order. * <p> * Row order comparison predicates can be emulated in those * databases that do not support such predicates natively: * <code>(A, B) <= (1, 2)</code> is equivalent to * <code>A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2)</code> */ @Support Condition lessOrEqual(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row); /** * Compare this row value expression with a record for order. * * @see #lessOrEqual(Row10) */ @Support Condition lessOrEqual(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> record); /** * Compare this row value expression with another row value expression for * order. * * @see #lessOrEqual(Row10) */ @Support Condition lessOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10); /** * Compare this row value expression with another row value expression for * order. * * @see #lessOrEqual(Row10) */ @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); /** * Compare this row value expression with a subselect for order. * * @see #lessOrEqual(Row10) */ @Support Condition lessOrEqual(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with a subselect for order. * * @see DSL#all(Field) * @see DSL#all(Select) * @see DSL#all(Object...) * @see DSL#any(Field) * @see DSL#any(Select) * @see DSL#any(Object...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) Condition lessOrEqual(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with another row value expression for * order. * * @see #lessOrEqual(Row10) */ @Support Condition le(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row); /** * Compare this row value expression with a record for order. * * @see #lessOrEqual(Row10) */ @Support Condition le(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> record); /** * Compare this row value expression with another row value expression for * order. * * @see #lessOrEqual(Row10) */ @Support Condition le(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10); /** * Compare this row value expression with another row value expression for * order. * * @see #lessOrEqual(Row10) */ @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); /** * Compare this row value expression with a subselect for order. * * @see #lessOrEqual(Row10) */ @Support Condition le(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with a subselect for order. * * @see DSL#all(Field) * @see DSL#all(Select) * @see DSL#all(Object...) * @see DSL#any(Field) * @see DSL#any(Select) * @see DSL#any(Object...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) Condition le(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with another row value expression for * order. * <p> * Row order comparison predicates can be emulated in those * databases that do not support such predicates natively: * <code>(A, B, C) > (1, 2, 3)</code> is equivalent to * <code>A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2 AND C > 3)</code> */ @Support Condition greaterThan(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row); /** * Compare this row value expression with a record for order. * * @see #greaterThan(Row10) */ @Support Condition greaterThan(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> record); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterThan(Row10) */ @Support Condition greaterThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterThan(Row10) */ @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); /** * Compare this row value expression with a subselect for order. * * @see #greaterThan(Row10) */ @Support Condition greaterThan(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with a subselect for order. * * @see DSL#all(Field) * @see DSL#all(Select) * @see DSL#all(Object...) * @see DSL#any(Field) * @see DSL#any(Select) * @see DSL#any(Object...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) Condition greaterThan(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterThan(Row10) */ @Support Condition gt(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row); /** * Compare this row value expression with a record for order. * * @see #greaterThan(Row10) */ @Support Condition gt(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> record); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterThan(Row10) */ @Support Condition gt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterThan(Row10) */ @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); /** * Compare this row value expression with a subselect for order. * * @see #greaterThan(Row10) */ @Support Condition gt(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with a subselect for order. * * @see DSL#all(Field) * @see DSL#all(Select) * @see DSL#all(Object...) * @see DSL#any(Field) * @see DSL#any(Select) * @see DSL#any(Object...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) Condition gt(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with another row value expression for * order. * <p> * Row order comparison predicates can be emulated in those * databases that do not support such predicates natively: * <code>(A, B) >= (1, 2)</code> is equivalent to * <code>A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2)</code> */ @Support Condition greaterOrEqual(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row); /** * Compare this row value expression with a record for order. * * @see #greaterOrEqual(Row10) */ @Support Condition greaterOrEqual(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> record); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterOrEqual(Row10) */ @Support Condition greaterOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterOrEqual(Row10) */ @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); /** * Compare this row value expression with a subselect for order. * * @see #greaterOrEqual(Row10) */ @Support Condition greaterOrEqual(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with a subselect for order. * * @see DSL#all(Field) * @see DSL#all(Select) * @see DSL#all(Object...) * @see DSL#any(Field) * @see DSL#any(Select) * @see DSL#any(Object...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) Condition greaterOrEqual(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterOrEqual(Row10) */ @Support Condition ge(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> row); /** * Compare this row value expression with a record for order. * * @see #greaterOrEqual(Row10) */ @Support Condition ge(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> record); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterOrEqual(Row10) */ @Support Condition ge(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10); /** * Compare this row value expression with another row value expression for * order. * * @see #greaterOrEqual(Row10) */ @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); /** * Compare this row value expression with a subselect for order. * * @see #greaterOrEqual(Row10) */ @Support Condition ge(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with a subselect for order. * * @see DSL#all(Field) * @see DSL#all(Select) * @see DSL#all(Object...) * @see DSL#any(Field) * @see DSL#any(Select) * @see DSL#any(Object...) */ @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES }) Condition ge(QuantifiedSelect<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); // ------------------------------------------------------------------------ // [NOT] BETWEEN predicates // ------------------------------------------------------------------------ /** * Check if this row value expression is within a range of two other row * value expressions. * * @see #between(Row10, Row10) */ @Support BetweenAndStep10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10); /** * Check if this row value expression is within a range of two other row * value expressions. * * @see #between(Row10, Row10) */ @Support BetweenAndStep10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> 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); /** * Check if this row value expression is within a range of two other row * value expressions. * * @see #between(Row10, Row10) */ @Support BetweenAndStep10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> between(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> minValue); /** * Check if this row value expression is within a range of two records. * * @see #between(Row10, Row10) */ @Support BetweenAndStep10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> between(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> minValue); /** * Check if this row value expression is within a range of two other row * value expressions. * <p> * This is the same as calling <code>between(minValue).and(maxValue)</code> * <p> * The expression <code>A BETWEEN B AND C</code> is equivalent to the * expression <code>A >= B AND A <= C</code> for those SQL dialects that do * not properly support the <code>BETWEEN</code> predicate for row value * expressions */ @Support Condition between(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> minValue, Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> maxValue); /** * Check if this row value expression is within a range of two records. * <p> * This is the same as calling <code>between(minValue).and(maxValue)</code> * * @see #between(Row10, Row10) */ @Support Condition between(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> minValue, Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> maxValue); /** * Check if this row value expression is within a symmetric range of two * other row value expressions. * * @see #betweenSymmetric(Row10, Row10) */ @Support BetweenAndStep10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> betweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10); /** * Check if this row value expression is within a symmetric range of two * other row value expressions. * * @see #betweenSymmetric(Row10, Row10) */ @Support BetweenAndStep10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> 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); /** * Check if this row value expression is within a symmetric range of two * other row value expressions. * * @see #betweenSymmetric(Row10, Row10) */ @Support BetweenAndStep10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> betweenSymmetric(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> minValue); /** * Check if this row value expression is within a symmetric range of two * records. * * @see #betweenSymmetric(Row10, Row10) */ @Support BetweenAndStep10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> betweenSymmetric(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> minValue); /** * Check if this row value expression is within a symmetric range of two * other row value expressions. * <p> * This is the same as calling <code>betweenSymmetric(minValue).and(maxValue)</code> * <p> * The expression <code>A BETWEEN SYMMETRIC B AND C</code> is equivalent to * the expression <code>(A >= B AND A <= C) OR (A >= C AND A <= B)</code> * for those SQL dialects that do not properly support the * <code>BETWEEN</code> predicate for row value expressions */ @Support Condition betweenSymmetric(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> minValue, Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> maxValue); /** * Check if this row value expression is within a symmetric range of two * records. * <p> * This is the same as calling <code>betweenSymmetric(minValue).and(maxValue)</code> * * @see #betweenSymmetric(Row10, Row10) */ @Support Condition betweenSymmetric(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> minValue, Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> maxValue); /** * Check if this row value expression is not within a range of two other * row value expressions. * * @see #between(Row10, Row10) */ @Support BetweenAndStep10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> notBetween(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10); /** * Check if this row value expression is not within a range of two other * row value expressions. * * @see #notBetween(Row10, Row10) */ @Support BetweenAndStep10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> 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); /** * Check if this row value expression is not within a range of two other * row value expressions. * * @see #notBetween(Row10, Row10) */ @Support BetweenAndStep10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> notBetween(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> minValue); /** * Check if this row value expression is within a range of two records. * * @see #notBetween(Row10, Row10) */ @Support BetweenAndStep10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> notBetween(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> minValue); /** * Check if this row value expression is not within a range of two other * row value expressions. * <p> * This is the same as calling <code>notBetween(minValue).and(maxValue)</code> * <p> * The expression <code>A NOT BETWEEN B AND C</code> is equivalent to the * expression <code>A < B OR A > C</code> for those SQL dialects that do * not properly support the <code>BETWEEN</code> predicate for row value * expressions */ @Support Condition notBetween(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> minValue, Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> maxValue); /** * Check if this row value expression is within a range of two records. * <p> * This is the same as calling <code>notBetween(minValue).and(maxValue)</code> * * @see #notBetween(Row10, Row10) */ @Support Condition notBetween(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> minValue, Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> maxValue); /** * Check if this row value expression is not within a symmetric range of two * other row value expressions. * * @see #notBetweenSymmetric(Row10, Row10) */ @Support BetweenAndStep10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> notBetweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10); /** * Check if this row value expression is not within a symmetric range of two * other row value expressions. * * @see #notBetweenSymmetric(Row10, Row10) */ @Support BetweenAndStep10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> 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); /** * Check if this row value expression is not within a symmetric range of two * other row value expressions. * * @see #notBetweenSymmetric(Row10, Row10) */ @Support BetweenAndStep10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> notBetweenSymmetric(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> minValue); /** * Check if this row value expression is not within a symmetric range of two * records. * * @see #notBetweenSymmetric(Row10, Row10) */ @Support BetweenAndStep10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> notBetweenSymmetric(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> minValue); /** * Check if this row value expression is not within a symmetric range of two * other row value expressions. * <p> * This is the same as calling <code>notBetweenSymmetric(minValue).and(maxValue)</code> * <p> * The expression <code>A NOT BETWEEN SYMMETRIC B AND C</code> is equivalent * to the expression <code>(A < B OR A > C) AND (A < C OR A > B)</code> for * those SQL dialects that do not properly support the <code>BETWEEN</code> * predicate for row value expressions */ @Support Condition notBetweenSymmetric(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> minValue, Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> maxValue); /** * Check if this row value expression is not within a symmetric range of two * records. * <p> * This is the same as calling <code>notBetweenSymmetric(minValue).and(maxValue)</code> * * @see #notBetweenSymmetric(Row10, Row10) */ @Support Condition notBetweenSymmetric(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> minValue, Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> maxValue); // ------------------------------------------------------------------------ // [NOT] DISTINCT predicates // ------------------------------------------------------------------------ // ------------------------------------------------------------------------ // [NOT] IN predicates // ------------------------------------------------------------------------ /** * Compare this row value expression with a set of row value expressions for * equality. * <p> * Row IN predicates can be emulated in those databases that do not support * such predicates natively: <code>(A, B) IN ((1, 2), (3, 4))</code> is * equivalent to <code>((A, B) = (1, 2)) OR ((A, B) = (3, 4))</code>, which * is equivalent to <code>(A = 1 AND B = 2) OR (A = 3 AND B = 4)</code> * <p> * Note that generating dynamic SQL with arbitrary-length * <code>IN</code> predicates can cause cursor cache contention in some * databases that use unique SQL strings as a statement identifier (e.g. * {@link SQLDialect#ORACLE}). In order to prevent such problems, you could * use {@link Settings#isInListPadding()} to produce less distinct SQL * strings (see also * <a href="https://github.com/jOOQ/jOOQ/issues/5600">[#5600]</a>), or you * could avoid <code>IN</code> lists, and replace them with: * <ul> * <li><code>IN</code> predicates on temporary tables</li> * <li><code>IN</code> predicates on unnested array bind variables</li> * </ul> */ @Support Condition in(Collection<? extends Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> rows); /** * Compare this row value expression with a set of records for * equality. * <p> * Row IN predicates can be emulated in those databases that do not support * such predicates natively: <code>(A, B) IN ((1, 2), (3, 4))</code> is * equivalent to <code>((A, B) = (1, 2)) OR ((A, B) = (3, 4))</code>, which * is equivalent to <code>(A = 1 AND B = 2) OR (A = 3 AND B = 4)</code> * <p> * Note that generating dynamic SQL with arbitrary-length * <code>IN</code> predicates can cause cursor cache contention in some * databases that use unique SQL strings as a statement identifier (e.g. * {@link SQLDialect#ORACLE}). In order to prevent such problems, you could * use {@link Settings#isInListPadding()} to produce less distinct SQL * strings (see also * <a href="https://github.com/jOOQ/jOOQ/issues/5600">[#5600]</a>), or you * could avoid <code>IN</code> lists, and replace them with: * <ul> * <li><code>IN</code> predicates on temporary tables</li> * <li><code>IN</code> predicates on unnested array bind variables</li> * </ul> */ @Support Condition in(Result<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> result); /** * Compare this row value expression with a set of row value expressions for * equality. * <p> * Note that generating dynamic SQL with arbitrary-length * <code>IN</code> predicates can cause cursor cache contention in some * databases that use unique SQL strings as a statement identifier (e.g. * {@link SQLDialect#ORACLE}). In order to prevent such problems, you could * use {@link Settings#isInListPadding()} to produce less distinct SQL * strings (see also * <a href="https://github.com/jOOQ/jOOQ/issues/5600">[#5600]</a>), or you * could avoid <code>IN</code> lists, and replace them with: * <ul> * <li><code>IN</code> predicates on temporary tables</li> * <li><code>IN</code> predicates on unnested array bind variables</li> * </ul> * * @see #in(Collection) */ @Support Condition in(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>... rows); /** * Compare this row value expression with a set of records for equality. * <p> * Note that generating dynamic SQL with arbitrary-length * <code>IN</code> predicates can cause cursor cache contention in some * databases that use unique SQL strings as a statement identifier (e.g. * {@link SQLDialect#ORACLE}). In order to prevent such problems, you could * use {@link Settings#isInListPadding()} to produce less distinct SQL * strings (see also * <a href="https://github.com/jOOQ/jOOQ/issues/5600">[#5600]</a>), or you * could avoid <code>IN</code> lists, and replace them with: * <ul> * <li><code>IN</code> predicates on temporary tables</li> * <li><code>IN</code> predicates on unnested array bind variables</li> * </ul> * * @see #in(Collection) */ @Support Condition in(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>... record); /** * Compare this row value expression with a subselect for equality. * * @see #in(Collection) */ @Support Condition in(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); /** * Compare this row value expression with a set of row value expressions for * equality. * <p> * Row NOT IN predicates can be emulated in those databases that do not * support such predicates natively: * <code>(A, B) NOT IN ((1, 2), (3, 4))</code> is equivalent to * <code>NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4)))</code>, which is * equivalent to <code>NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))</code> * <p> * Note that generating dynamic SQL with arbitrary-length * <code>NOT IN</code> predicates can cause cursor cache contention in some * databases that use unique SQL strings as a statement identifier (e.g. * {@link SQLDialect#ORACLE}). In order to prevent such problems, you could * use {@link Settings#isInListPadding()} to produce less distinct SQL * strings (see also * <a href="https://github.com/jOOQ/jOOQ/issues/5600">[#5600]</a>), or you * could avoid <code>IN</code> lists, and replace them with: * <ul> * <li><code>NOT IN</code> predicates on temporary tables</li> * <li><code>NOT IN</code> predicates on unnested array bind variables</li> * </ul> */ @Support Condition notIn(Collection<? extends Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> rows); /** * Compare this row value expression with a set of records for * equality. * <p> * Row NOT IN predicates can be emulated in those databases that do not * support such predicates natively: * <code>(A, B) NOT IN ((1, 2), (3, 4))</code> is equivalent to * <code>NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4)))</code>, which is * equivalent to <code>NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))</code> * <p> * Note that generating dynamic SQL with arbitrary-length * <code>NOT IN</code> predicates can cause cursor cache contention in some * databases that use unique SQL strings as a statement identifier (e.g. * {@link SQLDialect#ORACLE}). In order to prevent such problems, you could * use {@link Settings#isInListPadding()} to produce less distinct SQL * strings (see also * <a href="https://github.com/jOOQ/jOOQ/issues/5600">[#5600]</a>), or you * could avoid <code>IN</code> lists, and replace them with: * <ul> * <li><code>NOT IN</code> predicates on temporary tables</li> * <li><code>NOT IN</code> predicates on unnested array bind variables</li> * </ul> */ @Support Condition notIn(Result<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> result); /** * Compare this row value expression with a set of row value expressions for * equality. * <p> * Note that generating dynamic SQL with arbitrary-length * <code>NOT IN</code> predicates can cause cursor cache contention in some * databases that use unique SQL strings as a statement identifier (e.g. * {@link SQLDialect#ORACLE}). In order to prevent such problems, you could * use {@link Settings#isInListPadding()} to produce less distinct SQL * strings (see also * <a href="https://github.com/jOOQ/jOOQ/issues/5600">[#5600]</a>), or you * could avoid <code>IN</code> lists, and replace them with: * <ul> * <li><code>NOT IN</code> predicates on temporary tables</li> * <li><code>NOT IN</code> predicates on unnested array bind variables</li> * </ul> * * @see #notIn(Collection) */ @Support Condition notIn(Row10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>... rows); /** * Compare this row value expression with a set of records for non-equality. * <p> * Note that generating dynamic SQL with arbitrary-length * <code>NOT IN</code> predicates can cause cursor cache contention in some * databases that use unique SQL strings as a statement identifier (e.g. * {@link SQLDialect#ORACLE}). In order to prevent such problems, you could * use {@link Settings#isInListPadding()} to produce less distinct SQL * strings (see also * <a href="https://github.com/jOOQ/jOOQ/issues/5600">[#5600]</a>), or you * could avoid <code>IN</code> lists, and replace them with: * <ul> * <li><code>NOT IN</code> predicates on temporary tables</li> * <li><code>NOT IN</code> predicates on unnested array bind variables</li> * </ul> * * @see #notIn(Collection) */ @Support Condition notIn(Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>... record); /** * Compare this row value expression with a subselect for non-equality. * * @see #notIn(Collection) */ @Support Condition notIn(Select<? extends Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> select); }