[JBoss JIRA] (TEIID-5838) Add a vdb load timeout
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5838?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5838:
---------------------------------------
Made a determination on TEIIDTOOLS-820 that the changes for TEIID-5814 were incomplete. With an additional change this issue moves to much lower priority.
> Add a vdb load timeout
> ----------------------
>
> Key: TEIID-5838
> URL: https://issues.jboss.org/browse/TEIID-5838
> Project: Teiid
> Issue Type: Quality Risk
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 13.x
>
>
> Source vdb loads should timeout to prevent refresh and other issues.
> Note: this may be implemented in core Teiid, in which case this issue will be moved.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 5 months
[JBoss JIRA] (TEIID-5838) Add a vdb load timeout
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5838?page=com.atlassian.jira.plugin... ]
Steven Hawkins moved TEIIDTOOLS-822 to TEIID-5838:
--------------------------------------------------
Project: Teiid (was: Teiid Tools)
Key: TEIID-5838 (was: TEIIDTOOLS-822)
Component/s: Query Engine
(was: core)
> Add a vdb load timeout
> ----------------------
>
> Key: TEIID-5838
> URL: https://issues.jboss.org/browse/TEIID-5838
> Project: Teiid
> Issue Type: Quality Risk
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 13.x
>
>
> Source vdb loads should timeout to prevent refresh and other issues.
> Note: this may be implemented in core Teiid, in which case this issue will be moved.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 5 months
[JBoss JIRA] (TEIID-5834) Class cast exception using web service with bind varables
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5834?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-5834:
----------------------------------
Story Points: 3
> Class cast exception using web service with bind varables
> ---------------------------------------------------------
>
> Key: TEIID-5834
> URL: https://issues.jboss.org/browse/TEIID-5834
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 11.1.2
> Reporter: Mike Higgins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 13.0, 12.3.1
>
>
> I am using a restful web service, which works fine if literal values are used to constrain it. However, when I use bind variables, it gives me a traceback:
> java.lang.ClassCastException: org.teiid.query.sql.lang.ImmutableCompareCriteria cannot be cast to org.teiid.query.sql.lang.AbstractSetCriteria
> at org.teiid.query.processor.relational.DependentCriteriaProcessor.prepareCriteria(DependentCriteriaProcessor.java:352)
> at org.teiid.query.processor.relational.DependentProcedureCriteriaProcessor.prepareNextCommand(DependentProcedureCriteriaProcessor.java:60)
> at org.teiid.query.processor.relational.DependentProcedureExecutionNode.prepareNextCommand(DependentProcedureExecutionNode.java:88)
> at org.teiid.query.processor.relational.PlanExecutionNode.open(PlanExecutionNode.java:79)
> at org.teiid.query.processor.relational.DependentProcedureExecutionNode.open(DependentProcedureExecutionNode.java:108)
> at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
> at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
> at org.teiid.query.processor.relational.JoinStrategy.openRight(JoinStrategy.java:101)
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirectInternal(JoinNode.java:256)
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:200)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:492)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:362)
> ... 8 more
> The SQL is:
> <not shown for internal security reasons -- used a dependent join to a web service using an 'in' operator>,
>
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 5 months
[JBoss JIRA] (TEIID-5834) Class cast exception using web service with bind varables
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5834?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-5834:
----------------------------------
Component/s: Query Engine
> Class cast exception using web service with bind varables
> ---------------------------------------------------------
>
> Key: TEIID-5834
> URL: https://issues.jboss.org/browse/TEIID-5834
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 11.1.2
> Reporter: Mike Higgins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 13.0, 12.3.1
>
>
> I am using a restful web service, which works fine if literal values are used to constrain it. However, when I use bind variables, it gives me a traceback:
> java.lang.ClassCastException: org.teiid.query.sql.lang.ImmutableCompareCriteria cannot be cast to org.teiid.query.sql.lang.AbstractSetCriteria
> at org.teiid.query.processor.relational.DependentCriteriaProcessor.prepareCriteria(DependentCriteriaProcessor.java:352)
> at org.teiid.query.processor.relational.DependentProcedureCriteriaProcessor.prepareNextCommand(DependentProcedureCriteriaProcessor.java:60)
> at org.teiid.query.processor.relational.DependentProcedureExecutionNode.prepareNextCommand(DependentProcedureExecutionNode.java:88)
> at org.teiid.query.processor.relational.PlanExecutionNode.open(PlanExecutionNode.java:79)
> at org.teiid.query.processor.relational.DependentProcedureExecutionNode.open(DependentProcedureExecutionNode.java:108)
> at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
> at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
> at org.teiid.query.processor.relational.JoinStrategy.openRight(JoinStrategy.java:101)
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirectInternal(JoinNode.java:256)
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:200)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:492)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:362)
> ... 8 more
> The SQL is:
> <not shown for internal security reasons -- used a dependent join to a web service using an 'in' operator>,
>
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 5 months
[JBoss JIRA] (TEIID-5834) Class cast exception using web service with bind varables
by Mike Higgins (Jira)
[ https://issues.jboss.org/browse/TEIID-5834?page=com.atlassian.jira.plugin... ]
Mike Higgins updated TEIID-5834:
--------------------------------
Description:
I am using a restful web service, which works fine if literal values are used to constrain it. However, when I use bind variables, it gives me a traceback:
java.lang.ClassCastException: org.teiid.query.sql.lang.ImmutableCompareCriteria cannot be cast to org.teiid.query.sql.lang.AbstractSetCriteria
at org.teiid.query.processor.relational.DependentCriteriaProcessor.prepareCriteria(DependentCriteriaProcessor.java:352)
at org.teiid.query.processor.relational.DependentProcedureCriteriaProcessor.prepareNextCommand(DependentProcedureCriteriaProcessor.java:60)
at org.teiid.query.processor.relational.DependentProcedureExecutionNode.prepareNextCommand(DependentProcedureExecutionNode.java:88)
at org.teiid.query.processor.relational.PlanExecutionNode.open(PlanExecutionNode.java:79)
at org.teiid.query.processor.relational.DependentProcedureExecutionNode.open(DependentProcedureExecutionNode.java:108)
at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
at org.teiid.query.processor.relational.JoinStrategy.openRight(JoinStrategy.java:101)
at org.teiid.query.processor.relational.JoinNode.nextBatchDirectInternal(JoinNode.java:256)
at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:200)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:492)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:362)
... 8 more
The SQL is:
<not shown for internal security reasons -- used a dependent join to a web service using an 'in' operator>,
was:
I am using a restful web service, which works fine if literal values are used to constrain it. However, when I use bind variables, it gives me a traceback:
java.lang.ClassCastException: org.teiid.query.sql.lang.ImmutableCompareCriteria cannot be cast to org.teiid.query.sql.lang.AbstractSetCriteria
at org.teiid.query.processor.relational.DependentCriteriaProcessor.prepareCriteria(DependentCriteriaProcessor.java:352)
at org.teiid.query.processor.relational.DependentProcedureCriteriaProcessor.prepareNextCommand(DependentProcedureCriteriaProcessor.java:60)
at org.teiid.query.processor.relational.DependentProcedureExecutionNode.prepareNextCommand(DependentProcedureExecutionNode.java:88)
at org.teiid.query.processor.relational.PlanExecutionNode.open(PlanExecutionNode.java:79)
at org.teiid.query.processor.relational.DependentProcedureExecutionNode.open(DependentProcedureExecutionNode.java:108)
at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
at org.teiid.query.processor.relational.JoinStrategy.openRight(JoinStrategy.java:101)
at org.teiid.query.processor.relational.JoinNode.nextBatchDirectInternal(JoinNode.java:256)
at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:200)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:492)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:362)
... 8 more
The SQL is:
<deleted for internal security reasons -- showed a dependent join to a web service using an 'in' operator>,
Where WS_CLUSTER is the web service. I didn't find any issues about this so I was not sure if a later version would work.
> Class cast exception using web service with bind varables
> ---------------------------------------------------------
>
> Key: TEIID-5834
> URL: https://issues.jboss.org/browse/TEIID-5834
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 11.1.2
> Reporter: Mike Higgins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 13.0, 12.3.1
>
>
> I am using a restful web service, which works fine if literal values are used to constrain it. However, when I use bind variables, it gives me a traceback:
> java.lang.ClassCastException: org.teiid.query.sql.lang.ImmutableCompareCriteria cannot be cast to org.teiid.query.sql.lang.AbstractSetCriteria
> at org.teiid.query.processor.relational.DependentCriteriaProcessor.prepareCriteria(DependentCriteriaProcessor.java:352)
> at org.teiid.query.processor.relational.DependentProcedureCriteriaProcessor.prepareNextCommand(DependentProcedureCriteriaProcessor.java:60)
> at org.teiid.query.processor.relational.DependentProcedureExecutionNode.prepareNextCommand(DependentProcedureExecutionNode.java:88)
> at org.teiid.query.processor.relational.PlanExecutionNode.open(PlanExecutionNode.java:79)
> at org.teiid.query.processor.relational.DependentProcedureExecutionNode.open(DependentProcedureExecutionNode.java:108)
> at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
> at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
> at org.teiid.query.processor.relational.JoinStrategy.openRight(JoinStrategy.java:101)
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirectInternal(JoinNode.java:256)
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:200)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:492)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:362)
> ... 8 more
> The SQL is:
> <not shown for internal security reasons -- used a dependent join to a web service using an 'in' operator>,
>
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 5 months
[JBoss JIRA] (TEIID-5834) Class cast exception using web service with bind varables
by Mike Higgins (Jira)
[ https://issues.jboss.org/browse/TEIID-5834?page=com.atlassian.jira.plugin... ]
Mike Higgins updated TEIID-5834:
--------------------------------
Description:
I am using a restful web service, which works fine if literal values are used to constrain it. However, when I use bind variables, it gives me a traceback:
java.lang.ClassCastException: org.teiid.query.sql.lang.ImmutableCompareCriteria cannot be cast to org.teiid.query.sql.lang.AbstractSetCriteria
at org.teiid.query.processor.relational.DependentCriteriaProcessor.prepareCriteria(DependentCriteriaProcessor.java:352)
at org.teiid.query.processor.relational.DependentProcedureCriteriaProcessor.prepareNextCommand(DependentProcedureCriteriaProcessor.java:60)
at org.teiid.query.processor.relational.DependentProcedureExecutionNode.prepareNextCommand(DependentProcedureExecutionNode.java:88)
at org.teiid.query.processor.relational.PlanExecutionNode.open(PlanExecutionNode.java:79)
at org.teiid.query.processor.relational.DependentProcedureExecutionNode.open(DependentProcedureExecutionNode.java:108)
at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
at org.teiid.query.processor.relational.JoinStrategy.openRight(JoinStrategy.java:101)
at org.teiid.query.processor.relational.JoinNode.nextBatchDirectInternal(JoinNode.java:256)
at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:200)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:492)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:362)
... 8 more
The SQL is:
<deleted for internal security reasons -- showed a dependent join to a web service using an 'in' operator>,
Where WS_CLUSTER is the web service. I didn't find any issues about this so I was not sure if a later version would work.
was:
I am using a restful web service, which works fine if literal values are used to constrain it. However, when I use bind variables, it gives me a traceback:
java.lang.ClassCastException: org.teiid.query.sql.lang.ImmutableCompareCriteria cannot be cast to org.teiid.query.sql.lang.AbstractSetCriteria
at org.teiid.query.processor.relational.DependentCriteriaProcessor.prepareCriteria(DependentCriteriaProcessor.java:352)
at org.teiid.query.processor.relational.DependentProcedureCriteriaProcessor.prepareNextCommand(DependentProcedureCriteriaProcessor.java:60)
at org.teiid.query.processor.relational.DependentProcedureExecutionNode.prepareNextCommand(DependentProcedureExecutionNode.java:88)
at org.teiid.query.processor.relational.PlanExecutionNode.open(PlanExecutionNode.java:79)
at org.teiid.query.processor.relational.DependentProcedureExecutionNode.open(DependentProcedureExecutionNode.java:108)
at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
at org.teiid.query.processor.relational.JoinStrategy.openRight(JoinStrategy.java:101)
at org.teiid.query.processor.relational.JoinNode.nextBatchDirectInternal(JoinNode.java:256)
at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:200)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:492)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:362)
... 8 more
The SQL is:
SELECT CAIMANM.LM_BIOLOGICAL_SYSTEM."BIOLOGICAL_SYSTEM_UID",
WS_CLUSTER.WS_CLUSTER_T."VH_SPECIES",
WS_CLUSTER.WS_CLUSTER_T."PROJECT_SHORT_NAME",
WS_CLUSTER.WS_CLUSTER_T."biosysid"
FROM caimanm.lm_biological_system
LEFT OUTER JOIN WS_cluster.WS_cluster_t
ON (CAIMANM.LM_BIOLOGICAL_SYSTEM."BIOLOGICAL_SYSTEM_UID" = WS_CLUSTER.WS_CLUSTER_T."biosysid")
AND (WS_CLUSTER.WS_CLUSTER_T."biosysid" in (?, ?, ?))
WHERE (CAIMANM.LM_BIOLOGICAL_SYSTEM."BIOLOGICAL_SYSTEM_UID" in (?, ?, ?))
Where WS_CLUSTER is the web service. I didn't find any issues about this so I was not sure if a later version would work.
> Class cast exception using web service with bind varables
> ---------------------------------------------------------
>
> Key: TEIID-5834
> URL: https://issues.jboss.org/browse/TEIID-5834
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 11.1.2
> Reporter: Mike Higgins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 13.0, 12.3.1
>
>
> I am using a restful web service, which works fine if literal values are used to constrain it. However, when I use bind variables, it gives me a traceback:
> java.lang.ClassCastException: org.teiid.query.sql.lang.ImmutableCompareCriteria cannot be cast to org.teiid.query.sql.lang.AbstractSetCriteria
> at org.teiid.query.processor.relational.DependentCriteriaProcessor.prepareCriteria(DependentCriteriaProcessor.java:352)
> at org.teiid.query.processor.relational.DependentProcedureCriteriaProcessor.prepareNextCommand(DependentProcedureCriteriaProcessor.java:60)
> at org.teiid.query.processor.relational.DependentProcedureExecutionNode.prepareNextCommand(DependentProcedureExecutionNode.java:88)
> at org.teiid.query.processor.relational.PlanExecutionNode.open(PlanExecutionNode.java:79)
> at org.teiid.query.processor.relational.DependentProcedureExecutionNode.open(DependentProcedureExecutionNode.java:108)
> at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
> at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
> at org.teiid.query.processor.relational.JoinStrategy.openRight(JoinStrategy.java:101)
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirectInternal(JoinNode.java:256)
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:200)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:492)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:362)
> ... 8 more
> The SQL is:
> <deleted for internal security reasons -- showed a dependent join to a web service using an 'in' operator>,
> Where WS_CLUSTER is the web service. I didn't find any issues about this so I was not sure if a later version would work.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 5 months
[JBoss JIRA] (TEIID-5798) Mixed PERMISSION GRANTS
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5798?page=com.atlassian.jira.plugin... ]
Work on TEIID-5798 started by Steven Hawkins.
---------------------------------------------
> Mixed PERMISSION GRANTS
> -----------------------
>
> Key: TEIID-5798
> URL: https://issues.jboss.org/browse/TEIID-5798
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Reporter: Christoph John
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 13.0
>
>
> Hello,
> I am currently trying to set a set of permissions on a table/view. Hence a condition on INSERT,UPDATE,DELETE and an unconditioned SELECT.
> However, it seems that conditioned and unconditioned GRANT statements do not work together.
> GRANT INSERT,UPDATE,DELETE ON TABLE "my_nutri_diary.UserDefinedProducts_SRC" CONDITION 'UserDefinedProducts_SRC.fkProfile in (SELECT Account.idProfile FROM Account WHERE Account.uuidUser = LEFT(user(), 36) )' TO odata;
> GRANT SELECT ON TABLE "my_nutri_diary.UserDefinedProducts_SRC" TO odata;
> REVOKE ALTER,EXECUTE ON TABLE "my_nutri_diary.UserDefinedProducts_SRC" FROM odata;
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 5 months