db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lakshmi Prasanna (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4110) When deleting rows from a table name with its synonym name, Derby throws SQLSTATE 42X04.
Date Mon, 23 Mar 2009 10:17:50 GMT
When deleting rows from a table name with its synonym name, Derby throws SQLSTATE 42X04.
----------------------------------------------------------------------------------------

                 Key: DERBY-4110
                 URL: https://issues.apache.org/jira/browse/DERBY-4110
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.4.1.3
            Reporter: Lakshmi Prasanna


Getting an error (using Derby 10.4.1.3) when deleting records from a table using a qualified
synonymn name.
Table Name is ABC_PROCESS_INVOCATION_XML and the synonmyn name is SYN_ABC_P_I_X

The query being fired was
"Delete from SYN_ABC_P_I_X where ID = ? "

from the error log
---------------
Caused by: ERROR 42X04: Column 'APP.ABC_PROCESS_INVOCATION_XML.ID' is either not in any table
in the FROM list or appears within a join specification and is outside the scope of the join
specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a
CREATE or ALTER TABLE  statement then 'APP.ABC_PROCESS_INVOCATION_XML.ID' is not a column
in the target table.
---------------

After going thru few earlier bugs, a similar bug has been logged earlier bug DERBY-1784 
http://issues.apache.org/jira/browse/DERBY-1784

But looks like the fix did not make its way to 10.4.1.3?



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


Mime
View raw message