Dmitry Novik
Dmitry Novik
> Support setting optimize_monotonous_functions_in_order_by. It seems that this optimization doesn't worth reimplementation. Right now it's disabled by default because it can break read in order optimization. It's impossible to implement...
AFAIU the tests fail because of `WITH TOTALS`. I think it's okay to just update reference files.
@azat What do you mean? Both tests in `Fast tests` check are failed due to how we handle constants in TOTALS pocket.
It's unrelated to the analyzer. The problem is about the execution of PREWHERE clause. Sometimes PrewhereInfo is incorrect. Reproduction with old analyzer: ```sql CREATE TABLE data_02051__fuzz_33 ( `key` Date, `value`...
Hi @petermartens1992! Could you please provide scheme of `abc.organizations`? It's hard to reproduce without it. Also, do you use `allow_experimental_analyzer`?
Thank you for a good description! I noticed a similar problem with other functions. The problem is that constant-folding takes place on shards and it changes the header. I'm trying...
@jrdi @Algunenano I was keeping this issue opened because I want to add a test.
To begin with code review it requires to add a performance test.
> How to add performance test? Please see the documentation: https://clickhouse.com/docs/en/development/tests#performance-tests
> Is there a plan to re-enable EXPLAIN SYNTAX with new analyzer is used? https://github.com/ClickHouse/ClickHouse/pull/61059 @SuzyWangIBMer what do you mean? I'm gonna try to use new analyzer in `EXPLAIN SYNTAX`...