#31779: Executing complex JSONField queries crashes on MariaDB < 10.2.16
-------------------------------------+-------------------------------------
Reporter: sage | Owner: sage
Type: Bug | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Description changed by sage:
Old description:
> We explicitly say that JSONField is supported on MariaDB >= 10.2.7.
> However, it seems that there is an upstream bug that causes complex
> JSONField queries to crash: https://jira.mariadb.org/browse/MDEV-16209
>
> I haven't isolated which test(s) caused the crash, but it's reproducible
> by running the tests with MariaDB < 10.2.16. Since this is an upstream
> issue, I think we can just bump the version requirement to 10.2.16 or add
> a warning that some things may not work with MariaDB < 10.2.16.
New description:
We explicitly say that JSONField is supported on MariaDB >= 10.2.7.
However, it seems that there is an upstream bug that causes complex
JSONField queries to crash: https://jira.mariadb.org/browse/MDEV-16209
~~I haven't isolated which test(s) caused the crash~~, but it's
reproducible by running the tests with MariaDB < 10.2.16. Since this is an
upstream issue, I think we can just bump the version requirement to
10.2.16 or add a warning that some things may not work with MariaDB <
10.2.16.
The following tests crash the database server:
{{{
model_fields.test_jsonfield.TestSaveLoad.test_json_null_different_from_sql_null
model_fields.test_jsonfield.TestQuerying.test_exact
model_fields.test_jsonfield.TestQuerying.test_exact_complex
model_fields.test_jsonfield.TestQuerying.test_key_transform_raw_expression
model_fields.test_jsonfield.TestQuerying.test_nested_key_transform_raw_expression
model_fields.test_jsonfield.TestQuerying.test_isnull_key_or_none
model_fields.test_jsonfield.TestQuerying.test_none_key
model_fields.test_jsonfield.TestQuerying.test_none_key_exclude
model_fields.test_jsonfield.TestQuerying.test_shallow_list_lookup
model_fields.test_jsonfield.TestQuerying.test_shallow_obj_lookup
model_fields.test_jsonfield.TestQuerying.test_obj_subquery_lookup
model_fields.test_jsonfield.TestQuerying.test_deep_lookup_objs
model_fields.test_jsonfield.TestQuerying.test_shallow_lookup_obj_target
model_fields.test_jsonfield.TestQuerying.test_deep_lookup_array
model_fields.test_jsonfield.TestQuerying.test_deep_lookup_mixed
model_fields.test_jsonfield.TestQuerying.test_usage_in_subquery
model_fields.test_jsonfield.TestQuerying.test_key_escape
model_fields.test_jsonfield.TestQuerying.test_none_key_and_exact_lookup
}}}
--
--
Ticket URL: <https://code.djangoproject.com/ticket/31779#comment:2>
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 view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/067.5f36c35bf3cdb5cbbc8f70834d874c56%40djangoproject.com.
