#23753: Provide a set of SQL functions
-------------------------------------+-------------------------------------
     Reporter:  jarshwah             |                    Owner:  jarshwah
         Type:  New feature          |                   Status:  new
    Component:  Database layer       |                  Version:  master
  (models, ORM)                      |
     Severity:  Release blocker      |               Resolution:
     Keywords:  expressions          |             Triage Stage:  Accepted
    Has patch:  0                    |      Needs documentation:  0
  Needs tests:  0                    |  Patch needs improvement:  0
Easy pickings:  0                    |                    UI/UX:  0
-------------------------------------+-------------------------------------

Comment (by jarshwah):

 The problem here is that NCLOB (TextField) and NCHAR (CharField) are too
 different in Oracle terms, so the output of the expression with regards to
 Oracle is not defined.

 We should be able to solve this by wrapping CharField parts of the
 expression in a TO_NCLOB(). If determining whether or not something is a
 CharField is too difficult, then we can just wrap each expression part
 inside a TO_NCLOB if self.output_field is a TextField.

 I'll also add some additional tests which combine CharFields and
 TextFields, where the CharFields are other expressions - like
 Lower('charfield').

--
Ticket URL: <https://code.djangoproject.com/ticket/23753#comment:9>
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/066.180a82ab48ced4d9f820664bc6ec9ccb%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to