ISQL 'show exception' command can terminate subsequent output of executing
script when non-ascii objects are created in database
--------------------------------------------------------------------------------------------------------------------------------
Key: CORE-5221
URL: http://tracker.firebirdsql.org/browse/CORE-5221
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0.0, 4.0 Initial
Reporter: Pavel Zotov
Attachments: isql_show_exception_terminates_subsequent_output.7z
Consider script "c0986r2.sql" from attached .7z (it was created with charset
= Cyrillic, cp = 1251).
Unpack it and run (on new empty database):
C:\MIX\firebird\fb30\isql -ch win1251 /:e30 -i c0986r2.sql -z 1>c0986r-30.log
2>&1
NOTE that script "c0986r2.sql" finishes with thee lines:
===
. . .
set echo on;
show collation;
show domain;
show exception;
show sequence;
show table;
show trigger;
show view;
show procedure;
show role;
===
File "c0986r-30.log" will be finished with this:
===
set echo on;
show collation;
Испания, CHARACTER SET ISO8859_1, FROM EXTERNAL ('ES_ES_CI_AI'), PAD SPACE,
CASE INSENSITIVE, ACCENT INSENSITIVE, 'DISABLE-COMPRESSIONS=1;SPECIALS-FIRST=1'
Циферки, CHARACTER SET UTF8, FROM EXTERNAL ('UNICODE'), PAD SPACE, CASE
INSENSITIVE, 'COLL-VERSION=58.0.6.50;NUMERIC-SORT=1'
show domain;
Артикулы Группы
ИД'шники Кол-во
Комрады
show exception;
There are no exceptions in this database
===
So, all these commands:
show sequence;
show table;
show trigger;
show view;
show procedure;
show role;
-- either did not run or their output was suppressed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
