Qingqing Zhou

filter the same: say filter involves a subquery - currently we push it all the way down but say there is a join filtered out many of rows, then we...

CI indicates ubuntu does not like this but windows is ok

what's the query?

let's start with sampling based ANALYZE command implmentation.

Here is how I think it can implemented: 1. Introduce a sampling scan (vs. current full scan with LogicTableScan/PhysicTableScan) , both logic and physic node; 2. Use sampling scan for...

@zhouruiapple you can start with more PhysicNode coverage.

> But we express logical plans in the following way Where did you get this? Is this some ToString() output? ToString() is a simplified output of actual plan. See how...

Nope, results verification only need regular Postures. We only compare results as plan surely can be different. For example, we can expand correlated sub queries but PG cannot.

## algebrizer - sql = "select * from a where a1> (select b2 from b where a1b1);"; * Correct behavior. Changed the error message to "subquery must return only one...

more： - sql = "select a1, (select count(b2) from b where b1=a1 and b2>2), (select count(b2) from b where b1=a1 and b3>3) from a;"; working if change second count(b2) =>...