On Aug 26, 2008, at 22:39, Scott Anderson wrote:
> Moving this to the list, since it maybe useful to others-
>
> I have been poking around, and I think I've figured out how to use it.
> If I use DbGenerator, everything works great, but if I try to merge in
> changes from a slightly out of sync schema with DbMerger, it looks
> like
> invalid SQL is generated.
>
> I'm using Derby with 3.0M4, and the relevant offending samples are:
>
> 1)
> Syntax error: Encountered "SET" at line 1, column 43.
> ALTER TABLE bnlogin ALTER COLUMN lastSeen SET NOT NULL
I think this one is fixed in trunk
http://issues.apache.org/cayenne/browse/CAY-1063
> 2)
> Foreign Key 'SQL080826163049030' is invalid because 'The table cannot
> be defined as a dependent of table APP.ACCOUNT because of delete rule
> restrictions. (The relationship causes the table to be delete-
> connected
> to the indicated table through multiple relationships and the delete
> rule of the existing relationship is SET NULL.). '.
> ALTER TABLE mail ADD FOREIGN KEY (sentto) REFERENCES account (id)
Could you create a jira for this one?
> 3)
> Syntax error: Encountered "DROP" at line 1, column 39.
> ALTER TABLE rank ALTER COLUMN verbstr DROP NOT NULL
This one should also be fixed in trunk.
> Is it safe to assume that problems like this are a product of the
> package being incomplete, or is it indeed a bug?
It is not complete, but please report anything you find.
Regards,
- Tore.
This archive was generated by hypermail 2.0.0 : Tue Aug 26 2008 - 17:01:19 EDT