Hi Thorsten, I'm not aware of an incompatible change in this area.
jOOQ 3.10 introduced a configuration <recordsImplementingRecordN/> https://github.com/jOOQ/jOOQ/issues/6072 This generates record types implementing e.g. Record1<Long>, as would be required in your API usage. By default, it is turned on. Maybe you have turned it off? Otherwise, what's the type of your RdQueryBuilder.CTE_NAME_RE_IDS? Cheers, Lukas On Fri, Jun 5, 2020 at 10:09 PM Thorsten Schöning <[email protected]> wrote: > Hi all, > > I've upgraded to jOOQ 3.13 and the following conditions don't work > anymore: > > > SelectConditionStep<Record3<String, String, Long>> where = joined > > .where(REAL_ESTATE.ID.in > (DSL.selectFrom(RdQueryBuilder.CTE_NAME_RE_IDS)) > > .and(METER.ID.in > (DSL.selectFrom(RdQueryBuilder.CTE_NAME_METER_IDS)))); > > The error message: > > > The method in(Collection<?>) in the type Field<Integer> is not > > applicable for the arguments (SelectWhereStep<Record>) > > "Field" provides the following overload for "in": > > > Condition in(Select<? extends Record1<T>> query); > > That method expects exactly one column only, while "DSL.selectFrom" > can return more in theory. In practice it doesn't in my case and > things worked with 3.11.7 I used before. > > I wasn't able to spot the difference yet, so is that change by purpose > or a mistake? What's the easiest workaround to get the former > behaviour back? > > The problem is that what's referenced are dynamically created CTEs I > don't have columns names for like for other tables. That's why using > "selectFrom" was so easy. > > Thanks for your hints! > > Mit freundlichen Grüßen, > > Thorsten Schöning > > -- > Thorsten Schöning E-Mail: [email protected] > AM-SoFT IT-Systeme http://www.AM-SoFT.de/ > > Telefon...........05151- 9468- 55 > Fax...............05151- 9468- 88 > Mobil..............0178-8 9468- 04 > > AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln > AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/1872157547.20200605220858%40am-soft.de > . > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO4Wb5SqXb6KJeMPitgCcomEHr4rY6wAhr-on7vR10_3bg%40mail.gmail.com.
