Extended ClickHouse Date range

[tangjiangling]

I've confirmed that from version 21.4, Date types are supported in the range 1970-01-01-2149-06-06.

We can refer to

• Support Dates and DateTimes outside of 1970-2105 range. ClickHouse/ClickHouse#7316 (comment)
• https://clickhouse.com/docs/en/sql-reference/data-types/date/

But the range of Date in Trino is 1970-01-01-2106-02-07.

https://github.com/trinodb/trino/blob/master/plugin/trino-clickhouse/src/main/java/io/trino/plugin/clickhouse/ClickHouseClient.java#L158-L159

So I think the range of Date types should also be extended in Trino, and the change we may need to make is to pick the corresponding Date range according to the different ClickHouse Server versions.

[tangjiangling]

Planning to send a PR :)

[hashhar]

@tangjiangling Should I re-open this since only part of this is done. The other part probably requires reworking Trino DATE type to support even larger values?

Or would you want to create a separate issue?

[tangjiangling]

@hashhar Thanks for the reminder, I will file a new issue.

[tangjiangling]

Thanks for the reminder, I will file a new issue.

Reopening is enough.

see #11148 (comment)