[jira] [Commented] (TRAFODION-3107) selct count(0) with long varchar hitting jvm OOM error

2018-06-19 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3107?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16517403#comment-16517403 ] ASF GitHub Bot commented on TRAFODION-3107: --- Github user asfgit closed the pull request at:

[jira] [Commented] (TRAFODION-3107) selct count(0) with long varchar hitting jvm OOM error

2018-06-15 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3107?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16514335#comment-16514335 ] ASF GitHub Bot commented on TRAFODION-3107: --- GitHub user sandhyasun opened a pull request:

[jira] [Commented] (TRAFODION-3107) selct count(0) with long varchar hitting jvm OOM error

2018-06-15 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3107?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16514313#comment-16514313 ] Sandhya Sundaresan commented on TRAFODION-3107: --- Fixing this by limiting the number of

[jira] [Commented] (TRAFODION-3107) selct count(0) with long varchar hitting jvm OOM error

2018-06-13 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3107?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16511470#comment-16511470 ] Sandhya Sundaresan commented on TRAFODION-3107: --- Explain plan shows the 16MB columns

[jira] [Commented] (TRAFODION-3107) selct count(0) with long varchar hitting jvm OOM error

2018-06-13 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3107?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16511465#comment-16511465 ] Sandhya Sundaresan commented on TRAFODION-3107: --- |n sqlci: select * from

[jira] [Commented] (TRAFODION-3107) selct count(0) with long varchar hitting jvm OOM error

2018-06-13 Thread Sandhya Sundaresan (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3107?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16511464#comment-16511464 ] Sandhya Sundaresan commented on TRAFODION-3107: --- 1.cqd traf_clob_as_varchar 'on'