Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

invalid request BLR at offset 361 context already in use (BLR error) [CORE4710] #5017

Closed
firebird-automations opened this issue Mar 16, 2015 · 4 comments

Comments

@firebird-automations
Copy link
Collaborator

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)

,\(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

Commits: 4929f46 FirebirdSQL/fbt-repository@de64f27

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 RC 1 [ 10584 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: Done successfully

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants