[DERBY-4110] When deleting rows from a table name with its synonym name, Derby throws SQLSTATE 42X04.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.4.1.3
• Fix Version/s: 10.6.1.0
• Component/s: SQL
• Urgency: Normal
• Assignee: Bryan Pendleton
• Reporter: Lakshmi Prasanna
• Created: 23/Mar/09 10:17
• Updated: 17/Jun/13 09:19
• Resolved: 07/Jan/10 00:11

Description

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?