JasonLi

My reproduce ```sql ❯ select now()::date + interval '1 hour'; +----------------------------------------------------+ | CAST(now() AS Date32) + IntervalDayTime("3600000") | +----------------------------------------------------+ | 2022-08-12 | +----------------------------------------------------+ ```

I am now trying to implement IS_NULL and IS_NOT_null and I want to know how to generate the file: https://github.com/datafuselabs/databend/blob/42de73d733c05573815c8c8ada7c3c6fa9d43226/src/query/functions-v2/tests/it/scalars/testdata/control.txt @sundy-li @andylokandy

> See the comments in: https://github.com/datafuselabs/databend/blob/fc868936df12e06f5c907c335ac813e950c3eb8b/src/query/functions-v2/tests/it/main.rs thanks!

Related work: https://github.com/apache/datafusion/issues/2477 https://github.com/apache/datafusion/pull/2486

> Thanks @JasonLi-cn for this 👍 > > I noticed this from PG's [document](https://www.postgresql.org/docs/9.5/functions-aggregate.html): > > > . The arguments to the GROUPING operation are not actually evaluated, but they...

How to understand **Inference** ？Which abilities does it refer to?

> Marking as a draft to make it clear this PR isn't waiting on feedback anymore (I am trying to reduce the outstanding PR review queue) Is this PR not...

> It seems like this PR is failing a CI check: https://github.com/apache/datafusion/actions/runs/8771259487/job/24068788239?pr=10054 I originally intended to modify the Cargo.lock after it was approved. 😅

> Sorry @JasonLi-cn -- marking as ready for review so we can give it another look It doesn't matter. For this PR, I personally think it is valuable, but in...

> The plan looks like aliasing to the same name after `optimize_projections` > > ``` > Projection: test.a AS test.a > TableScan: test projection=[a] > ``` > > I wonder...