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 ?
--
jm
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
