[Babase] More weird order in Compareout

Karl O. Pinc kop at meme.com
Thu Jun 1 14:03:05 EDT 2006


On 06/01/2006 12:31:15 PM, Catherine Markham wrote:
> Hi Karl,
> 
> Here's another excerpt of a few rows that struck me as being in a  
> funny order (some of KUP's rows appearing in the middle of KPMs).   
> Should I be concerned about these?

Ah, I finally see what you're concerned about.  Is this the
same thing you write about in the email
Subject: Funky order in comparetables.out
?  I wasn't really getting that one.

This is not a problem.  The KUP rows are not mixed in with KPM
rows.  KPM rows ended, then KUP rows started.  It so happens
that the last KPM rows are different in the old and new
databases, as are the first KUP rows.  The comparison program
just sees that a whole bunch of contiguous rows have changed
from the old to the new database, it does not care that the
rows are KPM or KUP -- it's all one big hunk of change.
(Hunk, by the by, is the proper technical term for it.  :-)
So, it shows you the rows in the hunk as they were in the
old database, then the rows in the hunk as they are in the
new.  (If I wanted to keep the individuals separate, I could
compare individual-by-individual one at a time, but it's easier
to do whole tables at a time so why go to the extra effort?)

> 683 KPM 26 1987-09-15 1987-09-15 1987-09-15 1987-09-17 1987-09-15  
> 1987-09-17 1987-10-04 1987-10-04 1987-10-06
>  684 KPM 27 1989-05-20 1989-07-27
> -685 KPM 28 1989-09-17
> -686 KPM 29 1989-12-10
> -687 KPM 30 1990-01-14
> -688 KPM 31 1990-02-18
> -2148 KUP 1
> -2170 KUP 2
> +685 KPM 28 1989-08-09 1989-09-17
> +686 KPM 29 1989-09-30 1989-12-10
> +687 KPM 30 1989-12-23 1990-01-14
> +688 KPM 31 1990-01-27 1990-02-18
> +2148 KUP 1 1977-04-29
> +2170 KUP 2 1979-02-09
>  689 KUP 3 1980-09-15 1980-09-15 1980-09-15
>  690 KUP 4 1981-11-15 1981-11-15 1981-11-15 1981-12-08 1981-12-08  
> 1981-12-08
> 
> 
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
> 

Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list