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

Get "Unknown error while retrieving plan" (to STDOUT rather than STDERR!) when ISQL of 3.0 connect to FB 2.5 and runs script containing 'SET EXPLAIN ON' [CORE4922] #5213

Open
firebird-automations opened this issue Sep 1, 2015 · 0 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

Script:

show version;
set explain on;
select * from rdb$database where rdb$relation_id = 1;

Now connect to FB 2.5 but using ISQL of 3.0 and run this script.

STDOUT will be:

ISQL Version: WI-V3.0.0.32008 Firebird 3.0 Release Candidate 1
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-V2.5.5.26916 Firebird 2.5"
Firebird/Windows/Intel/i386 (remote server), version "WI-V2.5.5.26916 Firebird 2.5/tcp (balaha)/P12"
Firebird/Windows/Intel/i386 (remote interface), version "WI-V3.0.0.32008 Firebird 3.0 Release Candidate 1/tcp (balaha)/P12"
on disk structure version 11.2
Unknown error while retrieving plan

STDERR will be EMPTY.

IMHO, it will be better if STDERR would contain the same as when doing connect by ISQL 2.x: "Command error: set explain on". And STDOUT in such case also can be like 'old good 2.x':

Valid options are:
AUTOddl BLOBdisplay BAIL
BULK_INSERT COUNT ECHO
GENERATOR HEADING LIST
NAMES PLAN PLANONLY
ROWCOUNT STATs SQLDA_DISPLAY
SQL STATISTICS TRANSaction
TERMinator TIME WIDTH
WARNINGs WNG

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

1 participant