SYSDATE() row-by-row operation returns ERROR 1292: Incorrect datetime value

Customer reported that SYSDATE() row-by-row operation returns

 ERROR 1292: Incorrect datetime value in Columnstore 25.10.4. 

Same query (that evaluating window functions over cross-engine joins and ColumnStore materializes an internal streaming temporary table) works fine in CS 23.10.4.
Please see repro files.

If I used
a/

 SET SESSION columnstore_select_handler=OFF; 

b/
or cast(), e.g.

INSERT INTO TempSpotNbrAnalysis

SELECT TempSpotSectors.RequestID,

      6,

      CAST(SYSDATE() AS DATETIME) 

then query works. May above can serve as temp workaround, but (a) likely reduce performance, while (b) requires to change previously working SQL.