db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mayuresh Nirhali (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1072) Misleading/wrong error message while dropping a view
Date Thu, 16 Mar 2006 12:17:58 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1072?page=comments#action_12370681 ] 

Mayuresh Nirhali commented on DERBY-1072:

While a view is being Dropped, the TableDescriptor for the specified view is read. If this
TableDescriptor is null then error X0X05 is thrown with message "Table <ViewName> does
not exist.". This could be confusing to the user.

The fix for this bug is to change the error message to "Table/View <viewname> does not
exist", as suggested earlier.
First, I would like to know if anyone has any other opinion reg. this fix ??
Please take a look at org/apache/derby/impl/sql/execute/DropViewConstantAction.executeConstantAction(Activation)
for the case mentioned in the description.

One more similar case is when, select query is fired on a view that does not exist.
The error message in this case is, "Error 42X05: Table <viewname> does not exist".
I am still looking for more cases, any more pointers are appreciated.

Before, I start looking into how to modify message_XX.properties, I would like to know the
safest way to find out the characters to be added for all the locales.
One way of doing this to find out how '/view' is mapped in other locale properties file.
I am wondering if there are any tools available with us  for such conversion??

> Misleading/wrong error message while dropping a view
> ----------------------------------------------------
>          Key: DERBY-1072
>          URL: http://issues.apache.org/jira/browse/DERBY-1072
>      Project: Derby
>         Type: Bug
>   Components: Newcomer, SQL
>     Versions:
>  Environment: windows xp , jdk1.5
>     Reporter: Manjula Kutty
>     Assignee: Mayuresh Nirhali
>     Priority: Minor

> while dropping a view which does not really exist on a database , the error message thrown
by ij says ERROR X0X05: Table 'VIEW222' does not  exist. It looks like we should make the
error message to say that  "Table/View" does not exist, instead of "table".
> Look at other messages that are shared for both Table and View.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

View raw message