Warning: Can't synchronize with repository "(default)" (Unsupported version control system "svn": No module named svn). Look in the Trac log for more information.

Ticket #990 (closed defect: wontfix)

Opened 8 years ago

Last modified 7 years ago

RelatedJoin nXn table should have an option for uniqueness

Reported by: anonymous Owned by: anonymous
Priority: normal Milestone:
Component: SQLObject Version: 0.9a6
Severity: normal Keywords:
Cc:

Description

n-to-n relationship intermediate tables created automatically by RelatedJoin?, have no database-level protection against multiple rows that link the end tables. There should be an option (whose default IMHO should be True) that cretes a compound UNIQUE INDEX with the two IDs.

Another 'bug', in my opinion, is that the intermediate table is created without any indexes. If the unique compount index suggested above is not created, at least one of the table rows should have an index, or add an option to do so.

Change History

comment:1 Changed 8 years ago by jorge.vargas

  • Status changed from new to closed
  • Resolution set to wontfix
Note: See TracTickets for help on using tickets.