Stack Size Insufficient to Execute Current Request

By: Borland Staff

Abstract: Error occurs in WISQL with InterBase 4.0 and complicated query

Problem:
Executing a large query in WISQL and returning error 
message "Stack size insufficient to execute current 
request".  

Example of such query: 

select * from (line inner join subline inner join
(product left join(document inner join(mi_store inner join 
prodtype on product.typofProduct=prodtype.TypeofProduct 
on document.code=mi_store.code)on product.code=document.code) 
on subline.subline=product.subline) on line.line=subline.line),
product left join prod_tmp on product. Code=prod_tmp.code)


Solution:
IB NW-V4.0A

The workaround now is to split the query.

Server Response from: ETNASC04