[
https://issues.apache.org/jira/browse/OPTIQ-316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14047215#comment-14047215
]
Vladimir Sitnikov commented on OPTIQ-316:
-----------------------------------------
Not sure of the language yet.
I guess even TCL would do better if we are to build our own control structures.
I do not like "!" since it is strongly associated with negation: C, C++, Java,
JavaScript, != in SQL, etc.
Something positive would be better: \
{quote}I recommend '!if (false) {',{quote}
I was not able to get it working. I tried to uncommend one-by-one, but the
whole thing started moving for unknown reason. I've spent an hour in debugger
and gave up.
One more reason to give up was lack of good tests since postgresql supports
very few window framing clauses.
{quote}Suggestions for something more intuitive?{quote}
What do you think if I ask IDE support as one of the requirements?
At least some syntax highlighting/bracket-matching.
I hope I am the only one struggling with SqlRun syntax, but as you take some
dose of [MPS|http://www.jetbrains.com/mps/] you'll see that IDE is vital when
creating a new language.
> 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)
