[
https://issues.apache.org/jira/browse/TRAFODION-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16210680#comment-16210680
]
ASF GitHub Bot commented on TRAFODION-2777:
-------------------------------------------
GitHub user sandhyasun opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1271
[TRAFODION-2777] "Table not found" errors not being handled correctly by
AQR for hive access
..and misc LOB related minor fixes
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sandhyasun/incubator-trafodion traf_misc
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1271.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 #1271
----
commit 17ba6b8acb69a3feb3cfd3c67ae6abc37d30b242
Author: Sandhya Sundaresan <[email protected]>
Date: 2017-10-16T17:54:18Z
Fix for AQR for missing hive tables and misc lob related fixes
TRAFODION-2770
commit c47e38b85270043a20c67dbf5f34f007ed6d0f21
Author: Sandhya Sundaresan <[email protected]>
Date: 2017-10-16T17:56:46Z
Merge remote branch 'origin/master' into traf_misc
commit 68e8329428bf5e27c0eb0cdc33bf6a56748a9310
Author: Sandhya Sundaresan <[email protected]>
Date: 2017-10-19T07:11:03Z
Fixes to datamodcheck
----
> Fix latent bug unmasked by JIRA TRAFODION-2765 fix
> --------------------------------------------------
>
> Key: TRAFODION-2777
> URL: https://issues.apache.org/jira/browse/TRAFODION-2777
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.3-incubating
> Environment: All
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
>
> The fix to JIRA TRAFODION-2765 unmasked another bug that causes regression
> test compGeneral/TEST006 to fail sometimes. The nature of the bug is that a
> query plan on a table with no statistics sometimes flips over to an MDAM plan
> where it wasn't before. One example of this that I saw happened in a release
> build while in a debug build the test passed.
> The following script (sometimes!) reproduces the bug:
> ?section setup
> create table t006t9 (a int not null primary key, b int, c int) salt using 2
> partitions ;
> create index t006t9ix1 on t006t9(b) ;
> insert into t006t9 values (1,2,3), (10,20,30);
> prepare expl from
> select operator, cardinality,
> cast(substring(description, position('scan_type: ' in description),
> position('object_type: ' in description) - position('scan_type: ' in
> description)) as char(100)) scan_type
> from table(explain(null, 'S'))
> where operator like '%SCAN%';
> ?section doit
> prepare s from
> select a,b from t006t9 <<+ index TRAFODION.SCH.T006T9IX1>> where b > 10;
> execute expl;
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
