[ 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 <eric.owh...@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 <eric.owh...@esgyn.com> Date: 2016-03-04T14:50:36Z Merge branch 'master' of github.com:apache/incubator-trafodion into jira1863 commit 11c58b6d9e4331f01236bd588397189f2b626352 Author: Eric Owhadi <eric.owh...@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)