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

Constants isc_lock_conflict / isc_eds_statement not recognized in PSQL [CORE3349] #3715

Closed
firebird-automations opened this issue Feb 14, 2011 · 10 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Sergey Mereutsa (green_dq)

Try to compile the following code:

SET TERM ^ ;

create procedure proc_eds
as
declare variable i integer;
begin
execute statement ('select 1 from rdb$database') into :i;
when gdscode isc_eds_statement do
begin
exit;
end
end
^
SET TERM ; ^

You`ll got the following error:

Statement failed, SQLSTATE = HY000
invalid request BLR at offset 89
-status code isc_eds_statement unknown

The same behavior with isc_lock_conflict constant.

Commits: 9f5a439 f1ddbd3

====== Test Details ======

Issue of this ticket is about documentation rather than FB behaviour.

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

"when gdscode eds_statement do", i.e. you must omit the "isc_" prefix.

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

It seems as undocumented feature since IB6 :)

And it was my mistake in README.execute_statement2 - Sergey just used my examples with full names of errors.

@firebird-automations
Copy link
Collaborator Author

Commented by: Sergey Mereutsa (green_dq)

Changed to documentation error - constants should be used without "isc_" prefix.

@firebird-automations
Copy link
Collaborator Author

Modified by: Sergey Mereutsa (green_dq)

Component: Documentation [ 10011 ]

Component: API / Client Library [ 10040 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Fixed examples at README.execute_statement2

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Fix Version: 2.5.1 [ 10333 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Cannot be tested

Test Details: Issue of this ticket is about documentation rather than FB behaviour.

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