[jira] [Updated] (DERBY-5861) Provide a diagnostic table function which lets DBOs view the Derby properties understood by their database.

["Rick Hillegas (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-5861?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Hillegas updated DERBY-5861:
---------------------------------

    Attachment: DerbyPropertyViewer.java

Attaching DerbyPropertyViewer, a table function which shows the settings of the derby properties. Here is an ij script which shows  how to use this table function:

connect 'jdbc:derby:memory:db;create=true';

create function derbyPropertyViewer()
returns table
(
    prop_name varchar( 32672 ),
    prop_value varchar( 32672 )
)
language java parameter style derby_jdbc_result_set
reads sql data
external name 'DerbyPropertyViewer.derbyPropertyViewer';

select * from table( derbyPropertyViewer() ) t
where prop_value is not null;

                
> Provide a diagnostic table function which lets DBOs view the Derby properties understood by their database.
> -----------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-5861
>                 URL: https://issues.apache.org/jira/browse/DERBY-5861
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.10.0.0
>            Reporter: Rick Hillegas
>         Attachments: DerbyPropertyViewer.java
>
>
> Currently there is no way for the DBO to verify what the database thinks the derby properties are. We could provide a diagnostic table function to show this information. By default only the DBO should be able to run this table function. I will attach a crude workaround.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira