hsyuan

``` cmake-build-debug/server/gporca_test -d ../../data/dxl/minidump/JoinPlanWithRedistribute.mdp -T 101001 ``` ``` Unfreed memory in memory pool 0x7f827f17b8e0: 2308 objects leaked Failed assertion: !"leak detected"", Unexpected exception reached top of execution stack: major=1 minor=2...

Orca plan: ``` postgres=# explain analyze select a > ANY (select a from bar where b foo.b) from foo; QUERY PLAN ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Gather Motion 2:1 (slice3; segments: 2) (cost=0.00..1417733.45 rows=1000...

The query is extracted from issue #354. I don't see the necessity of having 2 aggregates in 1 slice. ```sql create table sale(sales_id int, product_id int, quantity int); create table...

Orca generates subplan for uncorrelated subquery

2

Repro: ```sql create table foo(a int, b int); create table bar(a int, b int); explain select * from foo where a >= (select avg(b) from bar); QUERY PLAN -------------------------------------------------------------------------------------------------- Result...

In function `CCostModelGPDB::CostHashJoin`, it uses `if (dRowsInner * dWidthInner

Most of logical/physical operators are immutable. We can safely cache the hash value to avoid redundant calculating.

It is causing performance issue since Orca is not multi-threaded in production. Is it ok to remove it?

Repro: ```sql create table foo(a varchar, b int, c int) distributed by(a,b); create table bar(a varchar, b int, c int) distributed by(a,b); create table zoo(a varchar, b int, c int)...

Orca doesn't pick up index with expression

1

Repro: ```sql create table R(a int, b int); create table S(a int, b int); create index s_idx_afun on S(sqrt(a)); set optimizer_enable_hashjoin=off; set enable_hashjoin=off; -- for planner explain select * from...

Repro: ```sql create table foo(a varchar, b oid); explain select * from foo t1, foo t2 where t1.a::int = t2.b::int; ``` Output messages: ``` LOG: 2018-01-16 21:03:23:574312 CST,THD000,ERROR,"Lookup of object...