db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristian Waagan <Kristian.Waa...@Sun.COM>
Subject Re: Buddy testing of DERBY-3809 SHOW FUNCTIONS
Date Tue, 11 May 2010 07:34:47 GMT
On 11.05.10 01:38, Mamta Satoor wrote:
> Hi,
>
> With DERBY-3809, it is nice that one can now list the functions just
> like procedures through SHOW PROCEDURES.
>
> While buddy testing, I noticed that (this is also pointed out by
> Sylvain Leroux in DERBY-3809) is that the last column, REMARKS, is too
> narrow. I thought using ij's maximumdisplaywidth would help with that
> but the REMARKS column's display didn't change with
> maximumdisplaywidth setting. May be this is expected but I thought I
> would share it. Thanks.
>    

Hi Mamta,

I experienced the same issue when using DESCRIBE - I just couldn't get 
ij to display the the full, or at least more of the values.


Regards,
-- 
Kristian

> eg ij session
> $ java org.apache.derby.tools.ij
> ij version 10.6
> ij>  connect 'jdbc:derby:c:/dellater/buddytest10_6_1;create=true';
> WARNING 01J01: Database 'c:/dellater/buddytest10_6_1' not created, connection ma
> de to existing database instead.
> ij>  show functions;
> FUNCTION_SCHEM|FUNCTION_NAME               |REMARKS
> -------------------------------------------------------------------------------
> APP           |PADSTRING                   |org.apache.derbyTesting.functionTe&
> SYSCS_UTIL    |SYSCS_CHECK_TABLE           |org.apache.derby.catalog.SystemPro&
> SYSCS_UTIL    |SYSCS_GET_DATABASE_PROPERTY |org.apache.derby.catalog.SystemPro&
> SYSCS_UTIL    |SYSCS_GET_RUNTIMESTATISTICS |org.apache.derby.catalog.SystemPro&
> SYSCS_UTIL    |SYSCS_GET_USER_ACCESS       |org.apache.derby.catalog.SystemPro&
> SYSCS_UTIL    |SYSCS_GET_XPLAIN_MODE       |org.apache.derby.catalog.SystemPro&
> SYSCS_UTIL    |SYSCS_GET_XPLAIN_SCHEMA     |org.apache.derby.catalog.SystemPro&
> SYSIBM        |BLOBCREATELOCATOR           |org.apache.derby.impl.jdbc.LOBStor&
> SYSIBM        |BLOBGETBYTES                |org.apache.derby.impl.jdbc.LOBStor&
> SYSIBM        |BLOBGETLENGTH               |org.apache.derby.impl.jdbc.LOBStor&
> SYSIBM        |BLOBGETPOSITIONFROMBYTES    |org.apache.derby.impl.jdbc.LOBStor&
> SYSIBM        |BLOBGETPOSITIONFROMLOCATOR  |org.apache.derby.impl.jdbc.LOBStor&
> SYSIBM        |CLOBCREATELOCATOR           |org.apache.derby.impl.jdbc.LOBStor&
> SYSIBM        |CLOBGETLENGTH               |org.apache.derby.impl.jdbc.LOBStor&
> SYSIBM        |CLOBGETPOSITIONFROMLOCATOR  |org.apache.derby.impl.jdbc.LOBStor&
> SYSIBM        |CLOBGETPOSITIONFROMSTRING   |org.apache.derby.impl.jdbc.LOBStor&
> SYSIBM        |CLOBGETSUBSTRING            |org.apache.derby.impl.jdbc.LOBStor&
>
> 17 rows selected
> ij>  maximumdisplaywidth 4500;
> ij>  show functions;
> FUNCTION_SCHEM|FUNCTION_NAME               |REMARKS
> -------------------------------------------------------------------------------
> APP           |PADSTRING                   |org.apache.derbyTesting.functionTe&
> SYSCS_UTIL    |SYSCS_CHECK_TABLE           |org.apache.derby.catalog.SystemPro&
> SYSCS_UTIL    |SYSCS_GET_DATABASE_PROPERTY |org.apache.derby.catalog.SystemPro&
> SYSCS_UTIL    |SYSCS_GET_RUNTIMESTATISTICS |org.apache.derby.catalog.SystemPro&
> SYSCS_UTIL    |SYSCS_GET_USER_ACCESS       |org.apache.derby.catalog.SystemPro&
> SYSCS_UTIL    |SYSCS_GET_XPLAIN_MODE       |org.apache.derby.catalog.SystemPro&
> SYSCS_UTIL    |SYSCS_GET_XPLAIN_SCHEMA     |org.apache.derby.catalog.SystemPro&
> SYSIBM        |BLOBCREATELOCATOR           |org.apache.derby.impl.jdbc.LOBStor&
> SYSIBM        |BLOBGETBYTES                |org.apache.derby.impl.jdbc.LOBStor&
> SYSIBM        |BLOBGETLENGTH               |org.apache.derby.impl.jdbc.LOBStor&
> SYSIBM        |BLOBGETPOSITIONFROMBYTES    |org.apache.derby.impl.jdbc.LOBStor&
> SYSIBM        |BLOBGETPOSITIONFROMLOCATOR  |org.apache.derby.impl.jdbc.LOBStor&
> SYSIBM        |CLOBCREATELOCATOR           |org.apache.derby.impl.jdbc.LOBStor&
> SYSIBM        |CLOBGETLENGTH               |org.apache.derby.impl.jdbc.LOBStor&
> SYSIBM        |CLOBGETPOSITIONFROMLOCATOR  |org.apache.derby.impl.jdbc.LOBStor&
> SYSIBM        |CLOBGETPOSITIONFROMSTRING   |org.apache.derby.impl.jdbc.LOBStor&
> SYSIBM        |CLOBGETSUBSTRING            |org.apache.derby.impl.jdbc.LOBStor&
>
> 17 rows selected
> ij>  exit;
>    


Mime
View raw message