#30469: Boolean False becomes NULL with recent mysql-connector-python
-------------------------------------+-------------------------------------
Reporter: squio | Owner: nobody
Type: Bug | Status: new
Component: Database | Version: 2.2
layer (models, ORM) |
Severity: Normal | Keywords:
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
Bug is triggered from Admin / User / Change Password
{{{
Request URL: http://localhost/admin/auth/user/3/password/
Django Version: 2.1.8
Exception Type:
Exception Value: Column 'is_superuser' cannot be null
Exception Location: /usr/local/lib/python3.7/site-
packages/mysql/connector/cursor_cext.py in statement, line 608
Python Executable: /usr/local/bin/python
Python Version: 3.7.3
Python Path:
['/usr/src/app',
'/usr/local/lib/python37.zip',
'/usr/local/lib/python3.7',
'/usr/local/lib/python3.7/lib-dynload',
'/usr/local/lib/python3.7/site-packages']
}}}
Database is Mariadb latest version from dockerhub.
This bug only occurs when using recent mysql-connector-python > 8.0.12
Tested with the following combinations:
Django 2.2.0, 2.2.1, 2.1.8 with mysql-connector-python == 8.0.15
Django 2.2.0 with mysql-connector-python 8.0.15, 8.0.14, 8.0.13
Django 2.2.0 with mysql-connector-python 8.0.16 fails completely (not
further investigated)
Bug is **NOT** triggered with **Django 2.2.1** with mysql-connector-python
**8.0.12** (or 8.0.11)
Further investigation:
The SQL which is used for the successful database update (copied from
django-debug-toolbar) is:
{{{
UPDATE `auth_user` SET `password` = 'pbkdf2_sha256$...', `last_login` =
NULL, `is_superuser` = 0, `username` = 'a', `first_name` = '', `last_name`
= '', `email` = '', `is_staff` = 0, `is_active` = 1, `date_joined` =
'2019-05-09 14:36:09' WHERE `auth_user`.`id` = 3
}}}
The SQL from failed database update (copied from debug web page) is:
{{{
UPDATE `auth_user` SET `password` = 'pbkdf2_sha256$...=', `last_login` =
NULL, `is_superuser` = NULL, `username` = 'a', `first_name` = '',
`last_name` = '', `email` = '', `is_staff` = NULL, `is_active` = True,
`date_joined` = '2019-05-09 14:36:09' WHERE `auth_user`.`id` = 3
}}}
The difference is value 0 (zero) for False (correct) vs NULL for False
(not correct obviously)
The database schema for `auth_user` as created by running the migrations:
{{{
+--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| password | varchar(128) | NO | | NULL | |
| last_login | datetime | YES | | NULL | |
| is_superuser | tinyint(1) | NO | | NULL | |
| username | varchar(150) | NO | UNI | NULL | |
| first_name | varchar(30) | NO | | NULL | |
| last_name | varchar(150) | NO | | NULL | |
| email | varchar(254) | NO | | NULL | |
| is_staff | tinyint(1) | NO | | NULL | |
| is_active | tinyint(1) | NO | | NULL | |
| date_joined | datetime | NO | | NULL | |
+--------------+--------------+------+-----+---------+----------------+
}}}
While this mysql-connector-python version 8.0.12 appears to work I feel
that this is a high risk solution as the
[https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-13.html
changelog for mysql-connector-python] states that this version is updated
for Python 3.7 compatibility.
my pip3 requirements.txt (mysql connector downgraded):
{{{
Django==2.2.1
gunicorn==19.9.0
mysql-connector-python==8.0.12
djangorestframework~=3.9
markdown~=3.1
django-filter~=2.1
django-allauth~=0.39
coreapi==2.3.3
PyYAML==5.1
django-tables2~=2.0
django-debug-toolbar~=1.1
}}}
Database in `settings.py`:
{{{
DATABASES = {
'default': {
'ENGINE': 'mysql.connector.django',
'NAME': os.environ['MYSQL_DATABASE'],
'USER': os.environ['MYSQL_USER'],
'PASSWORD': os.environ['MYSQL_PASSWORD'],
'HOST': os.environ['DB_SERVICE'],
'PORT': os.environ['DB_PORT'],
}
}
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/30469>
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/048.fdf7b5d280108c7acb5649cce18e02fd%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
