[Babase] Problem in SAMPLES.Minsis

Karl O. Pinc kop at meme.com
Mon Mar 26 17:46:17 EDT 2007


Hi,

I've found a problem in the foxpro data in SAMPLES.Minsis,
the value in the column is not always the actual number
of minutes in sight based on the POINT_DATA rows
that exist.

My suspicion is that this is due to conversion cleanup.
There is always 1 fewer rows of observation than
the Minsis value.

The papio database calculates SAMPLES.Minsis and so there's
no test to detect this problem.  (Although I've found a bug
which is what lead me to discover the discrepency in foxpro.)

I leave it to somebody else to decide if this is a real problem
that we need to do something about.

(Note: You may find it easier to re-run the query than to
look at the line-wrapped output herein.  :)

babase=> select sid, date, observer, stype, grp, sname, mins, minsis,  
(select count(*) from points where points.sid = samples.sid)  as  
actual_minsis from samples where minsis != (select count(*) from points  
where points.sid = samples.sid) order by sid;
   sid  |    date    | observer | stype | grp  | sname | mins | minsis  
| actual_minsis
-------+------------+----------+-------+------+-------+------+--------+---------------
    212 | 2001-12-07 | JKW      | F     | 1.10 | SER   |   10 |      9  
|             8
   1211 | 2001-10-24 | RSM      | F     | 1.21 | OBI   |   10 |     10  
|             9
   1244 | 2001-10-25 | RSM      | F     | 2.10 | NOB   |   10 |     10  
|             9
   2217 | 2002-01-03 | SNS      | F     | 1.22 | VIV   |   10 |      6  
|             5
   6144 | 2000-03-21 | RSM      | F     | 1.21 | ASH   |   10 |     10  
|             9
   7131 | 2000-06-07 | SNS      | F     | 2.10 | WAD   |   10 |      5  
|             4
   7995 | 2000-07-22 | JKW      | F     | 2.20 | KOL   |   10 |      4  
|             3
   8567 | 2000-09-08 | JKW      | F     | 1.10 | HOL   |    5 |      4  
|             3
   9013 | 2000-10-04 | RSM      | J     | 1.21 | ORI   |   10 |     10  
|             9
   9139 | 2000-10-07 | RSM      | F     | 1.21 | ECH   |   10 |     10  
|             9
   9140 | 2000-10-07 | RSM      | F     | 1.21 | OMO   |   10 |     10  
|             9
   9658 | 2000-10-25 | RSM      | J     | 1.21 | ORI   |   10 |     10  
|             9
  25812 | 2004-12-06 | SNS      | J     | 1.10 | SAT   |   10 |     10  
|             9
  26440 | 2005-01-11 | RSM      | J     | 2.20 | LUT   |   10 |     10  
|             9
  31026 | 2005-08-22 | RSM      | F     | 1.21 | ECH   |   10 |     10  
|             9
  33937 | 2005-12-16 | RSM      | F     | 1.22 | DUN   |   10 |     10  
|             9
(16 rows)




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