db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yip Ng (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1164) 'show tables' and 'describe' commands in ij
Date Wed, 09 Aug 2006 01:12:14 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1164?page=comments#action_12426786 ] 
            
Yip Ng commented on DERBY-1164:
-------------------------------

This is a very useful patch and it would be great if it can be included in 10.2.  I did some
ad-hoc testing and 
found a minor problem with the DESCRIBE command when supplying a string  literal with surrounding
quotes.  +1 to this patch if derbyall passes.  Thanks for the patch, Håvard!

ij> create table t1 (i int, j xml);
0 rows inserted/updated/deleted
ij> describe t1;
COLUMN_NAME         |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
------------------------------------------------------------------------------
I                   |INTEGER  |0   |10  |10    |NULL      |NULL      |YES
J                   |XML      |NULL|NULL|21474&|NULL      |NULL      |YES

2 rows selected
ij> describe 't1';
COLUMN_NAME         |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
------------------------------------------------------------------------------
I                   |INTEGER  |0   |10  |10    |NULL      |NULL      |YES
J                   |XML      |NULL|NULL|21474&|NULL      |NULL      |YES

2 rows selected
ij> describe app.t1;
COLUMN_NAME         |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
------------------------------------------------------------------------------
I                   |INTEGER  |0   |10  |10    |NULL      |NULL      |YES
J                   |XML      |NULL|NULL|21474&|NULL      |NULL      |YES

2 rows selected
ij> describe 'app.t1';
JAVA ERROR: java.lang.NullPointerException



> 'show tables' and 'describe' commands in ij
> -------------------------------------------
>
>                 Key: DERBY-1164
>                 URL: http://issues.apache.org/jira/browse/DERBY-1164
>             Project: Derby
>          Issue Type: New Feature
>          Components: Tools
>            Reporter: Håvard Mork
>         Assigned To: Håvard Mork
>            Priority: Minor
>             Fix For: 10.2.0.0
>
>         Attachments: 1164.diff, 1164_2.diff, 1164_3.diff, 1164_4.diff
>
>
> New users migrating from mysql are familiar with commands 'show tables' and 'describe'
 to respectively display all permanent tables, and show fields in a given table. These are
not standard sql, but I suggest to implement them only in the IJ tool for user-friendliness.
> As suggested in db-dev, using DatabaseMetaData should provide the necessary query strings.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

Mime
View raw message