I tried even with thread_stack=1000000000
(starting from thread_stack=100000 and increasing by 10 times each time) It still keeps on crashing. Note that my select is SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION (SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION (SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION (SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION (SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION (SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION (SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION (SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION (SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION (SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION (SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION (SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) I tried with Chambon's query as well, but it keeps on crashing too: select JobStatus from Test where (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((( ((((((((((((( JobStatus = 'xyz' ))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) )))))))))))))))))) ; > -----Messaggio originale----- > Da: Sasha Pachev [mailto:[EMAIL PROTECTED] > Inviato: lunedi 14 giugno 2004 21.56 > A: Leonardo Francalanci > Cc: [EMAIL PROTECTED] > Oggetto: Re: R: query string make mysqld crash (mysqld 4.0.20) > > > Leonardo Francalanci wrote: > > 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]