[jira] [Commented] (TRAFODION-1863) With hbase_filter_preds set to '2', wrong results are returned for a specific use case.

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-1863?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15180648#comment-15180648 ] 

ASF GitHub Bot commented on TRAFODION-1863:
-------------------------------------------

GitHub user eowhadi opened a pull request:

    https://github.com/apache/incubator-trafodion/pull/364

    [TRAFODION-1863] PR340 caused PushdownV2 issues with column having non null default

    since non null default columns are sometime resolved at select time, we need to disable pushdown for these.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/eowhadi/incubator-trafodion jira1863

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-trafodion/pull/364.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 #364
    
----
commit e9b02c2c37890626cccbb2e7fda40af0edc874c6
Author: Eric Owhadi <er...@esgyn.com>
Date:   2016-03-04T14:46:04Z

    Fix jira1863. Pushdown V2 is disabled on columns with non null default as we are resolving default at select time and hbase don t know about the default values.

commit b929e6e20f66a5ce9f27f16ee90f4598519784bf
Author: Eric Owhadi <er...@esgyn.com>
Date:   2016-03-04T14:50:36Z

    Merge branch 'master' of github.com:apache/incubator-trafodion into jira1863

commit 11c58b6d9e4331f01236bd588397189f2b626352
Author: Eric Owhadi <er...@esgyn.com>
Date:   2016-03-04T21:45:18Z

    fix EXPECTED056 to remove the workaround introduced with PR340

----


> With hbase_filter_preds set to '2', wrong results are returned for a specific use case.
> ---------------------------------------------------------------------------------------
>
>                 Key: TRAFODION-1863
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1863
>             Project: Apache Trafodion
>          Issue Type: Bug
>            Reporter: Selvaganesan Govindarajan
>            Assignee: Eric Owhadi
>
> create table t056t57 (a1 numeric(2,2) signed default 0 not null);
> showddl t056t57;
> insert into t056t57 default values;
> select * from t056t57;
> >>select * from t056t57 ;
> A1     
> -------
>     .00
> --- 1 row(s) selected.
> >>cqd hbase_filter_preds '2' ;
> --- SQL operation complete.
> >>select * from t056t57 ;
> ..
> --- 0 row(s) selected.
> >>
> This was causing core/TEST056 to fail with PR #340.. Possibly similar issue is with core/TEST029 too,  Currently this test case runs with hbase_filter_preds set to 'ON'



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)