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.
