Bug 105373

Summary:	Can't define a unique constraint in an association.
Product:	[Retired] Red Hat Web Application Framework	Reporter:	Daniel Berrangé <berrange>
Component:	persistence	Assignee:	ccm-bugs-list
Status:	CLOSED WONTFIX	QA Contact:	Jon Orris <jorris>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	nightly
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2006-09-02 17:23:43 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	108447

Description Daniel Berrangé 2003-09-25 14:55:08 UTC

From Bugzilla Helper:
User-Agent: Mozilla/5.0 Galeon/1.2.9 (X11; Linux i686; U;) Gecko/20030314

Description of problem:
Consider the following association (i've removed the table mappings for
simplification).

association {
    composite AtoZ[0..1] atoz;
    component AtoZProvider[0..n] atozProviders;
    Integer[0..1] sortKey;
}

As a preventative measure against 'Lutterkorts Axiom of Lax Data Models'
striking we need to ensure that for each 'AtoZ' object, the sortKeys for the
associated atozProviders are unique. Thus I add:

unique(atoz, sortKey) 

to the association. This triggers an exception when loading PDL:

    [java] Exception in thread "main" java.lang.Error:
/var/ccm-devel/dev/dan/aplaws-rickshaw/atoz/pdl/com/arsdigita/london/atoz/AtoZProvider.pdl:
Encountered "(" at line 44, column 12.
     [java] Was expecting one of:
     [java]     "composite" ...
     [java]     "component" ...
     [java]     <ID> ...
     [java]     
     [java]     at com.redhat.persistence.pdl.PDL.load(PDL.java:72)


Version-Release number of selected component (if applicable):


How reproducible:
Always

Steps to Reproduce:
1. Define an association similar to the above example
2. Run generate-sql

    

Additional info:

Comment 1 Daniel Berrangé 2006-09-02 17:23:43 UTC

Closing old tickets