Hmm. I do not know about if there is a documentation. Probable there is some
but I just do not know about this.
I used just 'try and fail' approach:
sn...@nezhdanov:~/VTC/pinger/elixir$ ./console.py
select PINGER_RESULTS.id from PINGER_RESULTS left outer join PINGER_RESULTS
pr1 on PINGER_RESULTS.i
No problem. Better report and check that not check and leave a bug in
there.
Can you explain the fix below? Oracle does not understand AS? Is there
documentation about this somewhere I can reference as a comment to the
fix?
Massimo
On Apr 16, 1:11 am, Alexey Nezhdanov wrote:
> Oh, Massimo, actu
Oh, Massimo, actually I was wrong here again. Sorry for second time
reporting same issue while still not being a bug.
However, I still catched one, related specifically to Oracle.
As it happened, using LEFT JOIN here is more correct as I need empty groups
too. But Oracle chockes with error ORA-0090
Alias was not designed to let you rename tables in arbitrary cases. It
was designed to prevent naming conflicts when you left join the same
table multiple times. It works in this second case. So this should
work
db(db.TEST.id>0). select(TEST.ALL,
b.id.count(),left=b.on(b.top_id==TEST.id))
I agree
4 matches
Mail list logo