aadant

@E1izabeth maybe you should disable the data formatting by default ?

@E1izabeth please reopen. This is a serious issue

You may be in a US TZ to reproduce (maybe CDT) and the server should also be in America/Chicago for example

@llchan the workaround is to disable the Date formatting in the "Properties"

so @E1izabeth there is an issue with CH and Date formatting which is enabled by default. It should be fixed because Date / DateTime32 are showing this bug by default.

yes I noticed that if you DETACH / ATTACH a partition on a live server you may lose data.

> @aadant, how exactly? We see it in 23.8 in one of our tables. I will submit a test case if I can reproduce it. first the number of inactive...

> I don't think it's a reasonable way to delete inactive parts - looks like a hack rather than a solution. About inactive parts - you shouldn't worry about their...

I would recommend that you use the sink-connector lightweight. See for example https://github.com/Altinity/clickhouse-sink-connector/discussions/810. It works very well with MySQL including DDL

probably a duplicate of this one https://github.com/Altinity/clickhouse-sink-connector/issues/932