[
https://issues.apache.org/jira/browse/OPTIQ-316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14047208#comment-14047208
]
Julian Hyde commented on OPTIQ-316:
-----------------------------------
What syntax do you suggest?
You can comment lines using # but to comment out sections I recommend '!if
(false) {', because it allows merges on the commented section.
The '!ok' command is peculiar to SqlRun. It is necessary because SqlRun needs
to parse the output, in a limited way, when doing unordered matching.
Also, I'd like to be able to add more see sections - not just output, but
assertions, like 'this stmt gives an error matching xyx', or 'the plan is xyz'.
Each of those would have its own postfix command. '!ok' is the only postfix
command right now. Suggestions for something more intuitive?
> 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
>
> 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)
