6 Replies Latest reply on Aug 31, 2012 10:35 AM by Mark Addleman

    Correct behavior?  ORDER BY in inline view

    Mark Addleman Master

      My query is

      SELECT * FROM (SELECT * FROM demodata."user" WHERE sysid = 'sysid 0' ORDER BY userid DESC) AS CHORUS_B
      

       

      After optimization, it looks like the ORDER BY in the inline view is dropped.  I don't know if this is correct behavior or not but it is undesirable   Plan is attached

       

      This is against the latest Teiid 7.7.x build