GitHub user sureshsubbiah opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1051
[TRAAFODION-2568] [TRAFODION-2574]
2568 - Predicates that are always false at compile time will cause their
scan to have begin and end keys reversed. No rows will be scanned. Idea due to
Hans.
Files : ValueDesc.h/.cpp, SearchKey.h/.cpp and GenPreCode.cpp
2574 - Update on table with an index in which SET and WHERE clause contain
an index key column can now get a index driven scan. Thanknk you Qifan and Hans
for your help.
Files : NormRelExpr.cpp, RelExpr.cpp and RelScan.h
Two other minor changes that will help get index plans. I am not able to
get reproducible test cases to open JIRAs on them.
Files : ScmCostMethod.cpp and Analyzer.cpp
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sureshsubbiah/incubator-trafodion 2568
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1051.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1051
----
commit 8f92b92466e2322a234cbc92355019307bb56cbd
Author: Suresh Subbiah <[email protected]>
Date: 2017-04-07T04:15:00Z
[TRAAFODION-2568] [TRAFODION-2574]
2568 - Predicates that are always false at compile time will cause their
scan to have begin and end keys reversed. No rows will be scanned. Idea due to
Hans.
Files : ValueDesc.h/.cpp, SearchKey.h/.cpp and GenPreCode.cpp
2574 - Update on table with an index in which SET and WHERE clause contain
an index key column can now get a index driven scan. Thanknk you Qifan and Hans
for your help.
Files : NormRelExpr.cpp, RelExpr.cpp and RelScan.h
Two other minor changes that will help get index plans. I am not able to
get reproducible test cases to open JIRAs on them.
Files : ScmCostMethod.cpp and Analyzer.cpp
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
