Implicit SERVERDB restart

[Arne Gehlhaar]

Hi,

I am trying to write an SQL statement that counts the number of 
many-to-many references on a specific table (CalculationRule)

The query I use is:

select
   cru.cruId,
   (select count(cruId) from NebHasCru nhc where cru.cruId = nhc.cruId) +
   (select count(cruId) from VoyHasCru vhc where cru.cruId = vhc.cruId) +
   (select count(cruId) from OrdHasCru ohc where cru.cruId = ohc.cruId) +
   (select count(cruId) from DctHasCru dhc where cru.cruId = dhc.cruId)
from CalculationRule cru
where cru.cruId = 2000

which executes without problems. But when I want to see the individual 
counts, the database server crashed and had to be restarted:

> ---- Error -------------------------------
> Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
> General error;800 Implicit SERVERDB restart (connection aborted).
> select 
>   cru.cruId, 
>   (select count(cruId) from NebHasCru nhc where cru.cruId = nhc.cruId) ,
>   (select count(cruId) from VoyHasCru vhc where cru.cruId = vhc.cruId) ,
>   (select count(cruId) from OrdHasCru ohc where cru.cruId = ohc.cruId) ,
>   (select count(cruId) from DctHasCru dhc where cru.cruId = dhc.cruId)
> from CalculationRule cru 
> where cru.cruId = 2000

Is this a known and/or fixed bug? I searched the mail archives but 
didn't find anything helpful.

Versions:
Kernel   Kernel 7.4.3  Build 010-00-035-462
Runtime  X32/LINUX 7.4.3  Build 010-00-035-462

Arne

-- 
Institute of Shipping Economics and Logistics    http://www.isl.org/
Arne Gehlhaar                                mailto:gehlhaar@stripped
Universitaetsallee GW1 Block A                phone:[phone]
D-28359 Bremen, Germany                         fax:[phone]