Marcos Antonio Vaz Salles
Marcos Antonio Vaz Salles
We have observed in connection with PR #14031 a few more naming inconsistencies that could be considered as part of this issue: - `mz_materialization_dependencies` has a column termed `dataflow` that...
Indeed the case we are seeing looks pretty much in line with the explanation in https://github.com/MaterializeInc/materialize/issues/20405#issuecomment-1658221268.
The most recent plan of [TPC-H Q16](https://github.com/MaterializeInc/materialize/blob/bcc04a87d6a1d92df5bb819eca75b3fb811ab985/misc/python/materialize/optbench/workload/tpch.sql#L422-L452) includes an antijoin pattern: ``` Explained Query: + Finish order_by=[#3 desc nulls_first, #0 asc nulls_last, #1 asc nulls_last, #2 asc nulls_last] output=[#0..=#3] +...
Another repro for this issue is reported here: https://github.com/MaterializeInc/materialize/issues/18645#issuecomment-1722977609
And another repro is in https://github.com/MaterializeInc/materialize/issues/22234.