[JBoss JIRA] (TEIID-2939) Issues with applying row based security
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2939?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-2939:
----------------------------------
Description:
If a view over a left outer join has a row condition and is used in a simple aggregation:
select count\(*) from vw
Then a null pointer exception will occur when considering optional joins.
If intervening criteria is added:
select count\(*) from vw where ...
we can get past the initial error, but will fail in initializing the join node with an assertion error. Both of these have the same root issue, which is our attempt to make the logic selective about when assign output elements is run, which leads to the output elements not being in place when later needed.
was:
If a view over a left outer join has a row condition and is used in a simple aggregation:
select count(*) from vw
Then a null pointer exception will occur when considering optional joins.
If intervening criteria is added:
select count(*) from vw where ...
we can get past the initial error, but will fail in initializing the join node with an assertion error. Both of these have the same root issue, which is our attempt to make the logic selective about when assign output elements is run, which leads to the output elements not being in place when later needed.
> Issues with applying row based security
> ---------------------------------------
>
> Key: TEIID-2939
> URL: https://issues.jboss.org/browse/TEIID-2939
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.4
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.7.1, 8.8
>
>
> If a view over a left outer join has a row condition and is used in a simple aggregation:
> select count\(*) from vw
> Then a null pointer exception will occur when considering optional joins.
> If intervening criteria is added:
> select count\(*) from vw where ...
> we can get past the initial error, but will fail in initializing the join node with an assertion error. Both of these have the same root issue, which is our attempt to make the logic selective about when assign output elements is run, which leads to the output elements not being in place when later needed.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years
[JBoss JIRA] (TEIID-2939) Issues with applying row based security
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-2939:
-------------------------------------
Summary: Issues with applying row based security
Key: TEIID-2939
URL: https://issues.jboss.org/browse/TEIID-2939
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.7.1, 8.8
If a view over a left outer join has a row condition and is used in a simple aggregation:
select count(*) from vw
Then a null pointer exception will occur when considering optional joins.
If intervening criteria is added:
select count(*) from vw where ...
we can get past the initial error, but will fail in initializing the join node with an assertion error. Both of these have the same root issue, which is our attempt to make the logic selective about when assign output elements is run, which leads to the output elements not being in place when later needed.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years
[JBoss JIRA] (TEIID-2936) Combining multiple 'in' criteria can prevent pushing criteria to database
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2936?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2936.
-----------------------------------
Fix Version/s: 8.8
Resolution: Done
Allowing the optimizer to push and then split large in's (into multiple predicates, not queries) by also considering the max dependent sets. However in some circumstances this may lead to source queries with too many bind values. We'll address that scenario later if needed with more bookkeeping.
> Combining multiple 'in' criteria can prevent pushing criteria to database
> -------------------------------------------------------------------------
>
> Key: TEIID-2936
> URL: https://issues.jboss.org/browse/TEIID-2936
> Project: Teiid
> Issue Type: Feature Request
> Affects Versions: 8.7
> Reporter: Mike Higgins
> Assignee: Steven Hawkins
> Fix For: 8.8
>
>
> When two 'in' criteria containing constant values on the same field are combined with an 'or', Teiid will combine the two into a single 'in' operation.
> Since Oracle (for example) has a 1000 item limit on the 'in' values, if the resulting combined list contains more than 1000 values, it can no longer be pushed down into Oracle for execution.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years