id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
31779	Executing complex JSONField queries crashes on MariaDB < 10.2.16	Sage Abdullah	Sage Abdullah	"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
}}}"	Bug	closed	Database layer (models, ORM)	dev	Normal	invalid		Carlton Gibson	Unreviewed	0	0	0	0	0	0