Denny [DBA at Innervate]
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.