Flattened expressions - so that AND never contains a child that is
AND, and OR never contains a child that is OR - is a canonized form
that seems to have more advantages than disadvantages. It's never
larger than the original (unlike CNF and DNF), frequently smaller than
the original, doesn't take
Julian Hyde created CALCITE-5914:
Summary: Cache compiled regular expressions in SQL function runtime
Key: CALCITE-5914
URL: https://issues.apache.org/jira/browse/CALCITE-5914
Project: Calcite
Hello,
I’m curious about why Filter requires that the condition be a flattened tree?
We have some transformations which occasionally result in non-flat trees, which
causes issues for us in testing.
I know we can avoid this by constructing expressions using RelBuilder or the
Thanks. I am planning to go through this operator and follow your
suggestions to handle my business.
On Wed, Aug 9, 2023 at 11:46 James Starr wrote:
> Alternatively, you could post-process the results after all the
> optimizations are performed. It is not a great deal of work to write a
>