[jira] [Commented] (TRAFODION-3026) add create option storage policy

2018-04-27 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3026?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16456678#comment-16456678 ] ASF GitHub Bot commented on TRAFODION-3026: --- Github user selvaganesang commented on a diff

[jira] [Commented] (TRAFODION-3025) order by clause in subquery does not work

2018-04-27 Thread Anoop Sharma (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16456616#comment-16456616 ] Anoop Sharma commented on TRAFODION-3025: - you can try:   select * from (select [first 10] *

[jira] [Commented] (TRAFODION-3025) order by clause in subquery does not work

2018-04-27 Thread liu ming (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16456029#comment-16456029 ] liu ming commented on TRAFODION-3025: - Just realized that ORDER BY in a subquery is useless,