cloudberry

cloudberry copied to clipboard

[AQUMV] Answer Aggregation Query Directly.

1

This commits enable answer query which has aggregation directly. Use the results of view has aggregations to avoid compute those from origin table. This may lead to significant efficiency gains...

avamingli

[AQUMV]Enable answer query using Materialized View for external table.

6

Allow answer query using materialized views which have external or foreign tables. Since we don't know if the data is up to date of externel table outside CBDB, introduce a...

avamingli

A compile error will occur when --disable-faultinjector option is added to the compilation parameters. Discussion: https://github.com/cloudberrydb/cloudberrydb/issues/555 fix #ISSUE_Number --- ### Change logs _Describe your change clearly, including what problem is...

roseduan

WIP: ORCA: Fix eliminate self comparison

2

For the below query ``` create table t1(a int, b int not null); create table t2(like t1); select t1.*, t2.* from t1 full join t2 on false where (t1.b <...

fanfuxiaoran

Fix REFRESH fast path.

1

If a table is vacuum or clutered, we should not avoid REFRESH for mvs have it. Else, if it's a partition or partitioned now and later, we could not use...

avamingli

[Bug] max_statement_mem not enforced

2

### Cloudberry Database version I've tested this in 1.5.4, 1.6.0, and the latest main branch all with the same results ### What happened Currently it seems that Cloudberry doesn't actually...

antoniopetrole

In this commit, fix gpdirtable can not specify file name. We can specify file name using two match mode, full match and regex match. Full match using for download one...

zhangwenchao-123

[Bug] orca cannot generate a plan for query 'select t1.*, t2.* from t1 full join t2 on false where (t1.b < t1.b) is null'

1

### Cloudberry Database version ``` create table t1(a int, b int); create table t2(like t1); select t1.*, t2.* from t1 full join t2 on false where (t1.b < t1.b) is...

fanfuxiaoran

[Bug] ORCA fallbacks for collate "C"

3

### Cloudberry Database version _No response_ ### What happened Currently, when column attribute of table is collate "C", ORCA would fallback. We need to support it in ORCA also, because...

my-ship-it

[Bug] Optimizer could choose HashAggregate to dedup based on cost.

23

### Cloudberry Database version main ### What happened Optimizer could produce better plan to dedup based on cost. ### What you think should happen instead _No response_ ### How to...

my-ship-it