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

["Anoop Sharma (JIRA)" <ji...@apache.org>]

Anoop Sharma created TRAFODION-2730:
---------------------------------------

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