ORDER BY caluse of INSERT INTO statement is unexpectantly eliminated

[liuyehcf]

In version 427

The following insert into statement works fine.

INSERT INTO reason (
  r_reason_sk,
  r_reason_id,
  r_reason_desc
) SELECT
  r_reason_sk,
  r_reason_id,
  r_reason_desc
FROM tpcds.sf1.reason
ORDER BY r_reason_sk;

In version 449, the order by is eliminated

INSERT INTO reason (
  r_reason_sk,
  r_reason_id,
  r_reason_desc
) SELECT
  r_reason_sk,
  r_reason_id,
  r_reason_desc
FROM tpcds.sf1.reason
ORDER BY r_reason_sk;

I think this is a bug? the order by is meaningful, cannot be simply eliminated.

[raunaqmorarka]

This is by design
See
#19547
#18159
#818
#759 (comment)

You need to use sorted_by table property in the relevant connector to enforce an ordered physical layout