[DERBY-2705] Description of error message for X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference manual is not appropriate.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.2.2.0
• Fix Version/s: 10.10.1.1
• Component/s: Documentation
• Environment: http://db.apache.org/derby/docs/dev/ref/rrefexcept71493.html
• Assignee: Unassigned
• Reporter: Tomohito Nakayama
• Created: 27/May/07 05:50
• Updated: 03/Sep/14 08:31
• Resolved: 28/Nov/12 14:03

Description

I think positions of several words are not right.

X0X61:
The values for column '<location>' in index '<columnName>' and table '<indexName>.<schemaNamet>' do not match for row location <tableName>. The value in the index is '<value>', while the value in the base table is '<value>'. The full index key, including the row location, is '<indexKey>'. The suggested corrective action is to recreate the index.

Corrected to :

The values for column '<columnName>' in index '<indexName>' and table '<schemaNamet>.<tableName>' do not match for row location <location>. The value in the index is '<value>', while the value in the base table is '<value>'. The full index key, including the row location, is '<indexKey>'. The suggested corrective action is to recreate the index.

X0Y59 :

Attempt to add or enable constraint(s) on table '<rowName>' failed because the table contains <constraintName> row(s) that violate the following check constraint(s): <tableName>.

Corrected to :

Attempt to add or enable constraint(s) on table '<tableName>' failed because the table contains <rowName> row(s) that violate the following check constraint(s): <constraintName>.

X0Y69 :
<triggerName> is not supported in trigger <value>.

Corrected to :

<value> is not supported in trigger <triggerName>.

X0Y70 :
INSERT, UPDATE and DELETE are not permitted on table <triggerName> because trigger <tableName> is active.

Corrected to

INSERT, UPDATE and DELETE are not permitted on table <tableName> because trigger <triggerName> is active.

Issue Links

• is related to: DERBY-5885 The order of argument names in messages.xml is sometimes wrong when the arguments occur in the message out of sequence.