I quickly compared the sql for getImportedKeys in metadata.properties for Derby 10.2 and 5.1.60 and didn't notice any change other than the syntax change. I wonder if the contents of the system tables have changed between the 2 release. First I will try to run my simple test case against
5.1.60 and see what happens.
Mamta
On 1/30/06, Mamta Satoor <[EMAIL PROTECTED]> wrote:
Hi Kathey,I think this info might come out very handy. Especially, since I will have both the databases to compare.thanks,Mamta
On 1/30/06, Kathey Marsden <[EMAIL PROTECTED] > wrote:Hi Mamta,
I have not been following the technical details of this issue, but one
thing that might be of help is that I know that this issue arose out of
a database that a customer was migrating from Cloudscape 5.1.60 to
Derby. When comparing the 5.1.60 and 10.0 database we found that the
5.1.60 getImportedKeys() was returning the right results, but 10.x was
not, even though the migration was successful, so it may be helpful to
compare with the 5.1.60 database.
I'll contact you off-line to get you the 5.1.60 database for evaluation.
Kathey
