You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:17:40 UTC

[jira] [Created] (TRAFODION-642) LP Bug: 1370794 - Query referencing to_char() is not SQC cacheable.

Alice Chen created TRAFODION-642:
------------------------------------

             Summary: LP Bug: 1370794 - Query referencing to_char() is not SQC cacheable.
                 Key: TRAFODION-642
                 URL: https://issues.apache.org/jira/browse/TRAFODION-642
             Project: Apache Trafodion
          Issue Type: Bug
            Reporter: Howard Qin
            Assignee: Howard Qin
            Priority: Critical
             Fix For: 0.9 (pre-incubation)


Queries calling to_char() are not SQC cacheable.
For example:
prepare xx from  to_char(backlog_hdr.hp_receive_date, 'YYYY-MM-DD') from backlog_hdr;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)