SHOW <X> should produce WARNING rather than ERROR when <X> does not exist in 
database
-------------------------------------------------------------------------------------

                 Key: CORE-5256
                 URL: http://tracker.firebirdsql.org/browse/CORE-5256
             Project: Firebird Core
          Issue Type: Bug
          Components: ISQL
    Affects Versions: 3.0.0, 4.0 Initial, 2.5.5
            Reporter: Pavel Zotov


Consider this script:

set echo on;
set bail on;
show domain;
show database;

Run it via batch:

@echo off
C:\MIX\firebird\fb30\isql /:e30 -i show-grant-when-bail-on.sql
if errorlevel 1 echo Error occured inside SQL script.

Output will be:

set bail on;
show domain;
There are no domains in this database
Error occured inside SQL script.

Command 'show database;' (and all subsequent ones) was not executed because of 
set bail = ON. But this case (when there is no domain or other object type) not 
neccessary should be considered as ERROR!

Can ISQL be improved in such way that message "There are no <...> in this 
database" will be WARNING rather than ERROR ? (of course it should be 
redirected in STDERR as before).


-- 
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

        

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to