XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Query Planning
    • Labels:

      Description

      Queries which has windowing clause with correlated subqueries such as

       select p_mfgr, p_name, p_size 
      from part a 
      where a.p_size in 
        (select first_value(p_size) over(partition by p_mfgr order by p_size) 
         from part b 
         where a.p_brand = b.p_brand)
      ; 


      are currently disabled.

        Attachments

          Activity

            People

            • Assignee:
              vgarg Vineet Garg
              Reporter:
              vgarg Vineet Garg
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: