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 "Laura Stewart (JIRA)" <de...@db.apache.org> on 2006/09/09 00:15:22 UTC
[jira] Created: (DERBY-1835) SQL State Messages need to be reviewed
and improved for clarity and completeness.
SQL State Messages need to be reviewed and improved for clarity and completeness.
---------------------------------------------------------------------------------
Key: DERBY-1835
URL: http://issues.apache.org/jira/browse/DERBY-1835
Project: Derby
Issue Type: Improvement
Components: Documentation
Affects Versions: 10.2.1.0
Reporter: Laura Stewart
The SQL State messages in the Reference Manual need to be reviewed and cleaned up.
Some of the problems are:
- Unclear messages, object that the message refers to is not not clear
- Message too brief
- Capitalization of data types
- Capitalization of the sentence beginning word
- Missing punctuation
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1835) SQL State Messages need to be
reviewed and improved for clarity and completeness.
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1835?page=comments#action_12433512 ]
Laura Stewart commented on DERBY-1835:
--------------------------------------
Examples:
#1
XCL41 "the delete rule of foreign key can not be CASCADE. (The
relationship would cause another table to be delete-connected to the same
table through multiple paths with different delete rules or with delete rule
equal to SET NULL.)"
- The first word "the" needs to be "The"
- "can not" should be one word
- The second sentence does not need the parenthesis
#2
Message XJ215 should be updated to reflect that Clob/Blob are referring to method calls.
The data types are not capitalized in Java. The message code needs to be changed not just
the text.
The message should be:
XJ215 You cannot invoke other java.sql.Clob/java.sql.Blob methods after
calling the free() method."
> SQL State Messages need to be reviewed and improved for clarity and completeness.
> ---------------------------------------------------------------------------------
>
> Key: DERBY-1835
> URL: http://issues.apache.org/jira/browse/DERBY-1835
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.0
> Reporter: Laura Stewart
>
> The SQL State messages in the Reference Manual need to be reviewed and cleaned up.
> Some of the problems are:
> - Unclear messages, object that the message refers to is not not clear
> - Message too brief
> - Capitalization of data types
> - Capitalization of the sentence beginning word
> - Missing punctuation
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1835) SQL State Messages need to be reviewed
and improved for clarity and completeness.
Posted by "Mike Matrigali (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1835?page=all ]
Mike Matrigali updated DERBY-1835:
----------------------------------
This issue is sort of generic. To get some progress here the best case would be:
o submit a patch with proposed changes to the actual message file and the with the various test master
files fixed.
If someone is interested in working on just the "english" part of this project I or another committer
may be able to help on the test master side. I would suggest posting a patch with proposed changes
to the error messages, working incrementally so not too many masters at a time. It would be much
better to post the actual message file patch, then to try and describe the changes.
> SQL State Messages need to be reviewed and improved for clarity and completeness.
> ---------------------------------------------------------------------------------
>
> Key: DERBY-1835
> URL: http://issues.apache.org/jira/browse/DERBY-1835
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.0
> Reporter: Laura Stewart
>
> The SQL State messages in the Reference Manual need to be reviewed and cleaned up.
> Some of the problems are:
> - Unclear messages, object that the message refers to is not not clear
> - Message too brief
> - Capitalization of data types
> - Capitalization of the sentence beginning word
> - Missing punctuation
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1835) SQL State Messages need to be
reviewed and improved for clarity and completeness.
Posted by "David Van Couvering (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1835?page=comments#action_12433515 ]
David Van Couvering commented on DERBY-1835:
--------------------------------------------
Please be sure to make these changes in the java/engine/org/apache/derby/loc/messages_en.properties. And be aware, *very aware*, that every time you change a message test you are likely to engender numerous diffs in the derbyall regression suite. I speak from Experience.
> SQL State Messages need to be reviewed and improved for clarity and completeness.
> ---------------------------------------------------------------------------------
>
> Key: DERBY-1835
> URL: http://issues.apache.org/jira/browse/DERBY-1835
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.0
> Reporter: Laura Stewart
>
> The SQL State messages in the Reference Manual need to be reviewed and cleaned up.
> Some of the problems are:
> - Unclear messages, object that the message refers to is not not clear
> - Message too brief
> - Capitalization of data types
> - Capitalization of the sentence beginning word
> - Missing punctuation
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1835) SQL State Messages need to be
reviewed and improved for clarity and completeness.
Posted by "David Van Couvering (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1835?page=comments#action_12433516 ]
David Van Couvering commented on DERBY-1835:
--------------------------------------------
Oh, and these diffs are encountered across all VMs and drivers, so there is quite an explosion of diffs. JDK 1.3, 1.4, 1.6, embedded driver, network client driver, and IBM j9 driver all are impacted by message changes.
> SQL State Messages need to be reviewed and improved for clarity and completeness.
> ---------------------------------------------------------------------------------
>
> Key: DERBY-1835
> URL: http://issues.apache.org/jira/browse/DERBY-1835
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.0
> Reporter: Laura Stewart
>
> The SQL State messages in the Reference Manual need to be reviewed and cleaned up.
> Some of the problems are:
> - Unclear messages, object that the message refers to is not not clear
> - Message too brief
> - Capitalization of data types
> - Capitalization of the sentence beginning word
> - Missing punctuation
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1835) SQL State Messages need to be
reviewed and improved for clarity and completeness.
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1835?page=comments#action_12433517 ]
Laura Stewart commented on DERBY-1835:
--------------------------------------
Another example:
XJ100.
At the end of the message text, there is an exclamation point and a close quotation
mark. Both should be removed and a period should end the message
text.
The fact that a warning is returned is sufficient, the exclamation
point is unnecessary.
The current text is:
XJ100 The scale supplied by the registerOutParameter method
does not match with the setter method. Possible loss of precision!"
> SQL State Messages need to be reviewed and improved for clarity and completeness.
> ---------------------------------------------------------------------------------
>
> Key: DERBY-1835
> URL: http://issues.apache.org/jira/browse/DERBY-1835
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.0
> Reporter: Laura Stewart
>
> The SQL State messages in the Reference Manual need to be reviewed and cleaned up.
> Some of the problems are:
> - Unclear messages, object that the message refers to is not not clear
> - Message too brief
> - Capitalization of data types
> - Capitalization of the sentence beginning word
> - Missing punctuation
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira