Denny [DBA at Innervate]

Results 102 comments of Denny [DBA at Innervate]

Also check that result is the same for ```sql SELECT '2020-01-01 00:00:00.000' AS a, '2020-01-01 00:00:00.000001' AS b, b > a AS str, toDateTime64(b, 6) > toDateTime64(a, 3) AS datetime64,...

>is this really supposed to work? No, it does not.

I wonder why this does not throw an error (it cannot / should not use index, but it does not erroring) ```sql drop table dt64_monot_test_string; create table dt64_monot_test_string(date_time String, x...

`toDateTime64()` should not be monotonic and this query does a table fullscan, thus `force_index_by_date=1, force_primary_key=1;` should throw an error.

@orloffv it's not the same, they are not related. This PR makes `toDateTime64()` monotonic. https://github.com/ClickHouse/ClickHouse/issues/28087 needs `toDate()` to be monotonic.

>What concerns you do have now about this PR? I don't have concerns. My PR is not important, don't worry.

check with curl from CH server `curl http://10.0.1.110:9440`

>[root@localhost ~]# curl http://10.0.1.110:9440 >curl: (28) Failed to connect to 10.0.1.110 port 9440: connection timed out >[root@localhost compose]# curl http://10.0.1.110:9440 curl: (52) Empty reply from server firewall/network issue, curl should...

> In flyway replicated table creation zookeeper path should be should be??? 99% of CH users don't have macros {cluster} 100% of CH users don't have macros {installation} It simply...

BTW it's a Russian Cyrillic С not Latin С in the PR name " С lickhouse support" That's confusing , I copy/pasted Сlickhouse word and was unable to find it.