Hello, I would like to open a Jira issue to contribute a very simple fix on how to unparse order_by clause with an empty column list.
The context of the problem is the validation of queries with a limit clause but no order_by (e.g. "SELECT c FROM t LIMIT 2"). The problem does not show up at parsing time but when running a validator. It seems that the generated AST includes an order_by operand with an empty column list. My assumption when fixing the unparsing is that this AST is legit but one might argue otherwise. The fix and associated test case is available here: https://github.com/ebastien/calcite/commit/c47e9da09bd7305d310af5650a378ca1301053a8 I would be happy to create a PR but it seems that I am not allowed to open a Jira issue (username ebastien). What is the procedure to do so? Kind regards, Emmanuel
