[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.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 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.1.1
• Fix Version/s: 10.8.3.0, 10.9.2.2, 11.0.0.0
• Component/s: SQL
• Urgency: Normal
• Issue & fix info: Repro attached
• Bug behavior facts: Data corruption
• Assignee: Richard N. Hillegas
• Reporter: Richard N. Hillegas
• Created: 02/Jul/12 12:53
• Updated: 14/Jun/13 17:13
• Resolved: 17/Jul/12 15:39

Description

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';

Issue Links

• relates to: DERBY-5818 values syscs_util.syscs_get_database_property('DataDictionaryVersion' ) does not return full version information