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
While testing my extensions to table rdb$view_relations to close an ambiguity in the definition of views based on procedures, I found this:
F:\fb3dev\fbbuild\firebird30\temp\Win32\Debug\firebird\bin>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'procview.fdb';
SQL> set term ^;
SQL> create procedure p returns(rc int) as begin rc = 1; suspend; end^
SQL> create view v2(dosrc) as select rc * 2 from p^
Statement failed, SQLSTATE = HY000
invalid request BLR at offset 3
-context not defined (BLR error)
Submitted by: Claudio Valderrama C. (robocop)
Is related to QA427
While testing my extensions to table rdb$view_relations to close an ambiguity in the definition of views based on procedures, I found this:
F:\fb3dev\fbbuild\firebird30\temp\Win32\Debug\firebird\bin>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'procview.fdb';
SQL> set term ^;
SQL> create procedure p returns(rc int) as begin rc = 1; suspend; end^
SQL> create view v2(dosrc) as select rc * 2 from p^
Statement failed, SQLSTATE = HY000
invalid request BLR at offset 3
-context not defined (BLR error)
Commits: b560538 e66a151
The text was updated successfully, but these errors were encountered: