it's not a matter of order, it's a matter of how the select gets constructed in the code. I'd still like to see what query presents this "issue" because ideally there shouldn't be problems with the current implementation.
On Wednesday, May 7, 2014 3:35:50 PM UTC+2, Richard wrote: > > Yes, to me in the context of my particular select it was making issue that > the order was not respected. However, as a workaround I can just define my > join as a left join because my join was a one-one relation, but I see that > it could happen I could just not get the proper SQL from my web2py query... > > I guess that the keyed elements in the select() should be collected in a > dict, so the order get loss?? > > Richard > > > On Wed, May 7, 2014 at 4:43 AM, Niphlod <nip...@gmail.com <javascript:>>wrote: > >> there isn't any order defined between left and "normal" joins. >> the exact same select would be created either with >> >> db().select(left=[], join=[]) >> >> or >> >> db().select(join=[], left=[]) >> >> If that's what you're pointing, you're out of luck ^_^ >> >> >> On Tuesday, May 6, 2014 10:19:51 PM UTC+2, Richard wrote: >>> >>> Hello, >>> >>> I just struggle more than I would with this : >>> >>> db(...).select(..., >>> left=[left1, >>> left2, >>> ...], >>> join=join) >>> >>> I would expect that the JOIN be after the LEFT JOINS in SQL generated, >>> since one of my left join was required to be before the join... >>> >>> Is there a reason why web2py change the order of join and left join ? >>> >>> Thanks >>> >>> Richard >>> >>> >>> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >> - http://github.com/web2py/web2py (Source code) >> - https://code.google.com/p/web2py/issues/list (Report Issues) >> --- >> You received this message because you are subscribed to the Google Groups >> "web2py-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to web2py+un...@googlegroups.com <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
