Many of the relationships as you'd expected connected by integer ids on the tables.
For some tables when I read the data I consistently get these integer ids truncated. So e.g. if it should read
Code: Select all
Key Title
95 Grapes
1457 Oranges
1458 Pears
1592 Apples
1593 Bananas
Code: Select all
Key Title
9 Grapes
14 Oranges
14 Pears
15 Apples
15 Bananas
Code: Select all
RecipeKey FruitKey
1002 1457
1003 1593
I've found a work around: by asking the database to convert the integer to char, e.g.
SELECT to_char(Key) as Key,Title ...
with this modification, I get the expected data.
Has anyone else come across this?