[jira] [Commented] (CALCITE-5866) Not all dialects support sorting in sub-queries

2023-08-14 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5866?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17754347#comment-17754347 ] Julian Hyde commented on CALCITE-5866: -- Orthogonal to SQL semantics is {{RelNode}}

[jira] [Commented] (CALCITE-5866) Not all dialects support sorting in sub-queries

2023-07-28 Thread Will Noble (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5866?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17748764#comment-17748764 ] Will Noble commented on CALCITE-5866: - The main thing for us to decide is what the

[jira] [Commented] (CALCITE-5866) Not all dialects support sorting in sub-queries

2023-07-24 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5866?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17746743#comment-17746743 ] Julian Hyde commented on CALCITE-5866: -- Standard SQL doesn't allow {{ORDER BY}} in

[jira] [Commented] (CALCITE-5866) Not all dialects support sorting in sub-queries

2023-07-20 Thread Will Noble (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5866?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17745321#comment-17745321 ] Will Noble commented on CALCITE-5866: - Actually, I think we could come up with a ge

[jira] [Commented] (CALCITE-5866) Not all dialects support sorting in sub-queries

2023-07-20 Thread Will Noble (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5866?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17745319#comment-17745319 ] Will Noble commented on CALCITE-5866: - This is actually a weirder problem than it s

[jira] [Commented] (CALCITE-5866) Not all dialects support sorting in sub-queries

2023-07-20 Thread Runkang He (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5866?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17745314#comment-17745314 ] Runkang He commented on CALCITE-5866: - If MSSQL (SQL Server) ignore the `ORDER BY`