Hi,
I'm evaluating jOOQ pro trial 3.14.11. I'm playing with it without to use
code generator. Using fetch.intoMap("author.id") produces:
java.lang.IllegalArgumentException: Field (null) is not contained in Row
("author"."id", "author"."first_name", "author"."last_name", "book"."id",
"book"."author_id", "book"."name", "book"."pubshing_date")
The RDBMS used is MariaDB. The piece of code is:
SelectFinalStep<Record> select = dslContext.select()
.from(table("author")
.join(table("book"))
.on(field("book.author_id")
.eq(field("author.id"))))
.where(field("book.author_id")
.eq(1));
select.fetch().intoMap("author.id");
Using select.fetch().intoMap("id") generates a warning that field "id" is
ambiguous because the table "book" uses it as well:
INFO: Ambiguous match found for id. Both "author"."id" and "book"."id"
match.
What is the right proceeding here?
Best regards.
Boris
--
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/9c11fa4c-a325-4bd3-8784-54989d926c26n%40googlegroups.com.
