#24920: Database type NUMERIC with no parameters is not supported
-------------------------------------+-------------------------------------
Reporter: shaib | Owner: nobody
Type: New | Status: new
feature |
Component: Database | Version: master
layer (models, ORM) |
Severity: Normal | Keywords: oracle
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 1 | Needs tests: 1
Patch needs improvement: 0 | Easy pickings: 1
UI/UX: 0 |
-------------------------------------+-------------------------------------
Django's `DecimalField` requires both `max_digits` and `decimal_places`.
Database backends allow them to be dropped, to specify an "unlimited
precision" field.
This leads to bugs in `inspectdb`: On Oracle, a column defined as
`NUMERIC` is inspected as having 0 digits and negative precision; on
Postgresql, it is inspected as having 65535 (a C short -1?) digits and
decimal places, when the [http://www.postgresql.org/docs/9.4/static
/datatype-numeric.html documentation] says you can only explicitly define
up to 1000 decimal places (and even the implicitly defined precision is
only 16383).
Discussion in the context of Oracle (from 2012):
https://groups.google.com/d/topic/django-developers/qSAfzPyqKqw/discussion
(This could be solved more easily by adding a new field type than by
modifying the behavior of the existing `DecimalField`; however, I'm having
a hard time suggesting a name for such a field type, which may be an
indication that it is a bad interface. Besides that decision, this
probably applies as an easy picking).
--
Ticket URL: <https://code.djangoproject.com/ticket/24920>
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 [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/048.a9b9c2861a5d8625529ae3bb6a2e66f7%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
