Pressenna created CALCITE-2978: ---------------------------------- Summary: sorting not applied in subqueries Key: CALCITE-2978 URL: https://issues.apache.org/jira/browse/CALCITE-2978 Project: Calcite Issue Type: Bug Affects Versions: 1.19.0 Reporter: Pressenna
{code:sql} CREATE TABLE test (id INT, val INT); INSERT INTO test VALUES (1,1); INSERT INTO test VALUES (2,2); INSERT INTO test VALUES (3,3); INSERT INTO test VALUES (4,4); SELECT id FROM (SELECT id, val FROM test ORDER BY val DESC); {code} Looks like CALCITE-2798 removes the sorting in sub-queries too aggressively. -- This message was sent by Atlassian JIRA (v7.6.3#76005)