[Babase] Queries that run forever
Karl O. Pinc
kop at meme.com
Wed Apr 4 11:42:52 EDT 2007
On 04/04/2007 10:37:53 AM, Karl O. Pinc wrote:
>
> On 04/04/2007 02:37:11 AM, Tyler Brock wrote:
>> Now it fails to work again using babase_test... example:
>
>> babase_test=> INSERT INTO ranks (sname, rnkdate, grp, rnktype, rank)
>> VALUES ('BIN', '1984-1-01', 3.0, 'ALL', 1);
>> Cancel request sent
>> ERROR: canceling statement due to user request
>> babase_test=>
>>
>> Maybe I'm messing something up?
>
> No, you found a bug in my code. I fixed it.
>
> If you tried to rank an individual in a group before that
> group has a supergroup (before the group's Permanent date
> when the group has no From_group) then there'd be an
> infinite loop in the supergroup() function.
> In other words, you were ranking an individual in a group
> before the group actually existed as an indepedent
> entity and the database had no information regarding
> what group the group split from. So in some sense the
> group didn't actually exist because the system had
> no way to check which groups the individual needed
> to be censued in in order to be a member of the group.
What this means is that there are certain times when
you can't rank somebody in a group. I think that you
should not be able to rank somebody then, but you might
want to check with Susan just to be sure. (She's probably
not reading this whole thread so a phone call might be in
order, or something between you and her to make sure
that the ranker program will rank when it should.
If you think it's necessary then you, I, and her
can have a conference call.)
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