Subject Re: [firebird-support] has the limit of 255 contexts been increased yet?
Author Doug Chamberlin
On 7/12/2010 9:16 AM, Sam Watkins wrote:
> This "Too many Contexts" error is not related to a schema revision count, it
> occurs for example if I use an "iff" conditional in a certain view, and not if
> I don't. The number of schema alterations is the same in each case. I believe
> "contexts" refers to evaluation contexts, or scopes, used in a query. We're
> getting this error because our database has a complex structure with lots of
> tables, views and joins.
> A single query in our database may be using a total of more than 255 tables,
> views, joins, conditionals etc all together. An "iff" expression definitely
> counts as a "context" and can push us over the limit.
> I'm disappointed to see that Firebird has ANOTHER 255 limit (the "too many
> versions" limit you mentioned) in addition to the one that is bothering me (the "Too many
> Contexts" limit).

My mistake on reading the original problem. I agree that another 255
limit is disappointing at this point.

Doug C.
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing in e-mail?