[jira] [Commented] (TRAFODION-3150) to_char and extract function's new options bug

2018-07-19 Thread chenyunren (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3150?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16550147#comment-16550147 ] chenyunren commented on TRAFODION-3150: --- Thanks Hans. Your comment is very useful! Yes, I

[jira] [Updated] (TRAFODION-3150) to_char and extract function's new options bug

2018-07-18 Thread chenyunren (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenyunren updated TRAFODION-3150: -- Description: 1.select extract(quarter from interval '99' month) from dual; return:33

[jira] [Created] (TRAFODION-3150) to_char and extract function's new options bug

2018-07-17 Thread chenyunren (JIRA)
chenyunren created TRAFODION-3150: - Summary: to_char and extract function's new options bug Key: TRAFODION-3150 URL: https://issues.apache.org/jira/browse/TRAFODION-3150 Project: Apache Trafodion

[jira] [Updated] (TRAFODION-3127) to_char enhancement

2018-07-05 Thread chenyunren (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3127?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenyunren updated TRAFODION-3127: -- Attachment: (was: image-2018-07-06-10-32-47-711.png) > to_char enhancement >

[jira] [Updated] (TRAFODION-3127) to_char enhancement

2018-07-05 Thread chenyunren (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3127?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenyunren updated TRAFODION-3127: -- Attachment: image-2018-07-06-10-32-47-711.png > to_char enhancement > ---

[jira] [Updated] (TRAFODION-3127) to_char enhancement

2018-07-05 Thread chenyunren (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3127?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenyunren updated TRAFODION-3127: -- Description: |Pattern|Description|EXP.| |HH|  hour of day (00-23)|TO_CHAR (TIME

[jira] [Updated] (TRAFODION-3127) to_char enhancement

2018-07-05 Thread chenyunren (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3127?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenyunren updated TRAFODION-3127: -- Description: |MON|month(3 chars in English)|TO_CHAR (TIMESTAMP '2016-03-01

[jira] [Issue Comment Deleted] (TRAFODION-3127) to_char enhancement

2018-07-05 Thread chenyunren (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3127?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenyunren updated TRAFODION-3127: -- Comment: was deleted (was: |MON|month(3 chars in English)|TO_CHAR (TIMESTAMP '2016-03-01

[jira] [Commented] (TRAFODION-3127) to_char enhancement

2018-07-05 Thread chenyunren (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16534380#comment-16534380 ] chenyunren commented on TRAFODION-3127: --- |MON|month(3 chars in English)|TO_CHAR (TIMESTAMP

[jira] [Resolved] (TRAFODION-3118) Improve on parts of EXTRACT constructs.

2018-07-05 Thread chenyunren (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenyunren resolved TRAFODION-3118. --- Resolution: Fixed > Improve on parts of EXTRACT constructs. >

[jira] [Created] (TRAFODION-3127) to_char enhancement

2018-07-01 Thread chenyunren (JIRA)
chenyunren created TRAFODION-3127: - Summary: to_char enhancement Key: TRAFODION-3127 URL: https://issues.apache.org/jira/browse/TRAFODION-3127 Project: Apache Trafodion Issue Type:

[jira] [Created] (TRAFODION-3118) Improve on parts of EXTRACT constructs.

2018-06-25 Thread chenyunren (JIRA)
chenyunren created TRAFODION-3118: - Summary: Improve on parts of EXTRACT constructs. Key: TRAFODION-3118 URL: https://issues.apache.org/jira/browse/TRAFODION-3118 Project: Apache Trafodion

[jira] [Updated] (TRAFODION-2988) Prepare query returns 2006 internal error

2018-03-12 Thread chenyunren (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2988?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenyunren updated TRAFODION-2988: -- Description: Prepare query returns a 2006 internal error at mdam.cpp:1611 when the CQD

[jira] [Updated] (TRAFODION-2988) Prepare query returns 2006 internal error

2018-03-12 Thread chenyunren (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2988?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenyunren updated TRAFODION-2988: -- Description: This query preparation comes from an existing regression test and it used to

[jira] [Resolved] (TRAFODION-2978) update statistics would hang for 100 billion rows table

2018-03-12 Thread chenyunren (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenyunren resolved TRAFODION-2978. --- Resolution: Fixed > update statistics would hang for 100 billion rows table >

[jira] [Updated] (TRAFODION-2988) Prepare query returns 2006 internal error

2018-03-11 Thread chenyunren (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2988?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenyunren updated TRAFODION-2988: -- Description: This query preparation comes from an existing regression test and it used to

[jira] [Assigned] (TRAFODION-2988) Prepare query returns 2006 internal error

2018-03-11 Thread chenyunren (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2988?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenyunren reassigned TRAFODION-2988: - Assignee: chenyunren Description: This query preparation comes from an

[jira] [Created] (TRAFODION-2988) Prepare query returns 2006 internal error

2018-03-11 Thread chenyunren (JIRA)
chenyunren created TRAFODION-2988: - Summary: Prepare query returns 2006 internal error Key: TRAFODION-2988 URL: https://issues.apache.org/jira/browse/TRAFODION-2988 Project: Apache Trafodion

[jira] [Updated] (TRAFODION-2978) update statistics would hang for 100 billion rows table

2018-03-05 Thread chenyunren (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenyunren updated TRAFODION-2978: -- Description: CREATE TABLE T1   ( C1 INT DEFAULT NULL NOT SERIALIZED   , C2 INT

[jira] [Updated] (TRAFODION-2978) update statistics would hang for 100 billion rows table

2018-03-05 Thread chenyunren (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenyunren updated TRAFODION-2978: -- Description: CREATE TABLE T1   ( C1 INT DEFAULT NULL NOT SERIALIZED   , C2 INT

[jira] [Updated] (TRAFODION-2978) update statistics would hang for 100 billion rows table

2018-03-05 Thread chenyunren (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenyunren updated TRAFODION-2978: -- Description: CREATE TABLE T1   ( C1 INT DEFAULT NULL NOT SERIALIZED   , C2 INT

[jira] [Created] (TRAFODION-2978) update statistics would hang for 100 billion rows table

2018-03-05 Thread chenyunren (JIRA)
chenyunren created TRAFODION-2978: - Summary: update statistics would hang for 100 billion rows table Key: TRAFODION-2978 URL: https://issues.apache.org/jira/browse/TRAFODION-2978 Project: Apache