zzwwhh

The purpose of subquery coalescing is to combine equivalent semi- and anti-join subqueries into a single query block. The main reason for applying this heuristic-based query transformation, is to reduce...

maybe this is a rbo opt

``` 2022-07-15 14:05:00:168817 CST,THD000,TRACE," (28) normalize expression again EXPR: +--CLogicalSelect |--CLogicalGet "t1" ("t1"), Columns: ["k1" (0), "c1" (1), ...] Key sets: {[2,8]} +--CScalarBoolOp (EboolopAnd) |--CScalarCmp (

@kainwen Hi, gpdb is good for OLAP, so the reason why I close it is that in OLAP PRIMARY KEY index maybe useless, so maybe not worth doing join pruning...

https://blog.jooq.org/10-cool-sql-optimisations-that-do-not-depend-on-the-cost-model/ @gpopt

@sitano Do you understand the second test case of buffer_pool_manager_test.cpp?

> > Do you understand the second test case of buffer_pool_manager_test.cpp? > > @iwanttbepowerful the `TEST(BufferPoolManagerTest, DISABLED_SampleTest) {` one? > > It that's the one, then yes. Ask what you...

try add this after `select` ```sql /*+SET_VAR(disable_nereids_rules='TRANSPOSE_LOGICAL_SEMI_JOIN_AGG_PROJECT, TRANSPOSE_LOGICAL_SEMI_JOIN_AGG')*/ ``` @wmtbnbo