db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4490) SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY unexpectedly returns NULL when used in SELECT
Date Tue, 22 Dec 2009 11:42:29 GMT
SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY unexpectedly returns NULL when used in SELECT
------------------------------------------------------------------------------------

                 Key: DERBY-4490
                 URL: https://issues.apache.org/jira/browse/DERBY-4490
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.5.3.0, 10.6.0.0
            Reporter: Knut Anders Hatlen


I see the following values returned when invoking SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY on
its own:

ij> values syscs_util.syscs_get_database_property('derby.database.collation');
1
--------------------
UCS_BASIC

1 row selected
ij> values syscs_util.syscs_get_database_property('DataDictionaryVersion');
1
---------------------
10.6

1 row selected

But when I query both properties at the same time, DataDictionaryVersion comes out as NULL:

ij> select p, syscs_util.syscs_get_database_property(p) from (values 'derby.database.collation',
'DataDictionaryVersion') props(p);
P                       |2
------------------------------------------------------------
derby.database.collation|UCS_BASIC
DataDictionaryVersion   |NULL

2 rows selected

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message