[ https://issues.apache.org/jira/browse/TRAFODION-2730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16175571#comment-16175571 ]
ASF GitHub Bot commented on TRAFODION-2730: ------------------------------------------- Github user asfgit closed the pull request at: https://github.com/apache/incubator-trafodion/pull/1238 > 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)