Re: Using Aliased tables doesn't seem to match foreign keys.

[henry . liu]

I'm running into the same problem.
I saw the ticket was closed. How was this resolved?

Thanks!


On Sunday, May 27, 2012 11:37:25 AM UTC-4, Lukas Eder wrote:
>
> Thanks for reporting this. This will be fixed as #1460: 
> https://sourceforge.net/apps/trac/jooq/ticket/1460 
>
> Cheers 
> Lukas 
>
> 2012/5/26 john landers <jcl...@gmail.com>: 
> > Assuming there is a only one fkey defined between Book and Author. 
> > Example: 
> > 
> > This works: 
> > Select<Record> select = factory.select() 
> >                                .from(T_BOOK) 
> >                                .leftOuterJoin(T_AUTHOR) 
> >                               
>  .onKey(T_AUTHOR.getReferencesTo(T_BOOK).get(0)); 
> > 
> > But this doesn't: 
> > 
> > TBook book = T_BOOK.as("T1"); 
> > TAuthor author = T_AUTHOR.as("T2"); 
> > 
> > Select<Record> select = factory.select() 
> >                                .from(T1) 
> >                                .leftOuterJoin(T2) 
> >                                .onKey(T2.getReferencesTo(T1).get(0)); 
> > 
>