Nevermind. I just spotted the problem!
should be a.PROBANDSET_ID
On 08/14/2018 06:33 PM, Rob Sargent wrote:
or am I mis-using the alias in the insert statement
Probandset a = PROBANDSET.as("a");
ctx.insertInto(PROBANDSET_GROUP_MEMBER,
PROBANDSET_GROUP_MEMBER.GROUP_ID,
PROBANDSET_GROUP_MEMBER.MEMBER_ID)
.select(ctx.select(inline(pbsgRec.getId()), a.PROBANDSET.ID)
.from(a)
.where((inline(supersetIds).contains(a.PROBANDS))
.and(a.PEOPLE_ID.eq(peepRec.getId()))))
.execute();
yields
insert into "probandset_group_member" ("group_id", "member_id")
select '83a696be-b2c6-489e-9a5f-9fa1e1a4fa6a', "probandset"."id"
from "probandset" as "a" where (null @> "a"."probands" and
"a"."people_id" = '3ab7f9f9-7114-401f-a11b-99124538e6a7')
with error message from postgres 10.5
; ERROR: invalid reference to FROM-clause entry for table "probandset"
Hint: Perhaps you meant to reference the table alias "a".
Position: 112
I'll worry about the "null" value later...
--
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]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
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].
For more options, visit https://groups.google.com/d/optout.
