7:33 a.m.
Steven Hawkins created TEIID-2245:
-------------------------------------
Summary: Limit pushdown of nulls first/last
Key: TEIID-2245
URL: https://issues.jboss.org/browse/TEIID-2245
Project: Teiid
Issue Type: Enhancement
Components: Connector API
Affects Versions: 7.4.4
Reporter: Steven Hawkins
Assignee: Johnathon Lee
Priority: Critical
Fix For: 7.4.5
Add the ability to configure how nulls first/last will be handled.
--
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
7:35 a.m.
[
https://issues.jboss.org/browse/TEIID-2245?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-2245:
----------------------------------
Description: By default Teiid will attempt to virtualize the default null
order of nulls low. This can have a negative impact on performance and is not needed in
many situations. (was: Add the ability to configure how nulls first/last will be
handled.)
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=863208 (was:
https://bugzilla.redhat.com/show_bug.cgi?id=863208)
Component/s: Query Engine
(was: Connector API)
Limit pushdown of nulls first/last
----------------------------------
Key: TEIID-2245
URL: https://issues.jboss.org/browse/TEIID-2245
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Affects Versions: 7.4.4
Reporter: Steven Hawkins
Assignee: Johnathon Lee
Priority: Critical
Fix For: 7.4.5
By default Teiid will attempt to virtualize the default null order of nulls low. This
can have a negative impact on performance and is not needed in many situations.
--
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
8:36 a.m.
[
https://issues.jboss.org/browse/TEIID-2245?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-2245.
-----------------------------------
Assignee: Steven Hawkins (was: Johnathon Lee)
Fix Version/s: 8.2
(was: 7.4.5)
Resolution: Done
Changed the default logic to not pushdown the default null order by default. Rather there
is a system property org.teiid.pushdownDefaultNullOrder that can be set to preserve the
old behavior.
Also walked back the logic in ruleimplementjoinstrategy there is no issue with standard
joins wrt consistent null ordering (that is even if we expect low and one or both sides is
sorted high, then the results will still be correct). The only times there would be an
issue is if nulls were sorted inconsistently e.g. (a, null, a) - which no source should do
or with except/intersect processing since nulls have equality there. However we don't
push down except/intersect sorts yet so we'll address that later.
To port this issue back, the affect of the patches can be further limited by just inlining
the properties logic (rather than backporting the options logic) and by possibly leaving
the nullorder manipulation in place in the ruleimplementjoinstrategy logic rather than
moving it to rulecollapsesource.
Limit pushdown of nulls first/last
----------------------------------
Key: TEIID-2245
URL: https://issues.jboss.org/browse/TEIID-2245
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Affects Versions: 7.4.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Critical
Fix For: 8.2
By default Teiid will attempt to virtualize the default null order of nulls low. This
can have a negative impact on performance and is not needed in many situations.
--
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
8:42 a.m.
[
https://issues.jboss.org/browse/TEIID-2245?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-2245:
---------------------------------------
Note that the second commit also further narrowed the pushdown affect to only user order
bys. Also for legacy branches it would be proper to default the pushdown property to true
rather than false.
Limit pushdown of nulls first/last
----------------------------------
Key: TEIID-2245
URL: https://issues.jboss.org/browse/TEIID-2245
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Affects Versions: 7.4.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Critical
Fix For: 8.2
By default Teiid will attempt to virtualize the default null order of nulls low. This
can have a negative impact on performance and is not needed in many situations.
--
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
11:42 a.m.
[
https://issues.jboss.org/browse/TEIID-2245?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-2245:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=857488 (was:
https://bugzilla.redhat.com/show_bug.cgi?id=863208)
Limit pushdown of nulls first/last
----------------------------------
Key: TEIID-2245
URL: https://issues.jboss.org/browse/TEIID-2245
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Affects Versions: 7.4.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Critical
Fix For: 8.2
By default Teiid will attempt to virtualize the default null order of nulls low. This
can have a negative impact on performance and is not needed in many situations.
--
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
11:42 a.m.
[
https://issues.jboss.org/browse/TEIID-2245?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-2245:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=863208 (was:
https://bugzilla.redhat.com/show_bug.cgi?id=863208)
Limit pushdown of nulls first/last
----------------------------------
Key: TEIID-2245
URL: https://issues.jboss.org/browse/TEIID-2245
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Affects Versions: 7.4.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Critical
Fix For: 8.2
By default Teiid will attempt to virtualize the default null order of nulls low. This
can have a negative impact on performance and is not needed in many situations.
--
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
11:44 a.m.
[
https://issues.jboss.org/browse/TEIID-2245?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-2245:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=857488 (was:
https://bugzilla.redhat.com/show_bug.cgi?id=857488)
Limit pushdown of nulls first/last
----------------------------------
Key: TEIID-2245
URL: https://issues.jboss.org/browse/TEIID-2245
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Affects Versions: 7.4.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Critical
Fix For: 8.2
By default Teiid will attempt to virtualize the default null order of nulls low. This
can have a negative impact on performance and is not needed in many situations.
--
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
11:44 a.m.
[
https://issues.jboss.org/browse/TEIID-2245?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-2245:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=857488,
https://bugzilla.redhat.com/show_bug.cgi?id=863208 (was:
https://bugzilla.redhat.com/show_bug.cgi?id=857488)
Limit pushdown of nulls first/last
----------------------------------
Key: TEIID-2245
URL: https://issues.jboss.org/browse/TEIID-2245
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Affects Versions: 7.4.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Critical
Fix For: 8.2
By default Teiid will attempt to virtualize the default null order of nulls low. This
can have a negative impact on performance and is not needed in many situations.
--
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
4:35 p.m.
[
https://issues.jboss.org/browse/TEIID-2245?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-2245:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=863208 (was:
https://bugzilla.redhat.com/show_bug.cgi?id=857488,
https://bugzilla.redhat.com/show_bug.cgi?id=863208)
Limit pushdown of nulls first/last
----------------------------------
Key: TEIID-2245
URL: https://issues.jboss.org/browse/TEIID-2245
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Affects Versions: 7.4.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Critical
Fix For: 8.2
By default Teiid will attempt to virtualize the default null order of nulls low. This
can have a negative impact on performance and is not needed in many situations.
--
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
8:23 a.m.
[
https://issues.jboss.org/browse/TEIID-2245?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-2245:
----------------------------------
Fix Version/s: 7.7.3
Limit pushdown of nulls first/last
----------------------------------
Key: TEIID-2245
URL: https://issues.jboss.org/browse/TEIID-2245
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Affects Versions: 7.4.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Critical
Fix For: 7.7.3, 8.2
By default Teiid will attempt to virtualize the default null order of nulls low. This
can have a negative impact on performance and is not needed in many situations.
--
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
8:23 a.m.
[
https://issues.jboss.org/browse/TEIID-2245?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-2245.
---------------------------------
Limit pushdown of nulls first/last
----------------------------------
Key: TEIID-2245
URL: https://issues.jboss.org/browse/TEIID-2245
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Affects Versions: 7.4.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Critical
Fix For: 7.7.3, 8.2
By default Teiid will attempt to virtualize the default null order of nulls low. This
can have a negative impact on performance and is not needed in many situations.
--
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
4416
days inactive
4462
days old
10 comments
2 participants
participants (2)
-
RH Bugzilla Integration (JIRA) -
Steven Hawkins (JIRA)