[teiid-issues] [JBoss JIRA] (TEIID-4848) Google translator does not support ALL in DELETE
Steven Hawkins (JIRA)
issues at jboss.org
Wed Apr 5 07:59:00 EDT 2017
[ https://issues.jboss.org/browse/TEIID-4848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
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)
More information about the teiid-issues
mailing list