Dealing with yacc stack overflow
January 23, 2007 at 9:41 pm | In Development | Leave a CommentThe ‘yacc stack overflow’ error usually occurs when sections of a DQL query contain too many tokens. The most typical example is something like the following:
select * from dm_document where object_name in ('first token','second token',...,'500th token')
If the number of items in the in list exceeds about 490 items a yacc stack overflow occurs. The solution is to split up the long list of tokens into a number of separate constructs. In the case of the example above:
select * from dm_document where object_name in ('first token','second token',...,'485th token') or
object_name in ('486th token',...,'500th token')
No Comments Yet »
Blog at WordPress.com. | Theme: Pool by Borja Fernandez.
Entries and comments feeds.
