Ran Tao created CALCITE-6063:
--------------------------------
Summary: ARRAY sub-query with OrderBy return unexpected results
Key: CALCITE-6063
URL: https://issues.apache.org/jira/browse/CALCITE-6063
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.35.0
Reporter: Ran Tao
calcite support array query constructor.
but If we run sub-query with orderby:
{code:java}
select array(select x from unnest(array[1,2,3]) as t(x) order by x desc);
select array(select x from unnest(array[1,2,3]) as t(x) order by x asc); {code}
they both return
{code:java}
+-----------+
| EXPR$0 |
+-----------+
| [1, 2, 3] |
+-----------+
{code}
It seems that the *order by* not works properly in array sub-query.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
