Method accept

jOOQ/src/main/java/org/jooq/impl/RowIsDistinctFrom.java:139–219

(Context<?> ctx)

    }

    @Override
    public final void accept(Context<?> ctx) {

        // [#3511]         These dialects need to emulate the IS DISTINCT FROM predicate,
        //                 optimally using INTERSECT...
        // [#7222] [#7224] Make sure the columns are aliased
        // [#10178]        Special treatment for DISTINCT with subqueries
        if (EMULATE_DISTINCT.contains(ctx.dialect()) || rhsSelect != null && EMULATE_DISTINCT_SELECT.contains(ctx.dialect())) {
            Select<Record> intersect = select(lhs.fields()).intersect(rhsSelect != null ? rhsSelect : select(rhsRow.fields()));
            ctx.visit(not ? exists(intersect) : notExists(intersect));
        }

        // [#17057] When INTERSECT isn't available, just use UNION with OFFSET
        else if (EMULATE_WITH_UNION.contains(ctx.dialect())) {
            Select<Record> union = select(lhs.fields()).union(rhsSelect != null ? rhsSelect : select(rhsRow.fields())).offset(one());
            ctx.visit(not ? notExists(union) : exists(union));
        }

        // MySQL knows the <=> operator
        else if (SUPPORT_DISTINCT_WITH_ARROW.contains(ctx.dialect())) {
            if (!not)
                ctx.visit(K_NOT).sql('(');

            ctx.visit(lhs).sql(" <=> ");

            if (rhsRow != null)
                ctx.visit(rhsRow);
            else
                visitSubquery(ctx, rhsSelect, PREDICAND);

            if (!not)
                ctx.sql(')');
        }

        else if (EMULATE_WITH_ARRAYS.contains(ctx.dialect())) {
            ctx.visit(
                function(N_arrayUniq, INTEGER,
                    array(
                        lhs,
                        rhsRow != null ? rhsRow : CustomField.of(NQ_SELECT, SQLDataType.RECORD, c -> visitSubquery(c, rhsSelect, PREDICAND))
                    )
                ).eq(inline(not ? 1 : 2))
            );
        }

        // SQLite knows the IS / IS NOT predicate
        else if (SQLITE == ctx.family()) {
            ctx.visit(lhs).sql(' ').visit(K_IS).sql(' ');

            if (!not)
                ctx.visit(K_NOT).sql(' ');

            if (rhsRow != null)
                ctx.visit(rhsRow);
            else
                visitSubquery(ctx, rhsSelect, PREDICAND);
        }