[
https://issues.apache.org/jira/browse/DERBY-4110?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12782340#action_12782340
]
Boris Just commented on DERBY-4110:
-----------------------------------
I have the same Problem. We are already working with Derby 10.1.3.1. We
upgraded to Version 10.5.3.0 and encrypted the database with
dataEncryption=true. Everything works fine. Only deletes on synonym tables fail
with ERROR 42X04 and the mentioned message. I have also tried 10.4.1.3 and it
also failed.
> 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
> Assignee: Bryan Pendleton
>
> 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.
