Support for MySQL straight_join

[kix...@gmail.com]

Hi all,

Is there any support in jooq for generating a STRAIGHT_JOIN clause for MySQL?

Thank you,

Christian

[Lukas Eder]

Hello,

No, we don't currently support this join method out-of-the-box. I have registered a feature request to add support in a future version:

https://github.com/jOOQ/jOOQ/issues/4281

In the mean time, you can use jOOQ's plain SQL templating capabilites for this. E.g.:

DSL.table("{0} straight_join {1} on {2}", LEFT_TABLE, RIGHT_TABLE, predicate);

I hope this helps,

Lukas

--
You received this message because you are subscribed to the Google Groups "jOOQ User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Lukas Eder]

Hmm, in fact, I was talking about T1 STRAIGHT_JOIN T2, which is useful if you want to specify the straight join strategy for only two individual tables. If you want to apply "straight joining" for all your joined tables, you can pass the "STRAIGHT_JOIN" hint to jOOQ's "hint()" clause:

select(A, B, C)

.hint("STRAIGHT_JOIN")

.from(...)

.join(...)

.fetch();

This is already available today

Cheers,

Lukas