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

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-2730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Suresh Subbiah resolved TRAFODION-2730.
---------------------------------------
    Resolution: Fixed

> 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)