You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
1. If you run this query unmodified you got "normal error"
"Too many Contexts of Relation/Procedure/Views. Maximum allowed is 256."
2. comment last select marked as /* #1 */ - you got
"invalid request BLR at offset 361 context already in use (BLR error)"
3. comment select marked as /* #2 */
query run normally
Something is wrong near 256 context limit
select
(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\)
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\) /\* #⁠2 \*/
,\(SELECT ROW\_NUMBER\(\) OVER\(\) FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2\.RDB$RELATION\_ID=R\.RDB$RELATION\_ID GROUP BY R\.RDB$RELATION\_ID HAVING COUNT\(\*\)\>0 ORDER BY R\.RDB$RELATION\_ID ROWS 1 TO 1\) /\* #⁠1 \*/
Submitted by: @livius2
1. If you run this query unmodified you got "normal error"
"Too many Contexts of Relation/Procedure/Views. Maximum allowed is 256."
2. comment last select marked as /* #1 */ - you got
"invalid request BLR at offset 361 context already in use (BLR error)"
3. comment select marked as /* #2 */
query run normally
Something is wrong near 256 context limit
select
(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
,(SELECT ROW_NUMBER() OVER() FROM RDB$DATABASE R FULL JOIN RDB$DATABASE R2 ON R2.RDB$RELATION_ID=R.RDB$RELATION_ID GROUP BY R.RDB$RELATION_ID HAVING COUNT(*)>0 ORDER BY R.RDB$RELATION_ID ROWS 1 TO 1)
from
RDB$DATABASE
Commits: 4929f46 FirebirdSQL/fbt-repository@de64f27
The text was updated successfully, but these errors were encountered: