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.
