You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2014/08/25 21:11:00 UTC

[jira] [Closed] (OPTIQ-316) SqlRun: Match output regardless of order if ORDER BY not present

     [ https://issues.apache.org/jira/browse/OPTIQ-316?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Hyde closed OPTIQ-316.
-----------------------------


Close issues resolved in release 0.9.0-incubating (2014-08-25).

> SqlRun: Match output regardless of order if ORDER BY not present
> ----------------------------------------------------------------
>
>                 Key: OPTIQ-316
>                 URL: https://issues.apache.org/jira/browse/OPTIQ-316
>             Project: Optiq
>          Issue Type: Bug
>            Reporter: Julian Hyde
>            Assignee: Julian Hyde
>             Fix For: 0.9.0-incubating
>
>
> If ORDER BY is not present, a compliant implementation may return rows in any order. SqlRun should detect this, output the rows in the original order, not the actual order.
> This feature makes it much easier to handle unsorted data. The previous workaround, adding an ORDER BY clause, may trigger a different execution path and mask bugs. And it was common to forget an ORDER BY and have to go back to add the ORDER BY and correct the data some weeks later.



--
This message was sent by Atlassian JIRA
(v6.2#6252)