nrainer-materialize

@ggevay: A further case for the sake of completeness. It is known that constant folding produces a result in some cases where dataflow-rendering fails because of shortcuts that constant folding...

Further `COALESCE` example (data-flow rendering evaluates other params and fails at invalid regex, constant folding does not): ``` DROP TABLE IF EXISTS dataflow_rendering; CREATE TABLE dataflow_rendering (row_index INT, bool_true BOOL,...

Further case: Join with join constraint and where condition. In the following query, constant folding seems to prioritize the WHERE condition in contrast to data-flow rendering, which potentially evaluates the...

Well, the point is that the evaluation of the join condition fails. Constant folding does not / no longer evaluate that. That's my assumption based on the error message `"0001-02-03...

Please let QA know when this PR is ready, thank you! 😀

I triggered a [nightly build:](https://buildkite.com/materialize/nightlies/builds/6314) Do we expect any performance impact from this PR? Benchmarks and the scalability framework are failing...

I triggered a [nightly build](https://buildkite.com/materialize/nightlies/builds/6503) and a [coverage build](https://buildkite.com/materialize/coverage/builds/357); I will report the results when they are ready. 😀

> I triggered a [nightly build](https://buildkite.com/materialize/nightlies/builds/6503) and a [coverage build](https://buildkite.com/materialize/coverage/builds/357); I will report the results when they are ready. 😀 As already noted by @mjibson, the [feature benchmark](https://buildkite.com/materialize/nightlies/builds/6503#018db356-76dc-4702-802a-019e37ac3940) and [scalability...

I triggered a [nightly](https://buildkite.com/materialize/nightlies/builds/6454) and [coverage](https://buildkite.com/materialize/coverage/builds/355) build; I will report the results when they are ready.

> I triggered a [nightly](https://buildkite.com/materialize/nightlies/builds/6454) and [coverage](https://buildkite.com/materialize/coverage/builds/355) build; I will report the results when they are ready. Nightly looks good. I will annotate coverage results inline.