[jira] [Commented] (TRAFODION-2730) process loop when infer_charset cqd is ON and query invalidation is done

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

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

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

GitHub user sureshsubbiah opened a pull request:

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

    [TRAFODION-2730] process loop when infer_charset cqd is ON and query …

    …invalidation is done
    
    This PR also includes fixes for [TRAFODION-2747] and [TRAFODION-2748].
    The changes are small and the problems not severe.
    Please see JIRA for an explanation
    
    Add aditional change has been made to explain output.
    cache_blocks ON is now added to explain for HBase scans. Previously
    explain would only show cache_blocks OFF, if blockcache was disabled for a
    HBase scan.
    
    Files
    2730 - QCache.cpp
    2747 - ExSequence.cpp, ExAtp.h
    2748 - GenPreCode.cpp
    cache_block - GenExplain.cpp, 4 regression EXPECTED files

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

    $ git pull https://github.com/sureshsubbiah/incubator-trafodion misc1

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

    https://github.com/apache/incubator-trafodion/pull/1238.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 #1238
    
----
commit e68aa43ae2f99e571095763b6e7acd51114295da
Author: Suresh Subbiah <su...@apache.org>
Date:   2017-09-18T16:27:49Z

    [TRAFODION-2730] process loop when infer_charset cqd is ON and query invalidation is done
    
    This PR also includes fixes for [TRAFODION-2747] and [TRAFODION-2748].
    The changes are small and the problems not severe.
    Please see JIRA for an explanation
    
    Add aditional change has been made to explain output.
    cache_blocks ON is now added to explain for HBase scans. Previously
    explain would only show cache_blocks OFF, if blockcache was disabled for a
    HBase scan.
    
    Files
    2730 - QCache.cpp
    2747 - ExSequence.cpp, ExAtp.h
    2748 - GenPreCode.cpp
    cache_block - GenExplain.cpp, 4 regression EXPECTED files

----


> process loop when infer_charset cqd is ON and query invalidation is done
> ------------------------------------------------------------------------
>
>                 Key: TRAFODION-2730
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2730
>             Project: Apache Trafodion
>          Issue Type: Bug
>            Reporter: Anoop Sharma
>            Assignee: Suresh Subbiah
>            Priority: Minor
>
> run the following script from sqlci to reproduce this issue on trafodion master branch:
>   create table if not exists tloop(a int);
>   control query default INFER_CHARSET 'on';
>   select 'a' from tloop;
>   drop table tloop;
>   select 'a' from tloop; -- this select will loop
> Last 'select' will loop in method QCache∷free_entries_with_QI_keys.
> It is caused by method Qcache∷deCache not removing the specified entry. 
>  
> This issue happens if infer_charset cqd is on. 
> It could be that the cache key being computed is different with and without this cqd.
>  
>  



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)