02746_index_analysis_binary_operator_with_null.sql

drop table if exists tab;

create table tab (x DateTime) engine MergeTree order by x;

SELECT toDateTime(65537, toDateTime(NULL), NULL)
FROM tab
WHERE ((x + CAST('1', 'Nullable(UInt8)')) <= 2) AND ((x + CAST('', 'Nullable(UInt8)')) <= 256)
ORDER BY
    toDateTime(toDateTime(-2, NULL, NULL) + 100.0001, NULL, -2, NULL) DESC NULLS LAST,
    x ASC NULLS LAST;

drop table tab;