[
https://issues.apache.org/jira/browse/CALCITE-3473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967190#comment-16967190
]
Wang Yanlin commented on CALCITE-3473:
--------------------------------------
# Yes, using powerSet will have performance issue if column number is big. I
add an API to get unique keys for table. Is that OK?
# Yes, the refactor of test case does not woks for RelNode. Actually, I just
want to remove duplicate codes for checking with sql string, because they have
same logic. For other case that checks unique keys using RelNode, like
*testCorrelateUniqueKeys*, there seem to have some special check logic inside,
so I keep it unchanged.
> Getting unique result for table scan should contain key column(s)
> -----------------------------------------------------------------
>
> Key: CALCITE-3473
> URL: https://issues.apache.org/jira/browse/CALCITE-3473
> Project: Calcite
> Issue Type: Improvement
> Reporter: Wang Yanlin
> Assignee: Wang Yanlin
> Priority: Major
> Labels: pull-request-available
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Currently, *mq.getUniqueKeys()* for *TableScan* returns empty.
> However, for table with key column(s) defined, we can refer uniqueness on key
> column(s), so the result should contain key column(s)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)