Here : https://github.com/web2py/pydal/issues/388
I think the follow up update to the book and change log never occurs... I am fine with patching my code and make sure I don't leave empty query... But I am curious to know if this "CROSS JOIN table_name" addition could be avoid otherwise than providing non empty query... I mean it rough mistake... Richard On Tue, Feb 27, 2018 at 12:39 PM, Richard Vézina < [email protected]> wrote: > @Leonel, I recall about empty query beeing deprecated... But I can't find > any reference to it neither in change log of pyDAL nor web2py change log... > Niether the book... > > Which version of the DAL the support been dropped? > > Richard > > > > On Tue, Feb 27, 2018 at 12:01 PM, Richard Vézina < > [email protected]> wrote: > >> In [6]: db(db.auth_user.id > 0)._select(db.auth_membership.group_id, >> join=db.auth_membership.on(db.auth_user.id == >> db.auth_membership.user_id)) >> Out[6]: 'SELECT "auth_membership"."group_id" FROM "auth_user" JOIN >> "auth_membership" ON ("auth_user"."id" = "auth_membership"."user_id") WHERE >> ("auth_user"."id" > 0);' >> >> Seems to solve it... >> >> >> >> On Tue, Feb 27, 2018 at 11:58 AM, Leonel Câmara <[email protected]> >> wrote: >> >>> I believe we deprecated empty queries as they caused way too many >>> problems and bugs (e.g. common filters don't work). >>> >>> -- >>> 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 [email protected]. >>> 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
