ISQL, SHOW command: option 'CHECK' does not work
------------------------------------------------

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


C:\MIX\firebird\fb25\bin>isql /:e25 -z
ISQL Version: WI-V2.5.6.26990 Firebird 2.5
Server version:
WI-V2.5.6.26990 Firebird 2.5
WI-V2.5.6.26990 Firebird 2.5/tcp (csprog)/P12
WI-V2.5.6.26990 Firebird 2.5/tcp (csprog)/P12
Database:  /:e25
SQL> help show;
Frontend commands:
. . .
SHOW     <object> [<name>] -- display system information
    <object> = CHECK, COLLATION, . . ., VIEW
...
All commands may be abbreviated to letters in CAPitals

SQL> recreate table test(x int, y int, constraint test_chk check( x+y > 0  ) );
SQL> show table test;
X                               INTEGER Nullable
Y                               INTEGER Nullable
CONSTRAINT TEST_CHK:
  check( x+y > 0  )
SQL> show check test_chk;
There is no table TEST_CHK in this database

SQL> show check;
Command error: show check


-- 
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! http://pubads.g.doubleclick.net/
gampad/clk?id=1444514301&iu=/ca-pub-7940484522588532
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to