You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Mamta Satoor <ms...@gmail.com> on 2010/05/11 01:38:54 UTC
Buddy testing of DERBY-3809 SHOW FUNCTIONS
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.
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;
Re: Buddy testing of DERBY-3809 SHOW FUNCTIONS
Posted by Kristian Waagan <Kr...@Sun.COM>.
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;
>