Invalid query is generated: For field=BitField

[fzzylogic]

Hi all, thanks for your work on this. Noticed the below when testing version 2.8.1 with not yet supported Django 3.1.1. However, it works as expected up to version 3.0.10. Just adding this here fwiw or any that misinterpret "Django 2.2 or newer" :-).

models.py:

class Book(models.Model):
    BitField = models.BooleanField(db_column="BitField", default=0)

query:
queryset = Book.objects.filter(BitField=True)

Generated T-SQL (Django 3.1.1):

SELECT TOP 10 dbo.Book.PK, dbo.Book.BitField
FROM dbo.Book
WHERE NOT dbo.Book.BitField

-- For Django up to 3.0.10 the correct T-SQL is generated:
-- ... WHERE dbo.Book.BitField = 0

Error:
An expression of non-boolean type specified in a context where a condition is expected, near 'BitField'.

[MadPepe]

Had the same issue. We had to downgrade to 3.0.10 version of Django and the problem disappeared.

Dependencies (Not working):

• Django==3.1
• django-mssql-backend==2.8.1
• pyodbc==4.0.30

[ecogels]

That issue (and more) is solved in this pull request #64.

[Asdonomar]

Same happen to me but in the User Table for the fields: is_staff, is_active, is_superuser
Django==3.1
django-mssql-backend==2.8.1
pyodbc==4.0.30

[sekar-p]

Issue exists in django3.1.6 also. When we can expect the fixed version in PyPI

[karlkaebnick]

Tested this morning on django3.2 - issue is still present

[sa185383]

Issue still persists with django 3.2 and django-mssql-backend 2.8.1. Has any progress been made to fix this?

[fzzylogic]

Inexplicably (or perhaps explicably), there's an 🅼🆂 fork that doesn't show up in the forks, that addresses this if i'm not mistaken. It also allows setting encoding and decoding for the pyodbc connection among other things.