Issue Details (XML | Word | Printable)

Key: CORE-5190
Type: Bug Bug
Status: Open Open
Priority: Trivial Trivial
Assignee: Unassigned
Reporter: Pavel Zotov
Votes: 0
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

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

Created: 10/Apr/16 08:47 PM   Updated: 10/Apr/16 08:47 PM
Component/s: ISQL
Affects Version/s: 2.5.5, 3.0 RC2, 4.0 Initial
Fix Version/s: None

QA Status: No test


 Description  « Hide
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


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.