#32767: inspectdb and sql non-boolean issues
-------------------------------------+-------------------------------------
Reporter: | Owner: nobody
kinglion580 |
Type: Bug | Status: new
Component: Database | Version: 3.2
layer (models, ORM) |
Severity: Release | Keywords: inspectdb, mssql,
blocker | non-boolean
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
**enviornment:**
python: 3.8
django: 3.2.3
pyodbc: 4.0.03
django-mssql-backend: 2.8.1
I'm sure the database config is correct.
1. when I run: python manage.py inspectdb, it come out issues like this:
{{{
# Unable to inspect table 'AllowList'
# The error was: __new__() missing 1 required positional argument:
'collation'
}}}
ps: when I change django version to 3.1x or 2.x, inspectdb can produce
model.
2. when I use
{{{
filetypes =
Uploadfiletypes.objects.filter(status=True).order_by('filetype')
}}}
it produce this issue:
{{{
('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL
Server]An expression of non-boolean type specified in a context where a
condition is expected, near 'ORDER'. (4145) (SQLExecDirectW)")
}}}
I'm sure status is a boolean field, and True is a boolean type value. when
I change the django version to 2.x, it don't have this issue.
--
Ticket URL: <https://code.djangoproject.com/ticket/32767>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/054.ea0ac2d9d4cba27b323bbd8bfcd2443c%40djangoproject.com.
