[ 
http://issues.apache.org/jira/browse/DERBY-296?page=comments#action_12313825 ] 

David Van Couvering commented on DERBY-296:
-------------------------------------------

Great, Jeff.

For the messages in the doc but not in the VTI, I think I need to respond to 
each in turn:

0A001 - I think this is just a typo, notice that 0A000 is missing from the list
22007 - I am not sure what happened here, you're right, it shows up twice 
(which is a bit disconcerting), each with a different message.  Can anyone 
explain what's going on here and why we don't get conflicts when printing out a 
message?  Or is this just a bug?

  "The syntax of the string representation of a datetime value is incorrect."
  "The string representation of a datetime value is out of range."

42601 is another one that is a duplicate, maybe there's a bug in my program 
where it calls out duplicates as a false positive, but that's probably a good 
thing!  

  "In an ALTER TABLE statement, the column '{0}' has been specified as NOT NULL 
and either the DEFAULT clause was not specified or..." (truncated in ij)
  "ALTER TABLE statement cannot add an IDENTITY column to a table."

42815 - Duplicate
  "The data type, length or value of arguments '{0}' and '{1}' is incompatible.:
  "The replacement value for '{0}' is invalid."

XJ081- Duplicate
  "Invalid value '{0}' passed as parameter '{1}' to method '{2}'"
  "Conflicting create/restore/recovery attributes specified."

I think that these duplicates are probably a separate bug that needs to be 
addressed, probably by adjusting the error numbers so there are no longer 
duplicates.  I am not sure what to recommend for the document -- someone 
looking up an error number may be confused about which one applies.





> Document error messages in the Derby Reference Manual
> -----------------------------------------------------
>
>          Key: DERBY-296
>          URL: http://issues.apache.org/jira/browse/DERBY-296
>      Project: Derby
>         Type: Task
>   Components: Documentation
>     Versions: 10.1.0.0
>  Environment: all
>     Reporter: Jeff Levitt
>     Assignee: Jeff Levitt
>     Priority: Minor
>      Fix For: 10.1.0.0
>  Attachments: ErrorMessageGenerator.java, derby296finaldraft2.zip, 
> results.out, rrefexcept13113.dita
>
> I've spent some time compiling a list of error messages for Derby, to expand 
> on the error messages section currently in the Reference Manual.  I am about 
> ready to submit a candidate patch, and I am opening up a JIRA issue to 
> contain it.

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

Reply via email to