[
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 `
> ---
[
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
>dramatica
[
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
>dramatica
[
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
>dramatica
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
[
https://issues.apache.org/jira/browse/DERBY-7051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16907714#comment-16907714
]
JackLi0812 commented on DERBY-7051:
---
{code:java}
SELECT DISTINCT
(SELECT COUNT(ORDE
[
https://issues.apache.org/jira/browse/DERBY-7051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16906883#comment-16906883
]
JackLi0812 commented on DERBY-7051:
---
oh, no, i need a query sql.
> Multiple DISTINCT c
[
https://issues.apache.org/jira/browse/DERBY-7051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16906776#comment-16906776
]
JackLi0812 commented on DERBY-7051:
---
Hi, Rick:
Let's say I have a table with a p
[
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 ORDERS
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
10 matches
Mail list logo