Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
Currently, RelMdUniqueKeys always returns group by keys as the unique key. However, it can return more precise unique keys by looking through group by keys. For instance:
select deptno, deptname, count(*) from dept group by deptno, deptname;
RelMdUniqueKeys can return deptno as the unique key instead of (deptno, deptname) if deptno is unique.
Attachments
Issue Links
- links to