kryonix / kryonix.github.io Goto Github PK

Dear Denis Hirn,

Excuse me for bothering you, but since I have been banned by the duck db team, I would like to ask for your advice. I hope you don't mind.

Your PR has indeed solved my problem duckdb/duckdb#10451, but there is another one duckdb/duckdb#10001.

WITH t AS MATERIALIZED( SELECT i, i*i*i*i*i AS i5 FROM range(1,150)t(i) ) SELECT a.i, b.i, c.i, d.i, e.i FROM t a, t b, t c, t
 d, t e WHERE a.i < b.i AND b.i < c.i AND c.i < d.i AND d.i < e.i AND a.i5 + b.i5 + c.i5 + d.i5 = e.i5;

No matter how the number of threads is set, version 0.10 is never as fast as version 0.92. Is there any good way?