[Django] #20015: test_lookup_date_as_str fails under Oracle

[Django]

#20015: test_lookup_date_as_str fails under Oracle
-------------------------------------+-------------------------------------
Reporter: aaugustin | Owner: nobody
Type: Bug | Status: new
Component: Database | Version: master
layer (models, ORM) | Keywords:
Severity: Release | Has patch: 0
blocker | Needs tests: 0
Triage Stage: Accepted | Easy pickings: 0
Needs documentation: 0 |
Patch needs improvement: 0 |
UI/UX: 0 |
-------------------------------------+-------------------------------------
http://ci.djangoproject.com/job/Django%20Oracle/lastCompletedBuild/database=oracle,python=python2.7/testReport/lookup.tests/LookupTests/test_lookup_date_as_str/

--
Ticket URL: <https://code.djangoproject.com/ticket/20015>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#20015: test_lookup_date_as_str fails under Oracle
-------------------------------------+-------------------------------------
Reporter: aaugustin | Owner: nobody
Type: Bug | Status: new

Component: Database layer | Version: master
(models, ORM) | Resolution:
Severity: Release blocker | Triage Stage: Accepted
Keywords: | Needs documentation: 0
Has patch: 0 | Patch needs improvement: 0
Needs tests: 0 | UI/UX: 0
Easy pickings: 0 |
-------------------------------------+-------------------------------------
Changes (by apollo13):

* cc: apollo13 (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/20015#comment:1>

[Django]

#20015: test_lookup_date_as_str fails under Oracle
-------------------------------------+-------------------------------------
Reporter: aaugustin | Owner: nobody
Type: Bug | Status: new

Component: Database layer | Version: master
(models, ORM) | Resolution:
Severity: Release blocker | Triage Stage: Accepted
Keywords: | Needs documentation: 0
Has patch: 0 | Patch needs improvement: 0
Needs tests: 0 | UI/UX: 0
Easy pickings: 0 |
-------------------------------------+-------------------------------------

Changes (by shai):

* cc: shai@… (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/20015#comment:2>

[Django]

#20015: test_lookup_date_as_str fails under Oracle
-------------------------------------+-------------------------------------
Reporter: aaugustin | Owner: nobody
Type: Bug | Status: new

Component: Database layer | Version: master
(models, ORM) | Resolution:
Severity: Release blocker | Triage Stage: Accepted
Keywords: | Needs documentation: 0
Has patch: 0 | Patch needs improvement: 0
Needs tests: 0 | UI/UX: 0
Easy pickings: 0 |
-------------------------------------+-------------------------------------

Comment (by shai):

Reference to anybody working on this: the user code is
{{{
Book.objects.filter(pubdate__startswith='2005')
}}}
and the generated query is
{{{
...
WHERE "SHARED_MODELS_BOOK"."PUBDATE" LIKE TRANSLATE(TO_TIMESTAMP(:arg0,
'YYYY-MM-DD HH24:MI:SS.FF') USING NCHAR_CS) ESCAPE TRANSLATE('\' USING
NCHAR_CS)
}}}
That is, where the user code expects dates to be translated to strings,
the backend tries to translate the string to a date in the middle of all
the string translation operations.

--
Ticket URL: <https://code.djangoproject.com/ticket/20015#comment:3>

[Django]

#20015: test_lookup_date_as_str fails under Oracle
-------------------------------------+-------------------------------------

Reporter: aaugustin | Owner: shai
Type: Bug | Status: assigned

Component: Database layer | Version: master
(models, ORM) | Resolution:
Severity: Release blocker | Triage Stage: Accepted
Keywords: | Needs documentation: 0
Has patch: 0 | Patch needs improvement: 0
Needs tests: 0 | UI/UX: 0
Easy pickings: 0 |
-------------------------------------+-------------------------------------

Changes (by shai):

* status: new => assigned
* owner: nobody => shai

--
Ticket URL: <https://code.djangoproject.com/ticket/20015#comment:4>

[Django]

#20015: test_lookup_date_as_str fails under Oracle
-------------------------------------+-------------------------------------

Reporter: aaugustin | Owner: shai
Type: Bug | Status: closed

Component: Database layer | Version: master

(models, ORM) | Resolution: fixed

Severity: Release blocker | Triage Stage: Accepted
Keywords: | Needs documentation: 0
Has patch: 0 | Patch needs improvement: 0
Needs tests: 0 | UI/UX: 0
Easy pickings: 0 |
-------------------------------------+-------------------------------------

Changes (by Shai Berger <shai@…>):

* status: assigned => closed
* resolution: => fixed

Comment:

In [changeset:"8fd40b9ae783614658f6e0ca7af7f2faab0c48fc"]:
{{{
#!CommitTicketReference repository=""
revision="8fd40b9ae783614658f6e0ca7af7f2faab0c48fc"
Fixed #20015 -- date__startswith('2008') fails under Oracle

Removed the explicit casting of strings to dates
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/20015#comment:5>