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

isql doesn't provide info for some SET options [CORE3004] #3386

Open
firebird-automations opened this issue May 16, 2010 · 1 comment
Open

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Kuznetsov Eugene (eugene)

"help set" command in isql doesn't output "SET SQLDA_DISPLAY", "SET WARNINGs", "SET WNG" in set commands list.
"set" command doesn't output current sql dialect, SQLDA_DISPLAY state and runtime character set (if it has default value).
--
BR, Eugene

@firebird-automations
Copy link
Collaborator Author

Commented by: Kuznetsov Eugene (eugene)

Since 2.5, isql, if set command is invalid ("set 1", for example) get valid options list. In 2.5 RC2 these 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

Help set command output these options:
SET
SET AUTOddl
SET BAIL
SET BLOB [ALL|<n>]
SET BLOB
SET COUNT
SET ROWCOUNT [<n>]
SET ECHO
SET HEADING
SET LIST
SET NAMES <csname>
SET PLAN
SET PLANONLY
SET SQL DIALECT <n>
SET STATs
SET TIME
SET TERM <string>
SET WIDTH <col> [<n>]

I think, "help set" should output the list
SET
SET AUTOddl
SET BAIL
SET BLOBdisplay [ALL|<n>]
SET BLOBdisplay
SET COUNT
SET ROWCOUNT [<n>]
SET ECHO
SET HEADING
SET LIST
SET NAMES <csname>
SET PLAN
SET PLANONLY
SET SQLDA_DISPLAY
SET SQL DIALECT <n>
SET STATs
SET TIME
SET TERMinator <string>
SET WIDTH <col> [<n>]
SET WARININGs;
SET WNG;

and, maybe, SET BULK_INSERT as it seems some undocumented isql option.

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