#32793: Problem with decimal field when upgrade version -------------------------------------+------------------------------------- Reporter: Mohsen Tamiz | Owner: nobody Type: Bug | Status: new Component: Database layer | Version: 3.2 (models, ORM) | Severity: Release blocker | Resolution: Keywords: decimal | Triage Stage: Accepted Has patch: 0 | Needs documentation: 0 Needs tests: 0 | Patch needs improvement: 0 Easy pickings: 0 | UI/UX: 0 -------------------------------------+------------------------------------- Changes (by Simon Charette):
* severity: Normal => Release blocker * stage: Unreviewed => Accepted Comment: I've not looked into how but we should fix this. I believe it happens to be addressed in MySQL 8.0.21 (relased 2020-07-13) due to implicit casts injections as is likely why it wasn't caught by our test suite https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-21.html > Building on work done in MySQL 8.0.18, the server now performs injection of casts into queries to avoid mismatches when comparing string data types with those of numeric or temporal types; as when comparing numeric and temporal types, the optimizer now adds casting operations in the item tree inside expressions and conditions in which the data type of the argument and the expected data type do not match. This makes queries in which string types are compared with numeric or temporal types equivalent to queries which are compliant with the SQL standard, while maintaining backwards compatibility with previous releases of MySQL. It's not clear to me whether this was broken in 8.0.18 and then resolved in 8.0.21 https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-18.html > MySQL now performs injection of casts into queries to avoid certain data type mismatches; that is, the optimizer now adds casting operations in the item tree inside expressions and conditions in which the data type of the argument and the expected data type do not match. This makes the query as executed equivalent to one which is compliant with the SQL standard while maintaining backwards compatibility with previous releases of MySQL. -- Ticket URL: <https://code.djangoproject.com/ticket/32793#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/063.92e86472ecff875ba6bd091bdccec5a3%40djangoproject.com.