[Therion] sql output station flags incorrect

[Bruce Mutton]

Have just started playing with Therions sql outputs, and bumbling along.

 

May have found a bug?

 

Running the query

 

select ID, SURVEY_ID, NAME, X, Y, Z, FLAG

from STATION, STATION_FLAG

group by SURVEY_ID, NAME;

 

results in

 

D          SURVEY_ID      NAME   X          Y          Z          FLAG

2          34         F100     2500604.74       6023114.36       620.49  fix

3          34         F101     2500601.9         6023115.01       618.94
fix

4          34         F102     2500599.78       6023118.02       620.73  fix

5          34         F103     2500604.18       6023127.05       622.96  fix

6          34         F104     2500613.11       6023143.64       625.37  fix

 

etc.  Problem is that ALL the 1200 station flags are fixed.  Most should be
null I think, there should be three entrance flags, and some continuation
flags.  At least that is what has been entered and what the 'caves' and
'continuations' outputs indicate.  

 

A bug, or am I misunderstanding something?

Using 5.2.7

 

Bruce

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.speleo.sk/pipermail/therion/attachments/20090215/5636ed8f/attachment.htm>