[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