> But this has several negative implications.
> 1, A CMR field cannot particpate as the primary key in table B
>
> What is perplexing here is that Hypersonic works fine?
>
> Tom
I think in the past Hypersonic has been fairly 'flexible' in allowing things like two columns of the same name in a table and other oddities (the above might be one)... I'd say upgrading to v1.7 of hsqldb might show this up to be a problem, but thats just a guess.
Regards,
Joe