I have a similar problem with a list of union(s) (see my email, one hour before yours). It seems there is something in the way mysql parses the string that makes it crash. I tried with version 4.1.2 as well, but it keeps on crashing.
Due to the architecture of the parser, if you have a lot of ( levels, eg ((((((...(expr)...))))), it needs a bigger thread stack. If it is absolutely critical for you to deal with those, increase the value of thread_stack. Otherwise (recommended), re-write the expression. Increasing thread_stack comes at a cost in memory usage.
It is, nevertheless, a bug, for the server to coredump on this. The code does thread stack checking to make sure it does not exceed the limit, but apparently it does miss some cases.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]