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 32203 Error with values with JSON path lookup in Sqlite when value is numeric. Gordon Wrigley nobody "This Django 3.1.3, I only see this with Sqlite, it works fine with MySQL and Postgres. When I do a path lookup with values like `Bob.objects.values(""my_json_field__position"")` if there is an integer, float or bool in ""position"" then I get a JSON decode error. Strings, nones, dicts and lists all work, fetching the top level dict works and filtering on the path lookup works. `TypeError: the JSON object must be str, bytes or bytearray, not float` {{{ ..\..\.venv\data_browser\lib\site-packages\django\db\models\query.py:287: in __iter__ self._fetch_all() ..\..\.venv\data_browser\lib\site-packages\django\db\models\query.py:1308: in _fetch_all self._result_cache = list(self._iterable_class(self)) ..\..\.venv\data_browser\lib\site-packages\django\db\models\query.py:111: in __iter__ for row in compiler.results_iter(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size): ..\..\.venv\data_browser\lib\site-packages\django\db\models\sql\compiler.py:1100: in apply_converters value = converter(value, expression, connection) ..\..\.venv\data_browser\lib\site-packages\django\db\models\fields\json.py:79: in from_db_value return json.loads(value, cls=self.decoder) }}} Queries that produce strings or None's seem to work fine." Uncategorized new Uncategorized 3.1 Normal Unreviewed 0 0 0 0 0 0