> -----Original Message----- > From: Jean-Michel OLTRA [mailto:[EMAIL PROTECTED] > Sent: Sonntag, 7. M�rz 2004 23:06 > To: MaxDb > Subject: SIGSEGV on create temporary table > > > > bonjour, > > > this statement: > > SELECT T.SEXE, CASE WHEN ES2.IDMOUVEMENT LIKE 'E%' AND ES2.DATEES > BETWEEN SUBDATE('20040306',240) AND '20040306' THEN 'J' ELSE 'A' > END AS AGE, T.IDANIMAL > FROM (SELECT A.SEXE, A.IDANIMAL > FROM ANIMAL A > LEFT JOIN ENTREESORTIE ES1 > ON (A.IDANIMAL=ES1.IDANIMAL AND ES1.IDMOUVEMENT LIKE 'S%') > WHERE ES1.IDANIMAL IS NULL OR ES1.DATEES>'20040306') T > JOIN ENTREESORTIE ES2 > ON T.IDANIMAL=ES2.IDANIMAL > WHERE ES2.IDMOUVEMENT LIKE 'E%' AND ES2.DATEES < '20040306' > > returns correct resultset > > But if I want to create a temporary table with it (CREATE TABLE TEMP.A > AS at the beginning) my instance crashes > knldiag.err says: > 2004-03-07 23:01:51 0 ERR 11330 COREHAND ABORTING due to signal 11 > then a stack back trace. > > I missed something ? SELECT FROM (SELECT) is not allowed ? > > --
After having seen the traceback (outside the list) and the kernel version 7.5.00.08 I am pretty sure, that fixed bug http://pts:1080/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1126610 was the reason. The version 7.5.00.09 is not available so far and I do not know a workaround in a JDBC/ODBC/... environment to have this in ONE statement. The problem is the handling of create table .. select. May be a create table + an insert..select will do. The result is the same as with your create table .. select. Elke SAP Labs Berlin > jm > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
