[ 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
