[
https://issues.jboss.org/browse/TEIID-4848?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-4848.
-----------------------------------
Resolution: Rejected
By default there is no concept of a primary or unique key with a spreadsheet. If the user
alters the metadata to have a key, then this style of delete can proceed.
Google translator does not support ALL in DELETE
------------------------------------------------
Key: TEIID-4848
URL:
https://issues.jboss.org/browse/TEIID-4848
Project: Teiid
Issue Type: Bug
Affects Versions: 8.12.10.6_3
Reporter: Lucie Fabrikova
Assignee: Steven Hawkins
Query DELETE FROM SmallA WHERE IntKey > ALL (values(20)) throws exception (debug
mode):
08:05:50,812 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) TEIID30020
Processing exception for request 2md+OVeJxlHo.0 'TEIID30253 Source UPDATE or DELETE
command "DELETE FROM Source.smalla WHERE intkey > ALL (SELECT 20)" contains
non-pushdown constructs and no compensating action can be taken as the table lacks a
unique key or the source does not support equality predicates. '. Originally
QueryPlannerException RelationalPlanner.java:1187.:
org.teiid.api.exception.query.QueryPlannerException: TEIID30253 Source UPDATE or DELETE
command "DELETE FROM Source.smalla WHERE intkey > ALL (SELECT 20)" contains
non-pushdown constructs and no compensating action can be taken as the table lacks a
unique key or the source does not support equality predicates.
at
org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:205)
[teiid-engine-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2]
at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:159)
[teiid-engine-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2]
at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:442)
[teiid-engine-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2]
...
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)