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;
