invalid request BLR at offset 361 context already in use (BLR error)
--------------------------------------------------------------------
Key: CORE-4710
URL: http://tracker.firebirdsql.org/browse/CORE-4710
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Beta 2
Reporter: Karol Bieniaszewski
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 */
from
RDB$DATABASE
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
