Class SelectQueryImpl

jOOQ/src/main/java/org/jooq/impl/SelectQueryImpl.java:356–5867

A sub-select is a SELECT statement that can be combined with other SELECT statement in UNION s and similar operations. @author Lukas Eder

 * @author Lukas Eder
 */
final class SelectQueryImpl<R extends Record>
extends
    AbstractResultQuery<R>
implements
    SelectQuery<R>
{
    private static final JooqLogger      log                                     = JooqLogger.getLogger(SelectQueryImpl.class);
    private static final Clause[]        CLAUSES                                 = { SELECT };
    static final Set<SQLDialect>         EMULATE_SELECT_INTO_AS_CTAS             = SQLDialect.supportedBy(CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB);
    private static final Set<SQLDialect> SUPPORT_SELECT_INTO_TABLE               = SQLDialect.supportedBy(HSQLDB, POSTGRES, YUGABYTEDB);



    static final Set<SQLDialect>         NO_SUPPORT_WINDOW_CLAUSE                = SQLDialect.supportedUntil(CUBRID, DERBY, HSQLDB, IGNITE, MARIADB);
    static final Set<SQLDialect>         NO_SUPPORT_WINDOW_REFINEMENT            = SQLDialect.supportedUntil();
    private static final Set<SQLDialect> REQUIRES_FROM_CLAUSE                    = SQLDialect.supportedUntil(CUBRID, DERBY, FIREBIRD, HSQLDB);
    private static final Set<SQLDialect> REQUIRES_DERIVED_TABLE_DML              = SQLDialect.supportedUntil(MYSQL);
    private static final Set<SQLDialect> NO_IMPLICIT_GROUP_BY_ON_HAVING          = SQLDialect.supportedBy(SQLITE);





















    static final Set<SQLDialect>         SUPPORT_FULL_WITH_TIES                  = SQLDialect.supportedBy(CLICKHOUSE, H2, MARIADB, POSTGRES, TRINO);
    static final Set<SQLDialect>         EMULATE_DISTINCT_ON                     = SQLDialect.supportedBy(DERBY, FIREBIRD, HSQLDB, MARIADB, MYSQL, SQLITE, TRINO);
    static final Set<SQLDialect>         NO_SUPPORT_FOR_UPDATE_OF_FIELDS         = SQLDialect.supportedBy(MYSQL, POSTGRES, YUGABYTEDB);
    static final Set<SQLDialect>         NO_SUPPORT_UNION_ORDER_BY_ALIAS         = SQLDialect.supportedBy(FIREBIRD);
    static final Set<SQLDialect>         NO_SUPPORT_WITH_READ_ONLY               = SQLDialect.supportedBy(CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB);
    static final Set<SQLDialect>         NO_SUPPORT_LIMIT_ZERO                   = SQLDialect.supportedBy(DERBY, HSQLDB);
    static final Set<SQLDialect>         REQUIRES_ORDER_BY_ALIAS_OVERRIDE        = SQLDialect.supportedUntil(CLICKHOUSE, MARIADB, MYSQL, TRINO);
    static final Set<SQLDialect>         WRAP_EXP_BODY_IN_DERIVED_TABLE_LIMIT    = SQLDialect.supportedUntil(CLICKHOUSE);
    static final Set<SQLDialect>         WRAP_EXP_BODY_IN_DERIVED_TABLE_ORDER_BY = SQLDialect.supportedBy(CLICKHOUSE);
    static final Set<SQLDialect>         WRAP_UNION_SUBQ_IN_DERIVED_TABLE_LIMIT  = SQLDialect.supportedBy(FIREBIRD);