Issue Details (XML | Word | Printable)

Key: CORE-5096
Type: Improvement Improvement
Status: Open Open
Priority: Minor Minor
Assignee: Unassigned
Reporter: Pavel Zotov
Votes: 0
Watchers: 1
Operations

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

ISQL: Provide actual types of COMPUTED-BY fields in SHOW TABLE output

Created: 01/Feb/16 12:39 PM   Updated: 01/Feb/16 12:39 PM
Component/s: ISQL
Affects Version/s: None
Fix Version/s: None

QA Status: No test


 Description  « Hide
It will be useful to see actual types of computed fields in the 'SHOW TABLE' output.
Currently one need to look at table DDL by using ISQL -X.

Test:
####

recreate table t1 (
     n0 int

     ,si smallint computed by(32767)
    ,bi bigint computed by (2147483647)
    ,s2 smallint computed by ( mod(bi, nullif(si,0)) )

    ,dx double precision computed by (pi())
    ,fx float computed by (dx*dx)
    ,nf numeric(3,1) computed by (fx)

    ,dt date computed by ('now')
    ,tm time computed by ('now')
    -- eval not supported: ,dx computed by ( dateadd(1 day to dt) )
    
    ,c1 char character set win1251 computed by ('ы')
    ,c2 char character set win1252 computed by ('å')
    ,cu char character set utf8 computed by ('∑')
    
    ,c1x char computed by(c1)
    ,c2x char computed by(c2)
    ,cux char computed by(cu)
    
    ,b1 blob character set win1251 computed by ('ы')
    ,b2 blob character set win1252 computed by ('ä')
    ,bu blob character set utf8 computed by ('∑')
    ,bb blob computed by ('∞')
    
    ,b1x blob computed by (b1)
    ,b2x blob computed by (b2)
    ,bux blob computed by (bu)
    ,bbx blob computed by (bb)
);
commit;

show table t1;

Output:
######

N0 INTEGER Nullable
SI Computed by: (32767)
BI Computed by: (2147483647)
S2 Computed by: ( mod(bi, nullif(si,0)) )
DX Computed by: (pi())
FX Computed by: (dx*dx)
NF Computed by: (fx)
DT Computed by: ('now')
TM Computed by: ('now')
C1 Computed by: ('ы')
C2 Computed by: ('å')
CU Computed by: ('∑')
C1X Computed by: (c1)
C2X Computed by: (c2)
CUX Computed by: (cu)
B1 Computed by: ('ы')
B2 Computed by: ('ä')
BU Computed by: ('∑')
BB Computed by: ('∞')
B1X Computed by: (b1)
B2X Computed by: (b2)
BUX Computed by: (bu)
BBX Computed by: (bb)

PS. "ISQL -x" will show proper types for computed by fields only since build 32306 (01-feb-2016):

CREATE TABLE T1 (N0 INTEGER,
        SI SMALLINT COMPUTED BY (0),
        BI BIGINT COMPUTED BY (1),
        FL FLOAT COMPUTED BY (3.14),
        DT DATE COMPUTED BY ('now'),
        TM TIME COMPUTED BY ('now'),
        C1 CHAR(1) CHARACTER SET WIN1251 COMPUTED BY ('ы'),
        C2 CHAR(1) CHARACTER SET WIN1252 COMPUTED BY ('å'),
        CU CHAR(1) COMPUTED BY ('∑'),
        B1 BLOB SUB_TYPE TEXT SEGMENT SIZE 80 CHARACTER SET WIN1251 COMPUTED BY ('ы'),
        B2 BLOB SUB_TYPE TEXT SEGMENT SIZE 80 CHARACTER SET WIN1252 COMPUTED BY ('ä'),
        BU BLOB SUB_TYPE TEXT SEGMENT SIZE 80 COMPUTED BY ('∑'),
        BB BLOB SUB_TYPE 0 SEGMENT SIZE 80 COMPUTED BY ('∞'));


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