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

EXECUTE STATEMENT: BLR error if more than 256 output parameters exist [CORE5231] #5510

Closed
firebird-issue-importer opened this issue May 8, 2016 · 11 comments

Comments

@firebird-issue-importer
Copy link

firebird-issue-importer commented May 8, 2016

Submitted by: richard ding (bean66)

Attachments:
test25.gbk
TEST25.FDB

When
create procedure copy_companyinfo()
as
declare variable item1 varchar(20);
declare variable item2 varchar(20);
declare variable item3 varchar(20);
.....
declare variable item257 varchar(20);

begin

for execute statement ' select item1,item2 ......item257 from atable ' into :item1 , :item2 ....... ,item257
do
begin
end
---------------------------

Cannot commit transaction:
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
Error while parsing procedure COPY_COMPANYINFO's BLR.
invalid request BLR at offset 9054.
BLR syntax error: expected statement at offset 9055, encountered 0.

firebird 2.5 is fine.
restore db.gbk from 2.5 to 3.0 this procedure issue error:
gbak: ERROR:invalid request BLR at offset 15362
gbak: ERROR: BLR syntax error: expected unknown EXECUTE STATEMENT option at offset 15363, encountered 26
gbak:Exiting before completion due to errors

Commits: 444abef 6a6eb3c

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 8, 2016

Modified by: richard ding (bean66)

description: When
create procedure copy_companyinfo()
as
declare variable item1 varchar(20);
declare variable item2 varchar(20);
declare variable item3 varchar(20);
.....
declare variable item257 varchar(20);

begin

for execute statement ' select item1,item2 ......item257 from atable ' into :item1 , :item2 ....... ,item257
do
begin
end
---------------------------

Cannot commit transaction:
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
Error while parsing procedure COPY_COMPANYINFO's BLR.
invalid request BLR at offset 9054.
BLR syntax error: expected statement at offset 9055, encountered 0.

firebird 2.5 is fine.

=>

When
create procedure copy_companyinfo()
as
declare variable item1 varchar(20);
declare variable item2 varchar(20);
declare variable item3 varchar(20);
.....
declare variable item257 varchar(20);

begin

for execute statement ' select item1,item2 ......item257 from atable ' into :item1 , :item2 ....... ,item257
do
begin
end
---------------------------

Cannot commit transaction:
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
Error while parsing procedure COPY_COMPANYINFO's BLR.
invalid request BLR at offset 9054.
BLR syntax error: expected statement at offset 9055, encountered 0.

firebird 2.5 is fine.
restore db.gbk from 2.5 to 3.0 this procedure issue error:
gbak: ERROR:invalid request BLR at offset 15362
gbak: ERROR: BLR syntax error: expected unknown EXECUTE STATEMENT option at offset 15363, encountered 26
gbak:Exiting before completion due to errors

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 8, 2016

Modified by: richard ding (bean66)

security: Developers [ 10012 ] =>

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 10, 2016

Commented by: @dyemanov

Please provide (as attachment) a complete test case.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 11, 2016

Commented by: richard ding (bean66)

Attachments database is version 2.5, just a table and a stored procedure, version 3.0 gbak -r test25.gbk test3.fdb -user sysdba -pas masterkey -v error :
gbak: ERROR:invalid request BLR at offset 15368
gbak: ERROR: BLR syntax error: expected unknown EXECUTE STATEMENT option at offset 15369, encountered 26
gbak:Exiting before completion due to errors

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 11, 2016

Modified by: richard ding (bean66)

Attachment: test25.gbk [ 12961 ]

Attachment: TEST25.FDB [ 12962 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 16, 2016

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 16, 2016

Modified by: @dyemanov

Version: 4.0 Initial [ 10621 ]

Fix Version: 3.0.1 [ 10730 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 16, 2016

Modified by: @dyemanov

summary: execute statement More than 256 return value error => EXECUTE STATEMENT: BLR error if more than 256 output parameters exist

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 16, 2016

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 17, 2016

Modified by: @pavel-zotov

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

QA Status: No test => Done successfully

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 17, 2016

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