#17932: Test suite fails to run under Oracle
---------------------------------+------------------------------------
Reporter: aaugustin | Owner: nobody
Type: Bug | Status: reopened
Component: contrib.admin | Version: master
Severity: Release blocker | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
---------------------------------+------------------------------------
Changes (by vsajip):
* status: closed => reopened
* has_patch: 1 => 0
* resolution: fixed =>
Comment:
Reopened, as the problem is still occurring. I'm getting an error when
syncdb tries to execute the following SQL against Oracle 10g XE:
CREATE OR REPLACE TRIGGER "ADMIN_CHANGELIST_EVENT_TR"
BEFORE INSERT ON "ADMIN_CHANGELIST_EVENT"
FOR EACH ROW
WHEN (new."ID" IS NULL)
BEGIN
SELECT "ADMIN_CHANGELIST_EVENT_SQ".nextval
INTO :new."ID" FROM dual;
END;
The error is
django.db.utils.DatabaseError: ORA-06552: PL/SQL: Compilation unit
analysis terminated
ORA-06553: PLS-320: the declaration of the type of this expression is
incomplete or malformed
This time it's due to a column named 'date', and just to confuse things
further, the column name is accepted for the table creation itself, but
fails for the trigger creation. Adding "db_column='event_date'" to the
relevant model definition caused the failure to disappear.
--
Ticket URL: <https://code.djangoproject.com/ticket/17932#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 post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en.
