Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10
Projection rowtype
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
Much like most dialects use only the first set operation subquery's column names and types for the resulting row type, so does jOOQ.
Since jOOQ does not know which row is produced by which union subquery, it cannot disambiguate these rows in case the projection row type isn't exactly identical. As such, the ad-hoc converter in the following example is ignored:
Result<Record1<Integer>> result =
create.select(BOOK.ID)
.from(BOOK)
.union(
// This has no effect
select(AUTHOR.ID.convertFrom(i -> -i))
.from(AUTHOR))
.fetch();
While this can lead to subtle bugs, it makes perfect sense, knowing that a Converter is always applied at the client side of the execution.
Feedback
Do you have any feedback about this page? We'd love to hear it!