Found that which seems related : https://groups.google.com/d/msg/web2py/qYgMQ3rhf5E/U6TIDKUlBgAJ
And the initial post refered by villas : https://groups.google.com/d/msg/web2py/KpxWh4ikqG8/cDBbhiK_3F8J There is not seems to have any issue being open for this over pyDAL repository Richard On Tue, Feb 27, 2018 at 10:55 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > I review my code and found what happen... > > Somehow this query : > > db()._select(db.table_name.other_table_id, join=db.table_name.on(db. > table_name.other_table_id == db.other_table_name.id)) > > Return (2.14.6) : > > SELECT table_name.other_table_id FROM other_table_name JOIN table_name ON > (table_name.other_table_id = other_table_name.id); > > Now it return (trunk-master and I guess 2.16.1) : > > SELECT "table_name"."other_table_id" FROM "other_table_name" CROSS JOIN " > table_name" JOIN "table_name" ON ("table_name"."other_table_id" = " > other_table_name"."id"); > > > I think there is a bug somewhere (pyDAL??), removing the CROSS JOIN > table_name in red above resolve the issue... > > > > On Tue, Feb 27, 2018 at 10:22 AM, Richard Vézina < > ml.richard.vez...@gmail.com> wrote: > >> git clone --recursive https://github.com/web2py/web2py.git >> >> On Tue, Feb 27, 2018 at 10:20 AM, Richard Vézina < >> ml.richard.vez...@gmail.com> wrote: >> >>> git clone --recursive web2py repo http address >>> >>> On Tue, Feb 27, 2018 at 1:29 AM, pbreit <pbreitenb...@gmail.com> wrote: >>> >>>> Could someone please confirm for me if I can just do a "git pull" or do >>>> I need to do something else to make sure I also get latest DAL? >>>> >>>> -- >>>> 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. >>>> >>> >>> >> > -- 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.