[
https://issues.apache.org/jira/browse/TRAFODION-2730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16149313#comment-16149313
]
ASF GitHub Bot commented on TRAFODION-2730:
-------------------------------------------
Github user anoopsharma00 commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/1222#discussion_r136400798
--- Diff: core/sql/regress/charsets/TEST014 ---
@@ -28,6 +28,11 @@
--
-- @@@ END COPYRIGHT @@@
+-- an existing bug causes process loop when infer_charset is ON
--- End diff --
jira TRAFODION-2730 tracks this issue.
> 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)
