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 "Rick Hillegas (JIRA)" <ji...@apache.org> on 2012/07/02 14:54:21 UTC
[jira] [Created] (DERBY-5838) By using syscs_set_database_property,
you can set the database version to a garbage string which prevents you
from booting the database.
Rick Hillegas created DERBY-5838:
------------------------------------
Summary: By using syscs_set_database_property, you can set the database version to a garbage string which prevents you from booting the database.
Key: DERBY-5838
URL: https://issues.apache.org/jira/browse/DERBY-5838
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.8.2.2, 10.8.1.2, 10.7.1.1, 10.6.2.1, 10.6.1.0, 10.5.3.0, 10.5.2.0, 10.5.1.1, 10.4.2.0, 10.4.1.3, 10.3.3.0, 10.3.2.1, 10.3.1.4, 10.2.2.0, 10.2.1.6, 10.1.3.1, 10.1.2.1, 10.1.1.0, 10.0.2.1, 10.9.1.0, 10.10.0.0
Reporter: Rick Hillegas
The following script shows this problem:
connect 'jdbc:derby:db;create=true';
values ( syscs_util.syscs_get_database_property( 'DataDictionaryVersion' ) );
call syscs_util.syscs_set_database_property( 'DataDictionaryVersion', 'foobar' );
values ( syscs_util.syscs_get_database_property( 'DataDictionaryVersion' ) );
connect 'jdbc:derby:db;shutdown=true';
-- fails to boot
connect 'jdbc:derby:db';
--
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
[jira] [Assigned] (DERBY-5838) By using
syscs_set_database_property, you can set the database version to a garbage
string which prevents you from booting the database.
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas reassigned DERBY-5838:
------------------------------------
Assignee: Rick Hillegas
> By using syscs_set_database_property, you can set the database version to a garbage string which prevents you from booting the database.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-5838
> URL: https://issues.apache.org/jira/browse/DERBY-5838
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.3.1.4, 10.3.2.1, 10.3.3.0, 10.4.1.3, 10.4.2.0, 10.5.1.1, 10.5.2.0, 10.5.3.0, 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2, 10.8.2.2, 10.9.1.0, 10.10.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
>
> The following script shows this problem:
> connect 'jdbc:derby:db;create=true';
> values ( syscs_util.syscs_get_database_property( 'DataDictionaryVersion' ) );
> call syscs_util.syscs_set_database_property( 'DataDictionaryVersion', 'foobar' );
> values ( syscs_util.syscs_get_database_property( 'DataDictionaryVersion' ) );
> connect 'jdbc:derby:db;shutdown=true';
> -- fails to boot
> connect 'jdbc:derby:db';
--
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
[jira] [Resolved] (DERBY-5838) By using
syscs_set_database_property, you can set the database version to a garbage
string which prevents you from booting the database.
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas resolved DERBY-5838.
----------------------------------
Resolution: Fixed
Fix Version/s: 11.0.0.0
10.9.1.1
10.8.2.3
Ported 1356333 to 10.9 branch at subversion revision 1362544.
Ported 1356333 to 10.8 branch at subversion revision 1362545.
Resolving issue.
> By using syscs_set_database_property, you can set the database version to a garbage string which prevents you from booting the database.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-5838
> URL: https://issues.apache.org/jira/browse/DERBY-5838
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.3.1.4, 10.3.2.1, 10.3.3.0, 10.4.1.3, 10.4.2.0, 10.5.1.1, 10.5.2.0, 10.5.3.0, 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2, 10.8.2.2, 10.9.1.0, 10.10.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Fix For: 10.8.2.3, 10.9.1.1, 11.0.0.0
>
> Attachments: derby-5838-01-aa-DataDictionaryVersion.diff
>
>
> The following script shows this problem:
> connect 'jdbc:derby:db;create=true';
> values ( syscs_util.syscs_get_database_property( 'DataDictionaryVersion' ) );
> call syscs_util.syscs_set_database_property( 'DataDictionaryVersion', 'foobar' );
> values ( syscs_util.syscs_get_database_property( 'DataDictionaryVersion' ) );
> connect 'jdbc:derby:db;shutdown=true';
> -- fails to boot
> connect 'jdbc:derby:db';
--
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
[jira] [Updated] (DERBY-5838) By using syscs_set_database_property,
you can set the database version to a garbage string which prevents you
from booting the database.
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas updated DERBY-5838:
---------------------------------
Attachment: derby-5838-01-aa-DataDictionaryVersion.diff
Attaching derby-5838-01-aa-DataDictionaryVersion.diff. This makes Derby raise an exception if you try to change the value of DataDictionaryVersion. Regression tests passed cleanly for me. Committed at subversion revision 1356333.
If nightly tests pass, I plan to port this fix to 10.9 and 10.8.
Touches the following files:
M java/engine/org/apache/derby/impl/sql/LanguageDbPropertySetter.java
M java/testing/org/apache/derbyTesting/functionTests/tests/lang/SQLAuthorizationPropTest.java
> By using syscs_set_database_property, you can set the database version to a garbage string which prevents you from booting the database.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-5838
> URL: https://issues.apache.org/jira/browse/DERBY-5838
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.3.1.4, 10.3.2.1, 10.3.3.0, 10.4.1.3, 10.4.2.0, 10.5.1.1, 10.5.2.0, 10.5.3.0, 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2, 10.8.2.2, 10.9.1.0, 10.10.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Attachments: derby-5838-01-aa-DataDictionaryVersion.diff
>
>
> The following script shows this problem:
> connect 'jdbc:derby:db;create=true';
> values ( syscs_util.syscs_get_database_property( 'DataDictionaryVersion' ) );
> call syscs_util.syscs_set_database_property( 'DataDictionaryVersion', 'foobar' );
> values ( syscs_util.syscs_get_database_property( 'DataDictionaryVersion' ) );
> connect 'jdbc:derby:db;shutdown=true';
> -- fails to boot
> connect 'jdbc:derby:db';
--
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
[jira] [Updated] (DERBY-5838) By using syscs_set_database_property,
you can set the database version to a garbage string which prevents you
from booting the database.
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas updated DERBY-5838:
---------------------------------
Issue & fix info: Repro attached
> By using syscs_set_database_property, you can set the database version to a garbage string which prevents you from booting the database.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-5838
> URL: https://issues.apache.org/jira/browse/DERBY-5838
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.3.1.4, 10.3.2.1, 10.3.3.0, 10.4.1.3, 10.4.2.0, 10.5.1.1, 10.5.2.0, 10.5.3.0, 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2, 10.8.2.2, 10.9.1.0, 10.10.0.0
> Reporter: Rick Hillegas
>
> The following script shows this problem:
> connect 'jdbc:derby:db;create=true';
> values ( syscs_util.syscs_get_database_property( 'DataDictionaryVersion' ) );
> call syscs_util.syscs_set_database_property( 'DataDictionaryVersion', 'foobar' );
> values ( syscs_util.syscs_get_database_property( 'DataDictionaryVersion' ) );
> connect 'jdbc:derby:db;shutdown=true';
> -- fails to boot
> connect 'jdbc:derby:db';
--
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