[
https://issues.jboss.org/browse/TEIID-5229?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-5229:
---------------------------------------
The logic is assuming a primary key on the source table. It is possible to infer in this
case, but in general we should just throw a better exception.
Google Spreadsheet translator NoSuchElementException for DELETE with
criteria on char
-------------------------------------------------------------------------------------
Key: TEIID-5229
URL:
https://issues.jboss.org/browse/TEIID-5229
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.12.x-6.4
Reporter: Jan Stastny
Assignee: Steven Hawkins
DELETE fails when there's WHERE criteria on a column with type char.
{code:sql}
DELETE FROM SmallA WHERE CharValue IN ('2', '3')
{code}
Error:
{code}
14:04:41,627 ERROR [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue60) TEIID30019
Unexpected exception for request Bc4xXOpFO/lu.32: java.util.NoSuchElementException
at java.util.ArrayList$Itr.next(ArrayList.java:860) [rt.jar:1.8.0_151]
at org.teiid.query.rewriter.QueryRewriter.createPkCriteria(QueryRewriter.java:3104)
[teiid-engine-8.12.11.6_4-redhat-64-11.jar:8.12.11.6_4-redhat-64-11]
at org.teiid.query.rewriter.QueryRewriter.createDeleteProcedure(QueryRewriter.java:3238)
[teiid-engine-8.12.11.6_4-redhat-64-11.jar:8.12.11.6_4-redhat-64-11]
at org.teiid.query.rewriter.QueryRewriter.rewriteInherentDelete(QueryRewriter.java:3177)
[teiid-engine-8.12.11.6_4-redhat-64-11.jar:8.12.11.6_4-redhat-64-11]
at org.teiid.query.rewriter.QueryRewriter.rewriteDelete(QueryRewriter.java:3130)
[teiid-engine-8.12.11.6_4-redhat-64-11.jar:8.12.11.6_4-redhat-64-11]
at org.teiid.query.rewriter.QueryRewriter.rewriteCommand(QueryRewriter.java:238)
[teiid-engine-8.12.11.6_4-redhat-64-11.jar:8.12.11.6_4-redhat-64-11]
at org.teiid.query.rewriter.QueryRewriter.rewrite(QueryRewriter.java:168)
[teiid-engine-8.12.11.6_4-redhat-64-11.jar:8.12.11.6_4-redhat-64-11]
at org.teiid.query.rewriter.QueryRewriter.rewrite(QueryRewriter.java:172)
[teiid-engine-8.12.11.6_4-redhat-64-11.jar:8.12.11.6_4-redhat-64-11]
at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:426)
[teiid-engine-8.12.11.6_4-redhat-64-11.jar:8.12.11.6_4-redhat-64-11]
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:476)
[teiid-engine-8.12.11.6_4-redhat-64-11.jar:8.12.11.6_4-redhat-64-11]
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:642)
[teiid-engine-8.12.11.6_4-redhat-64-11.jar:8.12.11.6_4-redhat-64-11]
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:337)
[teiid-engine-8.12.11.6_4-redhat-64-11.jar:8.12.11.6_4-redhat-64-11]
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
[teiid-engine-8.12.11.6_4-redhat-64-11.jar:8.12.11.6_4-redhat-64-11]
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274)
[teiid-engine-8.12.11.6_4-redhat-64-11.jar:8.12.11.6_4-redhat-64-11]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:284)
[teiid-engine-8.12.11.6_4-redhat-64-11.jar:8.12.11.6_4-redhat-64-11]
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
[teiid-engine-8.12.11.6_4-redhat-64-11.jar:8.12.11.6_4-redhat-64-11]
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
[teiid-engine-8.12.11.6_4-redhat-64-11.jar:8.12.11.6_4-redhat-64-11]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[rt.jar:1.8.0_151]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[rt.jar:1.8.0_151]
at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_151]
{code}
UPDATE works as expected.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)