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 "Tomohito Nakayama (JIRA)" <ji...@apache.org> on 2007/05/27 07:51:16 UTC
[jira] Created: (DERBY-2705) Description of error message for X0X61
in SQL error messages and exceptions of Reference manual is not
appropriate.
Description of error message for X0X61 in SQL error messages and exceptions of Reference manual is not appropriate.
-------------------------------------------------------------------------------------------------------------------
Key: DERBY-2705
URL: https://issues.apache.org/jira/browse/DERBY-2705
Project: Derby
Issue Type: Bug
Reporter: Tomohito Nakayama
I found next description.
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.
I think positions of several words are not right.
I think next is right locations.
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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2705) Description of error message for
X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference
manual is not appropriate.
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tomohito Nakayama updated DERBY-2705:
-------------------------------------
Summary: Description of error message for X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference manual is not appropriate. (was: Description of error message for X0X61/X0Y59/X0Y70 in SQL error messages and exceptions of Reference manual is not appropriate.)
Sorry.
I took wrong X0Y70 and X0Y69 in previous EDIT.
X0Y70 :
INSERT, UPDATE and DELETE are not permitted on table <triggerName> because trigger <tableName> is active.
This should be
INSERT, UPDATE and DELETE are not permitted on table <tableName> because trigger <triggerName> is active.
X0Y69 :
Same as previous comment.
> Description of error message for X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference manual is not appropriate.
> -------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2705
> URL: https://issues.apache.org/jira/browse/DERBY-2705
> Project: Derby
> Issue Type: Bug
> Reporter: Tomohito Nakayama
>
> I found next description.
> 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.
> I think positions of several words are not right.
> I think next is right locations.
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2705) Description of error message for
X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference
manual is not appropriate.
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12504256 ]
Tomohito Nakayama commented on DERBY-2705:
------------------------------------------
I found next codes in source files.
lines in SQLState.java :
String LANG_INDEX_COLUMN_NOT_EQUAL = "X0X61.S";
String LANG_ADD_CHECK_CONSTRAINT_FAILED = "X0Y59.S";
String LANG_NO_DML_IN_TRIGGER = "X0Y70.S";
codes to generate error messages :
java/engine/org/apache/derby/iapi/db/ConsistencyChecker.java:356
throw StandardException.newException(
SQLState.LANG_INDEX_COLUMN_NOT_EQUAL,
indexCD.getConglomerateName(),
td.getSchemaName(),
td.getName(),
baseRL.toString(),
cd.getColumnName(),
indexColumn.toString(),
baseColumn.toString(),
indexRow.toString());
java/shared/org/apache/derby/shared/common/reference/SQLState.java:1281
if (isCheckConstraint)
throw StandardException.newException(SQLState.LANG_ADD_CHECK_CONSTRAINT_FAILED,
constraintName, td.getQualifiedName(), value.toString());
I could not find code to generate error message for LANG_NO_DML_IN_TRIGGER ...
> Description of error message for X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference manual is not appropriate.
> -------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2705
> URL: https://issues.apache.org/jira/browse/DERBY-2705
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefexcept71493.html
> Reporter: Tomohito Nakayama
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2705) Description of error message for
X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference
manual is not appropriate.
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12504264 ]
Tomohito Nakayama commented on DERBY-2705:
------------------------------------------
Oops.
I missed some informations ....
I post again.
contents in messages.xml :
<msg>
<name>X0X61.S</name>
<text>The values for column '{4}' in index '{0}' and table '{1}.{2}' do not match for row location {3}. The value in the index is '{5}', while the value in the base table is '{6}'. The full index key, including the row location, is '{7}'. The suggested corrective action is to recreate the index.</text>
<arg>columnName</arg>
<arg>indexName</arg>
<arg>schemaNamet</arg>
<arg>tableName</arg>
<arg>location</arg>
<arg>value</arg>
<arg>value</arg>
<arg>indexKey</arg>
</msg>
<msg>
<name>X0Y59.S</name>
<text>Attempt to add or enable constraint(s) on table '{1}' failed because the table contains {2} row(s) that violate the following check constraint(s): {0}.</text>
<arg>tableName</arg>
<arg>rowName</arg>
<arg>constraintName</arg>
</msg>
<msg>
<name>X0Y69.S</name>
<text>{1} is not supported in trigger {0}.</text>
<arg>value</arg>
<arg>triggerName</arg>
</msg>
<msg>
<name>X0Y70.S</name>
<text>INSERT, UPDATE and DELETE are not permitted on table {1} because trigger {0} is active.</text>
<arg>tableName</arg>
<arg>triggerName</arg>
</msg>
lines in SQLState.java :
String LANG_INDEX_COLUMN_NOT_EQUAL = "X0X61.S";
String LANG_ADD_CHECK_CONSTRAINT_FAILED = "X0Y59.S";
String LANG_NO_DDL_IN_TRIGGER = "X0Y69.S";
String LANG_NO_DML_IN_TRIGGER = "X0Y70.S";
codes to generate error messages :
java/engine/org/apache/derby/iapi/db/ConsistencyChecker.java:356
throw StandardException.newException(
SQLState.LANG_INDEX_COLUMN_NOT_EQUAL,
indexCD.getConglomerateName(),
td.getSchemaName(),
td.getName(),
baseRL.toString(),
cd.getColumnName(),
indexColumn.toString(),
baseColumn.toString(),
indexRow.toString());
java/shared/org/apache/derby/shared/common/reference/SQLState.java:1281
if (isCheckConstraint)
throw StandardException.newException(SQLState.LANG_ADD_CHECK_CONSTRAINT_FAILED,
constraintName, td.getQualifiedName(), value.toString());
java/engine/org/apache/derby/impl/sql/execute/InternalTriggerExecutionContext.java:338
throw StandardException.newException(SQLState.LANG_NO_DDL_IN_TRIGGER, triggerd.getName(), constantAction.toString());
> Description of error message for X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference manual is not appropriate.
> -------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2705
> URL: https://issues.apache.org/jira/browse/DERBY-2705
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefexcept71493.html
> Reporter: Tomohito Nakayama
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2705) Description of error message for
X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference
manual is not appropriate.
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12504243 ]
Tomohito Nakayama commented on DERBY-2705:
------------------------------------------
Not sure yet ....
Reading messages of program translated to Japanese,
I came to suspect both.
I will survery.
> Description of error message for X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference manual is not appropriate.
> -------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2705
> URL: https://issues.apache.org/jira/browse/DERBY-2705
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefexcept71493.html
> Reporter: Tomohito Nakayama
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2705) Description of error message for
X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference
manual is not appropriate.
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12504272 ]
Tomohito Nakayama commented on DERBY-2705:
------------------------------------------
I think contents of arg element in message.xml are mistaken and
others are correct.
> Description of error message for X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference manual is not appropriate.
> -------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2705
> URL: https://issues.apache.org/jira/browse/DERBY-2705
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefexcept71493.html
> Reporter: Tomohito Nakayama
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2705) Description of error message for
X0X61 in SQL error messages and exceptions of Reference manual is not
appropriate.
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12499392 ]
Tomohito Nakayama commented on DERBY-2705:
------------------------------------------
Resembling problem exists in X0Y59 too.
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>.
The description should be
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>.
> Description of error message for X0X61 in SQL error messages and exceptions of Reference manual is not appropriate.
> -------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2705
> URL: https://issues.apache.org/jira/browse/DERBY-2705
> Project: Derby
> Issue Type: Bug
> Reporter: Tomohito Nakayama
>
> I found next description.
> 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.
> I think positions of several words are not right.
> I think next is right locations.
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2705) Description of error message for
X0X61/X0Y59 in SQL error messages and exceptions of Reference manual is not
appropriate.
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12499394 ]
Tomohito Nakayama commented on DERBY-2705:
------------------------------------------
In X0Y59, I think <rowName> is <rowCount>.
> Description of error message for X0X61/X0Y59 in SQL error messages and exceptions of Reference manual is not appropriate.
> -------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2705
> URL: https://issues.apache.org/jira/browse/DERBY-2705
> Project: Derby
> Issue Type: Bug
> Reporter: Tomohito Nakayama
>
> I found next description.
> 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.
> I think positions of several words are not right.
> I think next is right locations.
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2705) Description of error message for
X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference
manual is not appropriate.
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12504090 ]
Laura Stewart commented on DERBY-2705:
--------------------------------------
Tomohito - Are the descriptions only incorrect in the Ref Manual or in the code as well?
> Description of error message for X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference manual is not appropriate.
> -------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2705
> URL: https://issues.apache.org/jira/browse/DERBY-2705
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefexcept71493.html
> Reporter: Tomohito Nakayama
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2705) Description of error message for
X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference
manual is not appropriate.
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tomohito Nakayama updated DERBY-2705:
-------------------------------------
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.
was:
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.
> Description of error message for X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference manual is not appropriate.
> -------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2705
> URL: https://issues.apache.org/jira/browse/DERBY-2705
> Project: Derby
> Issue Type: Bug
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefexcept71493.html
> Reporter: Tomohito Nakayama
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2705) Description of error message for
X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference
manual is not appropriate.
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tomohito Nakayama updated DERBY-2705:
-------------------------------------
Environment: http://db.apache.org/derby/docs/dev/ref/rrefexcept71493.html
> Description of error message for X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference manual is not appropriate.
> -------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2705
> URL: https://issues.apache.org/jira/browse/DERBY-2705
> Project: Derby
> Issue Type: Bug
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefexcept71493.html
> Reporter: Tomohito Nakayama
>
> I found next description.
> 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.
> I think positions of several words are not right.
> I think next is right locations.
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2705) Description of error message for
X0X61/X0Y59 in SQL error messages and exceptions of Reference manual is not
appropriate.
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tomohito Nakayama updated DERBY-2705:
-------------------------------------
Summary: Description of error message for X0X61/X0Y59 in SQL error messages and exceptions of Reference manual is not appropriate. (was: Description of error message for X0X61 in SQL error messages and exceptions of Reference manual is not appropriate.)
> Description of error message for X0X61/X0Y59 in SQL error messages and exceptions of Reference manual is not appropriate.
> -------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2705
> URL: https://issues.apache.org/jira/browse/DERBY-2705
> Project: Derby
> Issue Type: Bug
> Reporter: Tomohito Nakayama
>
> I found next description.
> 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.
> I think positions of several words are not right.
> I think next is right locations.
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2705) Description of error message for
X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference
manual is not appropriate.
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tomohito Nakayama updated DERBY-2705:
-------------------------------------
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.
was:
I found next description.
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.
I think positions of several words are not right.
I think next is right locations.
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.
I updated description of this issue to add X0Y59/X0Y69/X0Y70.
> Description of error message for X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference manual is not appropriate.
> -------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2705
> URL: https://issues.apache.org/jira/browse/DERBY-2705
> Project: Derby
> Issue Type: Bug
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefexcept71493.html
> Reporter: Tomohito Nakayama
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2705) Description of error message for
X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference
manual is not appropriate.
Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Myrna van Lunteren updated DERBY-2705:
--------------------------------------
Component/s: Documentation
> Description of error message for X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference manual is not appropriate.
> -------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2705
> URL: https://issues.apache.org/jira/browse/DERBY-2705
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefexcept71493.html
> Reporter: Tomohito Nakayama
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2705) Description of error message for
X0X61/X0Y59/X0Y70 in SQL error messages and exceptions of Reference manual
is not appropriate.
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tomohito Nakayama updated DERBY-2705:
-------------------------------------
Summary: Description of error message for X0X61/X0Y59/X0Y70 in SQL error messages and exceptions of Reference manual is not appropriate. (was: Description of error message for X0X61/X0Y59 in SQL error messages and exceptions of Reference manual is not appropriate.)
I think X0Y70 have resembling problem.
<triggerName> is not supported in trigger <value>.
I think correct description is next.
<value> is not supported in trigger <triggerName>.
> Description of error message for X0X61/X0Y59/X0Y70 in SQL error messages and exceptions of Reference manual is not appropriate.
> -------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2705
> URL: https://issues.apache.org/jira/browse/DERBY-2705
> Project: Derby
> Issue Type: Bug
> Reporter: Tomohito Nakayama
>
> I found next description.
> 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.
> I think positions of several words are not right.
> I think next is right locations.
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2705) Description of error message for
X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference
manual is not appropriate.
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12504251 ]
Tomohito Nakayama commented on DERBY-2705:
------------------------------------------
I found next contents in java/engine/org/apache/derby/loc/messages.xml
<msg>
<name>X0X61.S</name>
<text>The values for column '{4}' in index '{0}' and table '{1}.{2}' do not match for row location {3}. The value in the index is '{5}', while the value in the base table is '{6}'. The full index key, including the row location, is '{7}'. The suggested corrective action is to recreate the index.</text>
<arg>columnName</arg>
<arg>indexName</arg>
<arg>schemaNamet</arg>
<arg>tableName</arg>
<arg>location</arg>
<arg>value</arg>
<arg>value</arg>
<arg>indexKey</arg>
</msg>
<msg>
<name>X0Y69.S</name>
<text>{1} is not supported in trigger {0}.</text>
<arg>value</arg>
<arg>triggerName</arg>
</msg>
<msg>
<name>X0Y70.S</name>
<text>INSERT, UPDATE and DELETE are not permitted on table {1} because trigger {0} is active.</text>
<arg>tableName</arg>
<arg>triggerName</arg>
</msg>
Hmm ... :I
> Description of error message for X0X61/X0Y59/X0Y69/X0Y70 in SQL error messages and exceptions of Reference manual is not appropriate.
> -------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2705
> URL: https://issues.apache.org/jira/browse/DERBY-2705
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefexcept71493.html
> Reporter: Tomohito Nakayama
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.