MonkeyCanCode commented on issue #16519:
URL: https://github.com/apache/iceberg/issues/16519#issuecomment-4513536870
Yes, hit the same issue today and here is a reproducible:
```sh
CREATE TABLE polaris.db.sort_orphan_repro (
id bigint,
time timestamp,
source string,
payload string
)
USING iceberg
PARTITIONED BY (days(time))
TBLPROPERTIES ('format-version' = '2');
ALTER TABLE polaris.db.sort_orphan_repro WRITE ORDERED BY time DESC NULLS
LAST, source ASC NULLS LAST;
INSERT INTO polaris.db.sort_orphan_repro VALUES (1, timestamp '2026-05-20
00:00:00', 'a', 'p1');
ALTER TABLE polaris.db.sort_orphan_repro DROP PARTITION FIELD days(time);
ALTER TABLE polaris.db.sort_orphan_repro WRITE UNORDERED;
ALTER TABLE polaris.db.sort_orphan_repro DROP COLUMN time;
ALTER TABLE polaris.db.sort_orphan_repro ADD COLUMN time timestamp;
ALTER TABLE polaris.db.sort_orphan_repro ADD PARTITION FIELD days(time);
ALTER TABLE polaris.db.sort_orphan_repro WRITE ORDERED BY time DESC NULLS
LAST, source ASC NULLS LAST;
# this will fail
INSERT INTO polaris.db.sort_orphan_repro (id, time, source, payload) VALUES
(2, timestamp '2026-05-21 00:00:00', 'b', 'p2');
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
