db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <msat...@gmail.com>
Subject Buddy testing of DERBY-3809 SHOW FUNCTIONS
Date Mon, 10 May 2010 23:38:54 GMT
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;

Mime
View raw message