[jira] [Updated] (DERBY-7096) performance in `fetch first n rows only `

[ https://issues.apache.org/jira/browse/DERBY-7096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JackLi0812 updated DERBY-7096: -- Issue & fix info: (was: High Value Fix) > performance in `fetch first n rows only ` >

[jira] [Updated] (DERBY-7096) performance in `fetch first n rows only `

[ https://issues.apache.org/jira/browse/DERBY-7096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JackLi0812 updated DERBY-7096: -- Description: > When I use 'fetch first n rows only' in A cascading query, performance drops

[jira] [Updated] (DERBY-7096) performance in `fetch first n rows only `

[ https://issues.apache.org/jira/browse/DERBY-7096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JackLi0812 updated DERBY-7096: -- Description: > When I use 'fetch first n rows only' in A cascading query, performance drops

[jira] [Updated] (DERBY-7096) performance in `fetch first n rows only `

[ https://issues.apache.org/jira/browse/DERBY-7096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JackLi0812 updated DERBY-7096: -- Description: > When I use 'fetch first n rows only' in A cascading query, performance drops

[jira] [Created] (DERBY-7096) performance in `fetch first n rows only `

JackLi0812 created DERBY-7096: - Summary: performance in `fetch first n rows only ` Key: DERBY-7096 URL: https://issues.apache.org/jira/browse/DERBY-7096 Project: Derby Issue Type: Improvement

[jira] [Commented] (DERBY-7051) Multiple DISTINCT columns are not supported

[ https://issues.apache.org/jira/browse/DERBY-7051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16907714#comment-16907714 ] JackLi0812 commented on DERBY-7051: --- {code:java} SELECT DISTINCT (SELECT COUNT(ORDERS.CUSTOMER_ID)

[jira] [Commented] (DERBY-7051) Multiple DISTINCT columns are not supported

[ https://issues.apache.org/jira/browse/DERBY-7051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16906883#comment-16906883 ] JackLi0812 commented on DERBY-7051: --- oh, no, i need a query sql. > Multiple DISTINCT columns are not

[jira] [Commented] (DERBY-7051) Multiple DISTINCT columns are not supported

[ https://issues.apache.org/jira/browse/DERBY-7051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16906776#comment-16906776 ] JackLi0812 commented on DERBY-7051: --- Hi, Rick:       Let's say I have a table with a purchase history

[jira] [Updated] (DERBY-7051) Multiple DISTINCT columns are not supported

[ https://issues.apache.org/jira/browse/DERBY-7051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JackLi0812 updated DERBY-7051: -- Description:   {code:java} SELECT DISTINCT (ORDERS.CUSTOMER_ID), DISTINCT (ORDERS.ORDER_ID) FROM

[jira] [Created] (DERBY-7051) Multiple DISTINCT columns are not supported

JackLi0812 created DERBY-7051: - Summary: Multiple DISTINCT columns are not supported Key: DERBY-7051 URL: https://issues.apache.org/jira/browse/DERBY-7051 Project: Derby Issue Type: Bug