Changes between Initial Version and Version 1 of Ticket #31973, comment 18
- Timestamp:
- Nov 10, 2020, 6:04:51 AM (4 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #31973, comment 18
initial v1 1 1 I don't think this issue is invalid. I have the exact same reproducible problem on a new django project with 3.1.0 vs 3.1.1. 2 2 3 To fix it in the raw sql, you can append `::json` to field you are querying! 3 To fix it in the raw sql, you can append `::json` to field you are querying 4 5 {{{ 6 class Table(models.Model): 7 data = models.JSONField() # jsonb column 8 9 select 10 data::json as data_returned_as_a_dict, 11 data::jsonb as data_broken, 12 data as data_also_broken 13 from 14 app_table 15 }}} 4 16 5 17 3.1.1 really did introduce issues with `jsonb` fields for no good reason that I can see, since simply lying about the type works just fine!