Re: #2473 - 'in' QuerySet operator generates invalid SQL for empty list

2007-01-03 Thread Russell Keith-Magee
On 1/4/07, Gary Wilson <[EMAIL PROTECTED]> wrote: Russell Keith-Magee wrote: > I just tested this on SQLite, and it fails with: > OperationalError: no such column: false Ok, I added a new patch [1] that uses where 0=1 instead of where false. This seems to work with postgresql, mysql, and sqli

Re: #2473 - 'in' QuerySet operator generates invalid SQL for empty list

2007-01-03 Thread Gary Wilson
Russell Keith-Magee wrote: I just tested this on SQLite, and it fails with: OperationalError: no such column: false Ok, I added a new patch [1] that uses where 0=1 instead of where false. This seems to work with postgresql, mysql, and sqlite. [1] http://code.djangoproject.com/attachment/ticke

Re: #2473 - 'in' QuerySet operator generates invalid SQL for empty list

2007-01-02 Thread Russell Keith-Magee
On 12/22/06, Gary Wilson <[EMAIL PROTECTED]> wrote: Russell Keith-Magee wrote: > If you can get some confirmation that this approach works on other > backends, I'll put it in as an interim measure; and if nothing else, > the tests are most helpful - Thanks for those. Installed mysql 5.0.26, an

Re: #2473 - 'in' QuerySet operator generates invalid SQL for empty list

2006-12-21 Thread Gary Wilson
Russell Keith-Magee wrote: If you can get some confirmation that this approach works on other backends, I'll put it in as an interim measure; and if nothing else, the tests are most helpful - Thanks for those. Installed mysql 5.0.26, and the tests passed. --~--~-~--~~

Re: #2473 - 'in' QuerySet operator generates invalid SQL for empty list

2006-12-20 Thread Russell Keith-Magee
On 12/20/06, Gary Wilson <[EMAIL PROTECTED]> wrote: Patch and a few tests added. Can someone please review and test on something other than postgres. http://code.djangoproject.com/ticket/2473 I use postgres myself as well, so I can't help out there. On the face of it, it seems ok, but like

#2473 - 'in' QuerySet operator generates invalid SQL for empty list

2006-12-19 Thread Gary Wilson
Patch and a few tests added. Can someone please review and test on something other than postgres. http://code.djangoproject.com/ticket/2473 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django developers" grou