Opened 17 years ago

Closed 17 years ago

#3053 closed defect (fixed)

[patch] [boulder-oracle-sprint] Some corrections to the Oracle database backend

Reported by: godri@… Owned by: Adrian Holovaty
Component: Database layer (models, ORM) Version: other branch
Severity: normal Keywords: boulder-oracle-sprint
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

These patches fix some problems related to Oracle backend.

'django_empty_set_in_where.patch': corrects traceback when you add/delete child record in many-to-many relation using Django's admin pages.
Oracle and Postgres do not understand sql command 'select id from table_name where id in ();'. The patch changes the sql command to 'select id from table_name where id in (NULL);'.

'django_clear.patch': some modifications in the management code to fix missing/faulty clear commands (sequences, foreign keys)

All patches are available to django/branches/boulder-oracle-sprint, r4085

Attachments (4)

django_empty_set_in_where.patch (738 bytes ) - added by Zoltan Arokszallasi <godri@…> 17 years ago.
django_clear.patch (2.9 KB ) - added by Zoltan Arokszallasi <godri@…> 17 years ago.
django_weekday.patch (566 bytes ) - added by Zoltan Arokszallasi <godri@…> 17 years ago.
django_unambigous.patch (1.5 KB ) - added by Zoltan Arokszallasi <godri@…> 17 years ago.

Download all attachments as: .zip

Change History (8)

by Zoltan Arokszallasi <godri@…>, 17 years ago

by Zoltan Arokszallasi <godri@…>, 17 years ago

Attachment: django_clear.patch added

comment:1 by ramiro <rm0 _at_ gmx.net>, 17 years ago

Summary: Some corrections to the Oracle database backend[patch] [boulder-oracle-sprint] Some corrections to the Oracle database backend

comment:2 by Zoltan Arokszallasi <godri@…>, 17 years ago

'django_weekday.patch': Django uses weekday parameter during time conversion in file utils/tzinfo.py. As I know this parameter is not absolute necessary for time conversion. Without this patch an error can occure getting history page in Django's admin interface using Oracle backend. (cx_Oracle has no support weekday attribute)

'django_unambigous.patch': Correct possible errors on admin (ORA-00918: column ambiguously defined)

by Zoltan Arokszallasi <godri@…>, 17 years ago

Attachment: django_weekday.patch added

by Zoltan Arokszallasi <godri@…>, 17 years ago

Attachment: django_unambigous.patch added

comment:3 by Simon G. <dev@…>, 17 years ago

Keywords: boulder-oracle-sprint added
Triage Stage: UnreviewedAccepted
Version: SVNother branch

comment:4 by Matt Boersma, 17 years ago

Resolution: fixed
Status: newclosed

(In [4726]) boulder-oracle-sprint: Fixed #3053. Zoltan Arokszallasi contributed several
important patches. Thanks!

Also made Oracle test DB more generous, since we were
hitting INTIAL EXTENT errors trying to run the whole test suite.

Note: See TracTickets for help on using tickets.
Back to Top