TablePlus-Windows
TablePlus-Windows copied to clipboard
Bug Report: ClickHouse incorrectly display Date32 (and possibly Date64)
ClickHouse Server Version:
- 24.12.2.29
- Tested also with 24.8.4.13
TablePlus Version:
- 6.1.1 (Build 278) x64
Issue Description
When querying Date32 values, the results are displayed incorrectly. For example, the following SQL query:
SELECT toDate32('1956-02-12');
Expected Result:
1956-02-12
Actual Result:
2106-02-07
This issue does not occur when using the ClickHouse HTTP Play client, which returns the correct value (1956-02-12). Additionally, the macOS version of TablePlus also displays the value correctly.