Dario Heinisch

Currently getting ` ** (Ch.Error) Code: 477. DB::Exception: FORMAT must be specified for function input(). (INVALID_USAGE_OF_INPUT) (version 23.2.4.12 (official build))` let me see if I can debug this one :D...

Works now I had `TestRepo.insert_all("users", input, input: rows)` instead of `TestRepo.insert_all("users", rows, input: input)` lol Super awesome! @ruslandoga

I mean, I did a silly mistake so that is that :D `insert_input` doesn't sound too bad IMO then could add dedicated docs for that function which may make it...

But in my test I am not using a native timestamp I am using a timestamp with an UTC offset. So if I insert that timestamp and reuse to filter...

I updated my local chto to latest ch (commit `d305fa092515a106a20f517e642228f75bbe2001`) and now the test code above fails. ```elixir from( u in Product, where: u.approved_at == ^time ) |> TestRepo.exists?() |>...

Hmmm, if you run `select timezone();` what do you get? I get `Europe/Berlin`

What if you change ur database to `Europe/Berlin` or anything that is not on UTC timezone. I think then the test will fail

at least that is the only difference I can now spot between your env and my as why the test fails

> Simply encoding UTC datetimes to unix timestamps in query strings is not enough. That is kinda weird because technically according to their documentation that should do it (Dealing with...

Should the CI maybe also run with a different clickhouse timezone setting so that in the future we can catch future timezone issues?