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:[EMAIL PROTECTED] Universitaetsallee GW1 Block A phone:+49.421.22096.49 D-28359 Bremen, Germany fax:+49.421.22096.55
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
