Ok I thought it was fixed since the Row class' Equal method is implemented so that a long as there's an implicit conversion between two values of the same key then they are equal, but the JoinOperation does not. The problem is basically that once your values are boxed the following returns false:
((object)((long)1)).Equals((object)((ulong)1)) On Sat, May 15, 2010 at 18:19, Simone Busoli <[email protected]>wrote: > Where did you get the code? > > > On Sat, May 15, 2010 at 17:09, jalchr <[email protected]> wrote: > >> mmm, I caught the problem. In the JoinOperation, I had 2 key columns, >> one was of type long, the other was of type ulong (unsigned long) ... >> which caused the join to match nothing !! >> >> I had to use NestedLoopsJoinOperation to manually do the join and >> track the problem. >> >> Is something wrong with Rhino etl ?? >> >> >> On May 15, 3:59 pm, Simone Busoli <[email protected]> wrote: >> > What's wrong? Sounds correct to me. >> > >> > >> > >> > On Sat, May 15, 2010 at 11:49, jalchr <[email protected]> wrote: >> > > Hello >> > > Inserting to a database is simple and straight forward. I'm trying to >> > > synchronize a table, so existing records should get updated. >> > > I'm trying to do this as follows >> > > 1) I read source table with a read operation >> > > 2) I read destination table with a read operation >> > > 3) I perform a join on both read operations (??) in order to determine >> > > existing (??) vs. new records (??) >> > > 4) for new records, mark them for "Insert" >> > > 5) mark existing records for "Update" >> > >> > > I can see something is wrong over here, but can point the solution, >> > > any ideas? >> > >> > > -- >> > > You received this message because you are subscribed to the Google >> Groups >> > > "Rhino Tools Dev" group. >> > > To post to this group, send email to [email protected] >> . >> > > To unsubscribe from this group, send email to >> > > [email protected]<rhino-tools-dev%[email protected]> >> <rhino-tools-dev%[email protected]<rhino-tools-dev%[email protected]> >> > >> > > . >> > > For more options, visit this group at >> > >http://groups.google.com/group/rhino-tools-dev?hl=en. >> > >> > -- >> > You received this message because you are subscribed to the Google >> Groups "Rhino Tools Dev" group. >> > To post to this group, send email to [email protected]. >> > To unsubscribe from this group, send email to >> [email protected]<rhino-tools-dev%[email protected]> >> . >> > For more options, visit this group athttp:// >> groups.google.com/group/rhino-tools-dev?hl=en. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Rhino Tools Dev" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<rhino-tools-dev%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/rhino-tools-dev?hl=en. >> >> > -- You received this message because you are subscribed to the Google Groups "Rhino Tools Dev" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rhino-tools-dev?hl=en.
