[jira] Updated: (DERBY-1825) Errors 2850A,2850G,28508 are similar - can be combined into a single message.

["Jørgen Løland (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-1825?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jørgen Løland updated DERBY-1825:
---------------------------------

    Attachment: DERBY-1825-1.stat
                DERBY-1825-1.diff

It seems that the effect of merging error messages is that either the messages get ugly due to the "Table/View" text, or information is lost (if I replace "table" with "object" in message 28506). I think this outweighs the positive effects achieved by removing 2 or 3 error codes. Hence, I stop working on this issue.

I'm attaching a patch for future reference that does what I previously described. I.e., error codes 28506, 2850A and 2850G are merged into one error message 28506:

   User '{0}' does not have {1} permission on {2} '{3}'.'{4}'. 

Further, error codes 28507 and 2850B are merged into one message 28507:

   User '{0}' does not have {1} permission on {2} '{3}'.'{4}' for grant.

The patch is not intended for inclusion, and has therefore not been tested.

> Errors 2850A,2850G,28508 are similar - can be combined into a single message.
> -----------------------------------------------------------------------------
>
>                 Key: DERBY-1825
>                 URL: https://issues.apache.org/jira/browse/DERBY-1825
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Daniel John Debrunner
>         Assigned To: Jørgen Løland
>         Attachments: DERBY-1825-1.diff, DERBY-1825-1.stat
>
>
> ERROR 2850A: User 'SAM' does not have execute permission on PROCEDURE 'SYSCS_UTIL'.'SYSCS_EXPORT_TABLE'.
> ERROR 2850G: User 'MAMTA2' does not have grant permission on object 'MAMTA2'.'V21VIEWTEST'.
> ERROR 28508: User 'MAMTA3' does not have select permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.