Arne Gehlhaar wrote: > > 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
May I ask to use the newest version of 7.4.3 as we changed several things in the meantime. May I ask, too, to provide the knldiag (the trace Back) of the crash to give us a chance to find out if this is/was a known bug, fixed with version xyz . May I ask for the table definition (with some data) and the select causing the core if even with the newest version this bug is in. Elke SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
