Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Currently optiq does not push projects through WindowRel, thus it feeds excessive data to WindowRel.

      select *
        from (
          select "empid", "deptno", count(*) over (partition by "deptno") c
            from "hr"."emps"
       )
       where "deptno"=10 and "empid"=100

      Optiq should recognize it is required to track just fields empid and deptno.

      However the java code is as follows (note that empid, name, salary, and commission are projected):

      /*  47 */       _list.add(new Object[] {
      /*  48 */         row.empid,
      /*  49 */         row.deptno,
      /*  50 */         row.name,
      /*  51 */         row.salary,
      /*  52 */         row.commission,
      /*  53 */         COUNTa0w0});
      

        Attachments

          Activity

            People

            • Assignee:
              julianhyde Julian Hyde
              Reporter:
              vladimirsitnikov Vladimir Sitnikov
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: